Debian Codegraph @

mysql-test/suite/ndb_ddl/create_table_fail.result

raw
1 #
2 # Test failure to create NDB_SHARE during CREATE TABLE
3 # - should fail the create table
4 set @save_debug = @@session.debug;
5 SET SESSION debug="+d,ndb_share_create_fail1";
6 CREATE TABLE t1(
7 id INT PRIMARY KEY,
8 val INT
9 )
10 ENGINE=ndbcluster;
11 ERROR HY000: Can't create table 't1' (use SHOW WARNINGS for more info).
12 SHOW WARNINGS;
13 Level Code Message
14 Warning 1037 Failed to acquire NDB_SHARE
15 Error 1005 Can't create table 't1' (use SHOW WARNINGS for more info).
16 SET SESSION debug=@save_debug;
17 # - check that table can be created, this also checks
18 # that the above failed create properly removed the
19 # table from NDB as well.
20 CREATE TABLE t1(
21 id INT PRIMARY KEY,
22 val INT
23 )
24 ENGINE=ndbcluster;
25 # - cleanup and remove the table
26 DROP TABLE t1;
27 #
28 # Test failure to open the NDB table during create.
29 # NOTE! This is very unlikely and should only
30 # happen at cluster failure.
31 SET SESSION debug="+d,ndb_create_open_fail";
32 CREATE TABLE t1(a int primary key) engine = NDB;
33 ERROR HY000: Can't create table 't1' (use SHOW WARNINGS for more info).
34 SHOW WARNINGS;
35 Level Code Message
36 Warning 1296 Got error 723 'No such table existed' from NDB
37 Error 1005 Can't create table 't1' (use SHOW WARNINGS for more info).
38 SET SESSION debug=@save_debug;
39 # Check that table does not exist
40 SELECT * FROM t1;
41 ERROR 42S02: Table 'test.t1' doesn't exist