1 -- source include/have_multi_ndb.inc
2 -- source include/not_embedded.inc
3 -- source include/have_binlog_format_mixed_or_row.inc
8 drop table if exists t1, t2, t3, t4;
11 drop table if exists t1, t2, t3, t4;
16 # Create test tables on server1
17 create table t1 (a int) engine=ndbcluster;
18 create table t2 (a int) engine=ndbcluster;
19 insert into t1 value (2);
20 insert into t2 value (3);
23 show status like 'handler_discover%';
25 # Check dropping and recreating table on same server
26 connect (con1,localhost,root,,test);
27 connect (con2,localhost,root,,test);
32 create table t1 (a int) engine=ndbcluster;
33 insert into t1 value (2);
37 # Check dropping and recreating table on different server
39 show status like 'handler_discover%';
41 create table t1 (a int) engine=ndbcluster;
42 insert into t1 value (2);
44 ## Currently a retry is required remotely
49 # Table definition change should be propagated automatically
52 # Connect to server2 and use the tables from there
56 update t1 set a=3 where a=2;
57 show status like 'handler_discover%';
59 # Create a new table on server2
60 create table t3 (a int not null primary key, b varchar(22),
61 c int, last_col text) engine=ndb;
62 insert into t3 values(1, 'Hi!', 89, 'Longtext column');
63 create table t4 (pk int primary key, b int) engine=ndb;
65 # Check that the tables are accessible from server1
69 show tables like 't4';
72 drop table t1, t2, t3, t4;
74 drop table if exists t1, t3, t4;