summaryrefslogtreecommitdiff
path: root/mysql-test/t/gis.test
diff options
context:
space:
mode:
authorAlexey Botchkov <holyfoot@askmonty.org>2014-07-01 00:30:24 +0500
committerAlexey Botchkov <holyfoot@askmonty.org>2014-07-01 00:30:24 +0500
commit80a02037df1e65168a150b4dcd21822bfc14b71a (patch)
tree0b085ce90a49f95ffc83e9ba6d52b8423497164b /mysql-test/t/gis.test
parent439f75f849b9ab63fc65e2bd37af5c3429ffc1da (diff)
downloadmariadb-git-80a02037df1e65168a150b4dcd21822bfc14b71a.tar.gz
MDEV-6073 Merge gis test cases form 5.6.
Tests were merged. As the implementation is different, the 'internal debugging' part was not merged, only a stub for it created.
Diffstat (limited to 'mysql-test/t/gis.test')
-rw-r--r--mysql-test/t/gis.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test
index c38706959e4..d20e4c1711e 100644
--- a/mysql-test/t/gis.test
+++ b/mysql-test/t/gis.test
@@ -541,6 +541,18 @@ insert into t1 values(default);
drop table t1;
#
+# Bug #27300: create view with geometry functions lost columns types
+#
+CREATE TABLE t1 (a GEOMETRY);
+CREATE VIEW v1 AS SELECT GeomFromwkb(ASBINARY(a)) FROM t1;
+CREATE VIEW v2 AS SELECT a FROM t1;
+DESCRIBE v1;
+DESCRIBE v2;
+
+DROP VIEW v1,v2;
+DROP TABLE t1;
+
+#
# Bug#24563: MBROverlaps does not seem to function propertly
# Bug#54888: MBROverlaps missing in 5.1?
#