summaryrefslogtreecommitdiff
path: root/mysql-test/r/gis.result
diff options
context:
space:
mode:
authorunknown <bar@bar.mysql.r18.ru>2003-03-27 13:09:09 +0400
committerunknown <bar@bar.mysql.r18.ru>2003-03-27 13:09:09 +0400
commit8bbbd1d6f84740e1def5d34251f1942c19805543 (patch)
treecf02a1f110ca4ad00d79000f82123c306165adf0 /mysql-test/r/gis.result
parent27e77a8fd6f5531e64557c20d594b85050df96b6 (diff)
downloadmariadb-git-8bbbd1d6f84740e1def5d34251f1942c19805543.tar.gz
More OpenGIS compatibility:
Point, MultiLine, Poligom, etc, are now not aliases for Geometry, but separate field types.
Diffstat (limited to 'mysql-test/r/gis.result')
-rw-r--r--mysql-test/r/gis.result32
1 files changed, 32 insertions, 0 deletions
diff --git a/mysql-test/r/gis.result b/mysql-test/r/gis.result
index 9118fa8cfed..3771245bff9 100644
--- a/mysql-test/r/gis.result
+++ b/mysql-test/r/gis.result
@@ -7,6 +7,38 @@ CREATE TABLE mls (fid INTEGER NOT NULL PRIMARY KEY, g MULTILINESTRING);
CREATE TABLE mp (fid INTEGER NOT NULL PRIMARY KEY, g MULTIPOLYGON);
CREATE TABLE gc (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRYCOLLECTION);
CREATE TABLE geo (fid INTEGER NOT NULL PRIMARY KEY, g GEOMETRY);
+SHOW FIELDS FROM pt;
+Field Type Collation Null Key Default Extra
+fid int(11) binary PRI 0
+g point binary YES NULL
+SHOW FIELDS FROM ls;
+Field Type Collation Null Key Default Extra
+fid int(11) binary PRI 0
+g linestring binary YES NULL
+SHOW FIELDS FROM p;
+Field Type Collation Null Key Default Extra
+fid int(11) binary PRI 0
+g polygon binary YES NULL
+SHOW FIELDS FROM mpt;
+Field Type Collation Null Key Default Extra
+fid int(11) binary PRI 0
+g multipoint binary YES NULL
+SHOW FIELDS FROM mls;
+Field Type Collation Null Key Default Extra
+fid int(11) binary PRI 0
+g multilinestring binary YES NULL
+SHOW FIELDS FROM mp;
+Field Type Collation Null Key Default Extra
+fid int(11) binary PRI 0
+g multipolygon binary YES NULL
+SHOW FIELDS FROM gc;
+Field Type Collation Null Key Default Extra
+fid int(11) binary PRI 0
+g geometrycollection binary YES NULL
+SHOW FIELDS FROM geo;
+Field Type Collation Null Key Default Extra
+fid int(11) binary PRI 0
+g geometry binary YES NULL
INSERT INTO pt VALUES
(101, PointFromText('POINT(10 10)')),
(102, PointFromText('POINT(20 10)')),