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/t/gis.test | |
| 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/t/gis.test')
| -rw-r--r-- | mysql-test/t/gis.test | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index f4b6138c86f..179dd12e6a3 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -15,6 +15,16 @@ 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; +SHOW FIELDS FROM ls; +SHOW FIELDS FROM p; +SHOW FIELDS FROM mpt; +SHOW FIELDS FROM mls; +SHOW FIELDS FROM mp; +SHOW FIELDS FROM gc; +SHOW FIELDS FROM geo; + + INSERT INTO pt VALUES (101, PointFromText('POINT(10 10)')), (102, PointFromText('POINT(20 10)')), |