summaryrefslogtreecommitdiff
path: root/mysql-test/t/gis.test
diff options
context:
space:
mode:
authorunknown <holyfoot/hf@hfmain.(none)>2007-11-24 14:57:51 +0400
committerunknown <holyfoot/hf@hfmain.(none)>2007-11-24 14:57:51 +0400
commitff5120f0fe52264ca276767554439cb3ba48d46a (patch)
treebd8c719a9b0becd61cd45d10ab90993b5dba82bc /mysql-test/t/gis.test
parent13c64257d99dd9c41ac33ecbcac8086e3f2eabbe (diff)
parente4dc9a8e6e13405859afda2d472e4cc4b6dc169c (diff)
downloadmariadb-git-ff5120f0fe52264ca276767554439cb3ba48d46a.tar.gz
Merge mysql.com:/home/hf/work/30284/my50-30284
into mysql.com:/home/hf/work/30284/my51-30284 mysql-test/r/gis.result: Auto merged mysql-test/t/gis.test: Auto merged storage/myisam/mi_check.c: Auto merged
Diffstat (limited to 'mysql-test/t/gis.test')
-rw-r--r--mysql-test/t/gis.test11
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test
index b4c515d2e8c..9fa1e1c47ff 100644
--- a/mysql-test/t/gis.test
+++ b/mysql-test/t/gis.test
@@ -440,6 +440,17 @@ INSERT INTO `t1` VALUES ('','0000-00-00');
select geomfromtext(col9,col89) as a from t1;
DROP TABLE t1;
+#
+# Bug #30284 spatial key corruption
+#
+
+create table t1(col1 geometry default null,col15 geometrycollection not
+null,spatial index(col15),index(col1(15)))engine=myisam;
+insert into t1 set col15 = GeomFromText('POINT(6 5)');
+insert into t1 set col15 = GeomFromText('POINT(6 5)');
+check table t1 extended;
+drop table t1;
+
--echo End of 4.1 tests
#