Debian Codegraph @

mysql-test/suite/ndb/r/ndb_alter_table_online_multi.result

raw
1 *******************************
2 * basic concurent online alter test
3 *******************************
4 * With Commit
5 *******************************
6 CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ENGINE NDB;
7 begin;
8 update t1 set b = 0 where a = 1;
9 update t1 set b = 1 where a = 2;
10 delete from t1 where a = 3;
11 insert into t1 values (5,5),(6,6);
12 update t1 set b = 0 where a = 6;
13 ALTER TABLE t1 ADD c CHAR(19), ADD d VARCHAR(255), ADD e char(255);
14 Warnings:
15 Warning 1478 Converted FIXED field 'c' to DYNAMIC to enable online ADD COLUMN
16 Warning 1478 Converted FIXED field 'd' to DYNAMIC to enable online ADD COLUMN
17 Warning 1478 Converted FIXED field 'e' to DYNAMIC to enable online ADD COLUMN
18 Warning 1296 Node <nodeid> 'Distribution of ALTER TABLE 't1' failed'
19 update t1 set b = 0 where a = 2;
20 ERROR HY000: Table definition has changed, please retry transaction
21 show warnings;
22 Level Code Message
23 Error 1412 Table definition has changed, please retry transaction
24 Warning 1296 Failed to discover table 't1' from NDB, not allowed in active transaction
25 Error 1412 Table definition has changed, please retry transaction
26 rollback;
27 SELECT * FROM t1 ORDER BY a;
28 a b c d e
29 1 1 NULL NULL NULL
30 2 2 NULL NULL NULL
31 3 3 NULL NULL NULL
32 4 4 NULL NULL NULL
33 DROP TABLE t1;