diff options
author | unknown <bar@bar.mysql.r18.ru> | 2003-03-27 13:09:09 +0400 |
---|---|---|
committer | unknown <bar@bar.mysql.r18.ru> | 2003-03-27 13:09:09 +0400 |
commit | 8bbbd1d6f84740e1def5d34251f1942c19805543 (patch) | |
tree | cf02a1f110ca4ad00d79000f82123c306165adf0 /mysql-test/r/gis.result | |
parent | 27e77a8fd6f5531e64557c20d594b85050df96b6 (diff) | |
download | mariadb-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.result | 32 |
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)')), |