diff options
| author | gkodinov/kgeorge@magare.gmz <> | 2007-03-12 17:08:42 +0200 |
|---|---|---|
| committer | gkodinov/kgeorge@magare.gmz <> | 2007-03-12 17:08:42 +0200 |
| commit | 3542315de6626afb8dd8e55645422723f3e5cced (patch) | |
| tree | 586b19888087cca17d4238751e68fee88c0e0c0e /mysql-test/t/alter_table.test | |
| parent | f2ce1445e13f82a9f005c980146a29f99e5a92ff (diff) | |
| parent | 36d2a231e31dcdf1dc0194a3c98e9160cb7a5ba3 (diff) | |
| download | mariadb-git-3542315de6626afb8dd8e55645422723f3e5cced.tar.gz | |
Merge magare.gmz:/home/kgeorge/mysql/work/B26794-5.0-opt
into magare.gmz:/home/kgeorge/mysql/work/B26794-5.1-opt
Diffstat (limited to 'mysql-test/t/alter_table.test')
| -rw-r--r-- | mysql-test/t/alter_table.test | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/t/alter_table.test b/mysql-test/t/alter_table.test index 297813dfead..5844119ac92 100644 --- a/mysql-test/t/alter_table.test +++ b/mysql-test/t/alter_table.test @@ -642,6 +642,29 @@ alter table t1 change t t text; drop table t1; # +# Bug #26794: Adding an index with a prefix on a SPATIAL type breaks ALTER +# TABLE +# +CREATE TABLE t1 (a varchar(500)); + +ALTER TABLE t1 ADD b GEOMETRY NOT NULL, ADD SPATIAL INDEX(b); +SHOW CREATE TABLE t1; +ALTER TABLE t1 ADD KEY(b(50)); +SHOW CREATE TABLE t1; + +ALTER TABLE t1 ADD c POINT; +SHOW CREATE TABLE t1; + +--error ER_WRONG_SUB_KEY +CREATE TABLE t2 (a INT, KEY (a(20))); + +ALTER TABLE t1 ADD d INT; +--error ER_WRONG_SUB_KEY +ALTER TABLE t1 ADD KEY (d(20)); + +DROP TABLE t1; + +# # Bug#18038 MySQL server corrupts binary columns data # |