Debian Codegraph @

mysql-test/suite/ndb_ddl/create_table_select_fail.result

raw
1 #
2 # WL#12936 Implement DDL transaction context logger in ndbcluster
3 # Test failure after the create has been distributed to other servers.
4 #
5 # Setup
6 CREATE TABLE t1 (
7 a int,
8 b int
9 ) ENGINE NDB;
10 INSERT INTO t1 VALUES (1, NULL);
11 # Create should fail when copying rows
12 CREATE TABLE t2 (
13 a int,
14 b int not null
15 ) ENGINE NDB
16 AS SELECT * FROM t1;
17 ERROR 23000: Column 'b' cannot be null
18 # Verify that table does not exist
19 SELECT * FROM t2;
20 ERROR 42S02: Table 'test.t2' doesn't exist
21 # Cleanup
22 DROP TABLE t1;
23 # Verify that the table is not present in any other server
24 # and all the shares have been properly dropped.
25 SELECT * FROM t2;
26 ERROR 42S02: Table 'test.t2' doesn't exist
27 set global ndb_dbg_check_shares=1;
28 SELECT * FROM t2;
29 ERROR 42S02: Table 'test.t2' doesn't exist
30 set global ndb_dbg_check_shares=1;
31 SELECT * FROM t2;
32 ERROR 42S02: Table 'test.t2' doesn't exist
33 set global ndb_dbg_check_shares=1;
34 SELECT * FROM t2;
35 ERROR 42S02: Table 'test.t2' doesn't exist
36 set global ndb_dbg_check_shares=1;
37 SELECT * FROM t2;
38 ERROR 42S02: Table 'test.t2' doesn't exist
39 set global ndb_dbg_check_shares=1;
40 SELECT * FROM t2;
41 ERROR 42S02: Table 'test.t2' doesn't exist
42 set global ndb_dbg_check_shares=1;