diff options
| author | Georgi Kodinov <joro@sun.com> | 2009-12-11 16:02:47 +0200 |
|---|---|---|
| committer | Georgi Kodinov <joro@sun.com> | 2009-12-11 16:02:47 +0200 |
| commit | 97620e3ba8353b62e90c56f800b230a7ebd15e4f (patch) | |
| tree | b0429a55cc7533019dbc37b87f53a7608686cf95 /mysql-test/t/gis.test | |
| parent | 7b174dcafcab24582f7d3f255482bcc460e6b451 (diff) | |
| parent | 30e51fe8540026f00c2c599098257c1e33c9b94f (diff) | |
| download | mariadb-git-97620e3ba8353b62e90c56f800b230a7ebd15e4f.tar.gz | |
merge of bug #49250 to 5.1-bugteam
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 2d10c3bf1e1..bc0695aaa93 100644 --- a/mysql-test/t/gis.test +++ b/mysql-test/t/gis.test @@ -670,6 +670,21 @@ 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 |