1show variables like 'log_bin'; 2Variable_name Value 3log_bin ON 4show variables like 'log_bin'; 5Variable_name Value 6log_bin ON 7show variables like 'log_bin'; 8Variable_name Value 9log_bin OFF 10show variables like 'log_bin'; 11Variable_name Value 12log_bin OFF 13create table t1 (a int) engine=ndbcluster; 14drop table t1; 15set global ndb_check_shares=1; 16set global ndb_check_shares=1; 17set global ndb_check_shares=1; 18set global ndb_check_shares=1; 19create table t1 (a int) engine=ndbcluster; 20drop table t1; 21set global ndb_check_shares=1; 22set global ndb_check_shares=1; 23set global ndb_check_shares=1; 24set global ndb_check_shares=1; 25create table t1 (a int) engine=ndbcluster; 26rename table t1 to t2; 27drop table t2; 28set global ndb_check_shares=1; 29set global ndb_check_shares=1; 30set global ndb_check_shares=1; 31set global ndb_check_shares=1; 32create table t1 (a int) engine=ndbcluster; 33rename table t1 to t2; 34drop table t2; 35set global ndb_check_shares=1; 36set global ndb_check_shares=1; 37set global ndb_check_shares=1; 38set global ndb_check_shares=1; 39create table t1 (a int) engine=ndbcluster; 40alter offline table t1 add column b int default 77; 41drop table t1; 42set global ndb_check_shares=1; 43set global ndb_check_shares=1; 44set global ndb_check_shares=1; 45set global ndb_check_shares=1; 46create table t1 (a int) engine=ndbcluster; 47alter offline table t1 add column b int default 77; 48drop table t1; 49set global ndb_check_shares=1; 50set global ndb_check_shares=1; 51set global ndb_check_shares=1; 52set global ndb_check_shares=1; 53create table t1 (a int primary key) engine=ndbcluster 54partition by list(a) (partition p0 values in (0)); 55alter offline table t1 add partition (partition p1 values in (1)); 56drop table t1; 57set global ndb_check_shares=1; 58set global ndb_check_shares=1; 59set global ndb_check_shares=1; 60set global ndb_check_shares=1; 61create table t1 (a int primary key) engine=ndbcluster 62partition by list(a) (partition p0 values in (0)); 63alter offline table t1 add partition (partition p1 values in (1)); 64drop table t1; 65set global ndb_check_shares=1; 66set global ndb_check_shares=1; 67set global ndb_check_shares=1; 68set global ndb_check_shares=1; 69create table t1 (a int primary key) engine=ndbcluster; 70alter online table t1 add column b int column_format dynamic; 71drop table t1; 72set global ndb_check_shares=1; 73set global ndb_check_shares=1; 74set global ndb_check_shares=1; 75set global ndb_check_shares=1; 76create table t1 (a int primary key) engine=ndbcluster; 77alter offline table t1 add column b int column_format dynamic; 78drop table t1; 79set global ndb_check_shares=1; 80set global ndb_check_shares=1; 81set global ndb_check_shares=1; 82set global ndb_check_shares=1; 83create table t1 (a int) engine=ndbcluster; 84create table t2 (a int) engine=ndbcluster; 85rename table t1 to tmp, t2 to t1, tmp to t2; 86drop table t1, t2; 87set global ndb_check_shares=1; 88set global ndb_check_shares=1; 89set global ndb_check_shares=1; 90set global ndb_check_shares=1; 91create table t1 (a int) engine=ndbcluster; 92create table t2 (a int) engine=ndbcluster; 93rename table t1 to tmp, t2 to t1, tmp to t2; 94drop table t1, t2; 95set global ndb_check_shares=1; 96set global ndb_check_shares=1; 97set global ndb_check_shares=1; 98set global ndb_check_shares=1; 99create table t1 (a int) engine=myisam; 100create table t1 (a int) engine=myisam; 101create table t1 (a int) engine = ndb; 102drop table t1; 103set global ndb_check_shares=1; 104set global ndb_check_shares=1; 105set global ndb_check_shares=1; 106set global ndb_check_shares=1; 107create table t1 (a int) engine = ndb; 108drop table t1; 109set global ndb_check_shares=1; 110set global ndb_check_shares=1; 111set global ndb_check_shares=1; 112set global ndb_check_shares=1; 113create table t1 (a int) engine = ndb; 114drop table t1; 115desc t1; 116Field Type Null Key Default Extra 117a int(11) YES NULL 118drop table t1; 119desc t1; 120Field Type Null Key Default Extra 121a int(11) YES NULL 122drop table t1; 123set global ndb_check_shares=1; 124set global ndb_check_shares=1; 125set global ndb_check_shares=1; 126set global ndb_check_shares=1; 127create table t1 (a int) engine=myisam; 128create table t1 (a int) engine=myisam; 129create table t1 (a int) engine = ndb; 130alter offline table t1 add column b int column_format dynamic; 131drop table t1; 132desc t1; 133Field Type Null Key Default Extra 134a int(11) YES NULL 135b int(11) YES NULL 136drop table t1; 137desc t1; 138Field Type Null Key Default Extra 139a int(11) YES NULL 140b int(11) YES NULL 141drop table t1; 142set global ndb_check_shares=1; 143set global ndb_check_shares=1; 144set global ndb_check_shares=1; 145set global ndb_check_shares=1; 146create table t1 (a int) engine=myisam; 147create table t1 (a int) engine=myisam; 148create table t1 (a int primary key) engine = ndb; 149alter online table t1 add column b int column_format dynamic; 150drop table t1; 151desc t1; 152Field Type Null Key Default Extra 153a int(11) NO PRI NULL 154b int(11) YES NULL 155drop table t1; 156desc t1; 157Field Type Null Key Default Extra 158a int(11) NO PRI NULL 159b int(11) YES NULL 160drop table t1; 161set global ndb_check_shares=1; 162set global ndb_check_shares=1; 163set global ndb_check_shares=1; 164set global ndb_check_shares=1; 165create table t1 (a int) engine=myisam; 166create table t1 (a int) engine=myisam; 167create table t1 (a int) engine = ndb; 168rename table t1 to t2; 169desc t2; 170Field Type Null Key Default Extra 171a int(11) YES NULL 172desc t2; 173Field Type Null Key Default Extra 174a int(11) YES NULL 175drop table t2; 176set global ndb_check_shares=1; 177set global ndb_check_shares=1; 178set global ndb_check_shares=1; 179set global ndb_check_shares=1; 180drop table t1; 181drop table t1; 182set global ndb_check_shares=1; 183set global ndb_check_shares=1; 184set global ndb_check_shares=1; 185set global ndb_check_shares=1; 186create table if not exists t1 (a int) engine=ndbcluster; 187create table if not exists t1 (a int) engine=ndbcluster; 188create table if not exists t1 (a int) engine=ndbcluster; 189create table if not exists t1 (a int) engine=ndbcluster; 190drop table t1; 191set global ndb_check_shares=1; 192set global ndb_check_shares=1; 193set global ndb_check_shares=1; 194set global ndb_check_shares=1; 195create table if not exists t1 (a int) engine=ndbcluster; 196create table if not exists t1 (a int) engine=ndbcluster; 197create table if not exists t1 (a int) engine=ndbcluster; 198create table if not exists t1 (a int) engine=ndbcluster; 199drop table t1; 200set global ndb_check_shares=1; 201set global ndb_check_shares=1; 202set global ndb_check_shares=1; 203set global ndb_check_shares=1; 204create table if not exists t1 (a int) engine=ndbcluster; 205create table if not exists t1 (a int) engine=ndbcluster; 206create table if not exists t1 (a int) engine=ndbcluster; 207create table if not exists t1 (a int) engine=ndbcluster; 208drop table t1; 209set global ndb_check_shares=1; 210set global ndb_check_shares=1; 211set global ndb_check_shares=1; 212set global ndb_check_shares=1; 213create table if not exists t1 (a int) engine=ndbcluster; 214create table if not exists t1 (a int) engine=ndbcluster; 215create table if not exists t1 (a int) engine=ndbcluster; 216create table if not exists t1 (a int) engine=ndbcluster; 217drop table t1; 218set global ndb_check_shares=1; 219set global ndb_check_shares=1; 220set global ndb_check_shares=1; 221set global ndb_check_shares=1; 222create table if not exists t1 (a int) engine=ndbcluster; 223create table if not exists t1 (a int) engine=ndbcluster; 224create table if not exists t1 (a int) engine=ndbcluster; 225create table if not exists t1 (a int) engine=ndbcluster; 226drop table t1; 227set global ndb_check_shares=1; 228set global ndb_check_shares=1; 229set global ndb_check_shares=1; 230set global ndb_check_shares=1; 231create table t1 (a int) engine=ndbcluster; 232drop table if exists t1; 233drop table if exists t1; 234drop table if exists t1; 235drop table if exists t1; 236set global ndb_check_shares=1; 237set global ndb_check_shares=1; 238set global ndb_check_shares=1; 239set global ndb_check_shares=1; 240create table t1 (a int) engine=ndbcluster; 241drop table if exists t1; 242drop table if exists t1; 243drop table if exists t1; 244drop table if exists t1; 245set global ndb_check_shares=1; 246set global ndb_check_shares=1; 247set global ndb_check_shares=1; 248set global ndb_check_shares=1; 249create table t1 (a int) engine=ndbcluster; 250drop table if exists t1; 251drop table if exists t1; 252drop table if exists t1; 253drop table if exists t1; 254set global ndb_check_shares=1; 255set global ndb_check_shares=1; 256set global ndb_check_shares=1; 257set global ndb_check_shares=1; 258create table t1 (a int) engine=ndbcluster; 259drop table if exists t1; 260drop table if exists t1; 261drop table if exists t1; 262drop table if exists t1; 263set global ndb_check_shares=1; 264set global ndb_check_shares=1; 265set global ndb_check_shares=1; 266set global ndb_check_shares=1; 267create table t1 (a int) engine=ndbcluster; 268drop table if exists t1; 269drop table if exists t1; 270drop table if exists t1; 271drop table if exists t1; 272set global ndb_check_shares=1; 273set global ndb_check_shares=1; 274set global ndb_check_shares=1; 275set global ndb_check_shares=1; 276create table t1 (a int) engine=ndbcluster; 277create table t2 (a int) engine=ndbcluster; 278desc t1; 279Field Type Null Key Default Extra 280a int(11) YES NULL 281desc t2; 282Field Type Null Key Default Extra 283a int(11) YES NULL 284desc t1; 285Field Type Null Key Default Extra 286a int(11) YES NULL 287desc t2; 288Field Type Null Key Default Extra 289a int(11) YES NULL 290desc t1; 291Field Type Null Key Default Extra 292a int(11) YES NULL 293desc t2; 294Field Type Null Key Default Extra 295a int(11) YES NULL 296desc t1; 297Field Type Null Key Default Extra 298a int(11) YES NULL 299desc t2; 300Field Type Null Key Default Extra 301a int(11) YES NULL 302drop table t1, t2; 303set global ndb_check_shares=1; 304set global ndb_check_shares=1; 305set global ndb_check_shares=1; 306set global ndb_check_shares=1; 307create table t1 (a int) engine=ndbcluster; 308create table t2 (a int) engine=ndbcluster; 309desc t1; 310ERROR 42S02: Table 'test.t1' doesn't exist 311desc t2; 312ERROR 42S02: Table 'test.t2' doesn't exist 313desc t1; 314ERROR 42S02: Table 'test.t1' doesn't exist 315desc t2; 316ERROR 42S02: Table 'test.t2' doesn't exist 317desc t1; 318ERROR 42S02: Table 'test.t1' doesn't exist 319desc t2; 320ERROR 42S02: Table 'test.t2' doesn't exist 321desc t1; 322ERROR 42S02: Table 'test.t1' doesn't exist 323desc t2; 324ERROR 42S02: Table 'test.t2' doesn't exist 325set global ndb_check_shares=1; 326set global ndb_check_shares=1; 327set global ndb_check_shares=1; 328set global ndb_check_shares=1; 329