diff options
| author | unknown <mskold@mysql.com> | 2005-03-07 10:21:38 +0100 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2005-03-07 10:21:38 +0100 |
| commit | 8e8dfe43db45875306d06d5c1d882c86a68b6b3a (patch) | |
| tree | b06b6684ff4122901b911545b8f54f0d438e308e /mysql-test/t/ndb_alter_table.test | |
| parent | ae81d53048643da4b110c936eaec0a895af06219 (diff) | |
| download | mariadb-git-8e8dfe43db45875306d06d5c1d882c86a68b6b3a.tar.gz | |
Fix for Bug #8753 Invalid schema object version after dropping index
Diffstat (limited to 'mysql-test/t/ndb_alter_table.test')
| -rw-r--r-- | mysql-test/t/ndb_alter_table.test | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/mysql-test/t/ndb_alter_table.test b/mysql-test/t/ndb_alter_table.test index 892443a1407..f39edc0ee65 100644 --- a/mysql-test/t/ndb_alter_table.test +++ b/mysql-test/t/ndb_alter_table.test @@ -1,4 +1,5 @@ -- source include/have_ndb.inc +-- source include/have_multi_ndb.inc --disable_warnings DROP TABLE IF EXISTS t1; @@ -133,6 +134,21 @@ INSERT INTO t1 VALUES (1,2,0),(18,19,4),(20,21,0); select c from t1 order by c; drop table t1; +create table t1 ( a int primary key, b varchar(10), c varchar(10), index (b) ) +engine=ndb; +insert into t1 values (1,'one','one'), (2,'two','two'), (3,'three','three'); +create index c on t1(c); +connection server2; +select * from t1 where b = 'two'; +connection server1; +alter table t1 drop index c; +connection server2; +--error 1146 +select * from t1 where b = 'two'; +select * from t1 where b = 'two'; +connection server1; +drop table t1; + #--disable_warnings #DROP TABLE IF EXISTS t2; #--enable_warnings |