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