summaryrefslogtreecommitdiff
path: root/mysql-test/t/gis.test
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2015-04-28 15:31:49 +0500
committerAlexey Botchkov <holyfoot@askmonty.org>2015-04-28 15:31:49 +0500
commita5fa434d0cec39b0db9f67ae2d6a824e2e53e39d (patch)
tree101d6c0bfc54a3de5d24e10a03ef1d15190b8104 /mysql-test/t/gis.test
parent4c174fcb4aa0ad7173e0e19fb9c7f26e95903187 (diff)
downloadmariadb-git-a5fa434d0cec39b0db9f67ae2d6a824e2e53e39d.tar.gz
MDEV-7779 View definition changes upon creation.
Fixed by using POINT instead of ST_POINT in the item. Later need to fix that with proper ST_POINT implementation
Diffstat (limited to 'mysql-test/t/gis.test')
-rw-r--r--mysql-test/t/gis.test11
1 files changed, 10 insertions, 1 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test
index bce1fa2c226..6e41660d598 100644
--- a/mysql-test/t/gis.test
+++ b/mysql-test/t/gis.test
@@ -7,6 +7,7 @@
--disable_warnings
DROP TABLE IF EXISTS t1, gis_point, gis_line, gis_polygon, gis_multi_point, gis_multi_line, gis_multi_polygon, gis_geometrycollection, gis_geometry;
+DROP VIEW IF EXISTS v1;
--enable_warnings
CREATE TABLE gis_point (fid INTEGER NOT NULL PRIMARY KEY, g POINT);
@@ -1470,4 +1471,12 @@ drop table t1;
#
SELECT st_astext(ST_Buffer(ST_PolygonFromText('POLYGON((3 5, 2 4, 2 5, 3 5))'), -100));
---echo End of 5.5 tests
+#
+# MDEV-7779 View definition changes upon creation
+#
+CREATE VIEW v1 AS SELECT POINT(1,1) AS p;
+SHOW CREATE VIEW v1;
+SELECT ASTEXT(p) FROM v1;
+DROP VIEW v1;
+
+# --echo End of 5.5 tests