summaryrefslogtreecommitdiff
path: root/mysql-test/t/gis.test
diff options
context:
space:
mode:
authorMagne Mahre <magne.mahre@oracle.com>2011-02-24 12:56:34 +0100
committerMagne Mahre <magne.mahre@oracle.com>2011-02-24 12:56:34 +0100
commitc4108ce3febcae397521f0643a8e0732f50eb3b6 (patch)
tree53de31371e3aec7fa21c35ce2f3c32e4f0cf6488 /mysql-test/t/gis.test
parent2109548552ca668f329dc3ffafee9662b19346aa (diff)
parent27166fc64f54ef82f1800988ffff431868377645 (diff)
downloadmariadb-git-c4108ce3febcae397521f0643a8e0732f50eb3b6.tar.gz
Merge from mysql-5.1-security
Diffstat (limited to 'mysql-test/t/gis.test')
-rw-r--r--mysql-test/t/gis.test10
1 files changed, 8 insertions, 2 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test
index 7ca364d935c..520da7e62c9 100644
--- a/mysql-test/t/gis.test
+++ b/mysql-test/t/gis.test
@@ -762,7 +762,14 @@ drop table t1;
#
# Bug #50574 5.5.x allows spatial indexes on non-spatial
# columns, causing crashes!
+# Bug#11767480 SPATIAL INDEXES ON NON-SPATIAL COLUMNS
+# CAUSE CRASHES.
#
+CREATE TABLE t0 (a BINARY(32) NOT NULL);
+--error ER_SPATIAL_MUST_HAVE_GEOM_COL
+CREATE SPATIAL INDEX i on t0 (a);
+INSERT INTO t0 VALUES (1);
+
--error ER_SPATIAL_MUST_HAVE_GEOM_COL
CREATE TABLE t1(
col0 BINARY NOT NULL,
@@ -800,6 +807,5 @@ CREATE TABLE t3 (
);
# cleanup
-DROP TABLE t1;
-DROP TABLE t2;
+DROP TABLE t0, t1, t2;