diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-12-10 11:28:38 +0200 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-12-10 11:28:38 +0200 |
| commit | 30e51fe8540026f00c2c599098257c1e33c9b94f (patch) | |
| tree | f38546a01badb3a2a1241fb2a1992ae1258932f7 /mysql-test/t/gis.test | |
| parent | bd308d1256fa7af7128c24f4a5e2abfb8274437a (diff) | |
| download | mariadb-git-30e51fe8540026f00c2c599098257c1e33c9b94f.tar.gz | |
Bug #49250 : spatial btree index corruption and crash
SPATIAL and FULLTEXT indexes don't support algorithm
selection.
Disabled by creating a special grammar rule for these
in the parser.
Added some encasulation of duplicate parser code.
Diffstat (limited to 'mysql-test/t/gis.test')
| -rw-r--r-- | mysql-test/t/gis.test | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/mysql-test/t/gis.test b/mysql-test/t/gis.test index 701a6cef6be..d2bfe7d90d4 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -669,5 +669,20 @@ SELECT 1 FROM t1 WHERE a <> (SELECT GEOMETRYCOLLECTIONFROMWKB(b) FROM t1); DROP TABLE t1; +--echo # +--echo # Bug #49250 : spatial btree index corruption and crash +--echo # Part one : spatial syntax check +--echo # + +--error ER_PARSE_ERROR +CREATE TABLE t1(col1 MULTIPOLYGON NOT NULL, + SPATIAL INDEX USING BTREE (col1)); +CREATE TABLE t2(col1 MULTIPOLYGON NOT NULL); +--error ER_PARSE_ERROR +CREATE SPATIAL INDEX USING BTREE ON t2(col); +--error ER_PARSE_ERROR +ALTER TABLE t2 ADD SPATIAL INDEX USING BTREE (col1); + +DROP TABLE t2; --echo End of 5.0 tests |