Debian Codegraph @

mysql-test/suite/ndb/t/ndb_alter_table_error.test

raw
1 -- source include/have_multi_ndb.inc
2
3 --echo *******************************
4 --echo * basic concurent online alter test
5 --echo *******************************
6 --echo * With Commit
7 --echo *******************************
8
9 connection server1;
10
11 CREATE TABLE t1 (a INT UNSIGNED,
12 b INT UNSIGNED not null,
13 primary key(a)) ENGINE NDB;
14 let $v=100;
15 disable_query_log;
16 while ($v)
17 {
18 --eval INSERT INTO t1 VALUES($v,$v);
19 dec $v;
20 }
21 enable_query_log;
22
23
24 connection server2;
25 begin;
26 update t1 set b = b + 1 where a = 1;
27
28 connection server1;
29 --error 1205
30 ALTER TABLE t1 algorithm=copy, ADD c CHAR(19);
31
32 connection server2;
33 commit;
34
35 connection server1;
36 --error 0
37 ALTER TABLE t1 algorithm=copy, ADD c CHAR(19);
38
39 connection server1;
40 --error 1169
41 create unique index b_unq on t1(b) using hash;
42
43 update t1 set b = b - 1 where a = 1;
44
45 connection server1;
46 create unique index b_unq on t1(b) using hash;
47
48 DROP TABLE t1;