# # Test failure to create NDB_SHARE during CREATE TABLE # - should fail the create table set @save_debug = @@session.debug; SET SESSION debug="+d,ndb_share_create_fail1"; CREATE TABLE t1( id INT PRIMARY KEY, val INT ) ENGINE=ndbcluster; ERROR HY000: Can't create table 't1' SHOW WARNINGS; Level Code Message Warning 1037 Failed to acquire NDB_SHARE Error 1005 Can't create table 't1' SET SESSION debug=@save_debug; # - check that table can be created, this also checks # that the above failed create properly removed the # table from NDB as well. CREATE TABLE t1( id INT PRIMARY KEY, val INT ) ENGINE=ndbcluster; # - cleanup and remove the table DROP TABLE t1; # # Test failure to open the NDB table during create. # NOTE! This is very unlikely and should only # happen at cluster failure. SET SESSION debug="+d,ndb_create_open_fail"; CREATE TABLE t1(a int primary key) engine = NDB; ERROR HY000: Can't create table 't1' SHOW WARNINGS; Level Code Message Warning 1296 Got error 723 'No such table existed' from NDB Error 1005 Can't create table 't1' SET SESSION debug=@save_debug; # Check that table does not exist SELECT * FROM t1; ERROR 42S02: Table 'test.t1' doesn't exist