1 -- source include/have_multi_ndb.inc
2 -- source include/not_embedded.inc
5 DROP TABLE IF EXISTS t1;
9 create table t1 ( a int primary key, b varchar(10), c varchar(10), index (b) )
11 insert into t1 values (1,'one','one'), (2,'two','two'), (3,'three','three');
12 create index c on t1(c);
15 select * from t1 where c = 'two';
17 alter table t1 drop index c;
20 select * from t1 where c = 'two';
25 create table t3 (a int primary key) engine=ndbcluster;
29 insert into t3 values (1);
32 alter table t3 rename t4;
35 # with rbr the below will not work as the "alter" event
36 # explicitly invalidates the dictionary cache.
37 ## This should work as transaction is ongoing...
39 #insert into t3 values (1);
42 # This should fail as its a new transaction