-- source include/have_ndb.inc -- source include/have_multi_ndb.inc -- source include/not_embedded.inc -- source include/have_binlog_format_row.inc --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings connection server1; 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; show indexes from t1; select * from t1 where c = 'two'; connection server1; alter table t1 drop index c; connection server2; show indexes from t1; select * from t1 where c = 'two'; connection server1; drop table t1; connection server1; create table t3 (a int primary key) engine=ndbcluster; connection server2; begin; insert into t3 values (1); connection server1; alter table t3 rename t4; connection server2; # with rbr the below will not work as the "alter" event # explicitly invalidates the dictionary cache. ## This should work as transaction is ongoing... #delete from t3; #insert into t3 values (1); commit; # This should fail as its a new transaction --error 1146 select * from t3; select * from t4; drop table t4; show tables; connection server1;