1include/master-slave.inc 2[connection master] 3***************** Test 1 ************************ 4 5CREATE TABLE t1 (a INT NOT NULL auto_increment,b INT, PRIMARY KEY (a)) ENGINE=NDB auto_increment=3; 6insert into t1 values (NULL,1),(NULL,2),(NULL,3); 7******* Select from Master ************* 8 9select * from t1 ORDER BY a; 10a b 113 1 124 2 135 3 14******* Select from Slave ************* 15 16select * from t1 ORDER BY a; 17a b 183 1 194 2 205 3 21drop table t1; 22create table t1 (a int not null auto_increment,b int, primary key (a)) engine=NDB; 23insert into t1 values (1,1),(NULL,2),(3,3),(NULL,4); 24delete from t1 where b=4; 25insert into t1 values (NULL,5),(NULL,6); 26******* Select from Master ************* 27 28select * from t1 ORDER BY a; 29a b 301 1 312 2 323 3 335 5 346 6 35******* Select from Slave ************* 36 37select * from t1 ORDER BY a; 38a b 391 1 402 2 413 3 425 5 436 6 44drop table t1; 45create table t1 (a int not null auto_increment, primary key (a)) engine=NDB; 46insert into t1 values (NULL),(5),(NULL); 47insert into t1 values (250),(NULL); 48******* Select from Master ************* 49 50select * from t1 ORDER BY a; 51a 521 535 546 55250 56251 57insert into t1 values (1000); 58set @@insert_id=400; 59insert into t1 values(NULL),(NULL); 60******* Select from Master ************* 61 62select * from t1 ORDER BY a; 63a 641 655 666 67250 68251 69400 70401 711000 72******* Select from Slave ************* 73 74select * from t1 ORDER BY a; 75a 761 775 786 79250 80251 81400 82401 831000 84drop table t1; 85create table t1 (a int not null auto_increment, primary key (a)) engine=NDB; 86insert into t1 values (NULL),(5),(NULL),(NULL); 87insert into t1 values (500),(NULL),(502),(NULL),(600); 88******* Select from Master ************* 89 90select * from t1 ORDER BY a; 91a 921 935 946 957 96500 97501 98502 99503 100600 101set @@insert_id=600; 102insert into t1 values(600),(NULL),(NULL); 103ERROR 23000: Can't write; duplicate key in table '' 104set @@insert_id=600; 105insert ignore into t1 values(600),(NULL),(NULL),(610),(NULL); 106******* Select from Master ************* 107 108select * from t1 ORDER BY a; 109a 1101 1115 1126 1137 114500 115501 116502 117503 118600 119610 120611 121******* Select from Slave ************* 122 123select * from t1 ORDER BY a; 124a 1251 1265 1276 1287 129500 130501 131502 132503 133600 134610 135611 136drop table t1; 137create table t1 (a int not null auto_increment, primary key (a)) engine=NDB; 138insert into t1 values(2),(12),(22),(32),(42); 139insert into t1 values (NULL),(NULL); 140insert into t1 values (3),(NULL),(NULL); 141******* Select from Master ************* 142 143select * from t1 ORDER BY a; 144a 1451 1462 1473 1484 1495 150******* Select from Slave ************* 151 152** Slave should have 2, 12, 22, 32, 42 ** 153** Master will have 2 but not 12, 22, 32, 42 ** 154 155select * from t1 ORDER BY a; 156a 1571 1582 1593 1604 1615 16212 16322 16432 16542 166drop table t1; 167set @old_ndb_autoincrement_prefetch_sz = @@session.ndb_autoincrement_prefetch_sz; 168set ndb_autoincrement_prefetch_sz = 32; 169CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT KEY) ENGINE=ndb; 170INSERT INTO t1 () VALUES (),(),(); 171set @old_ndb_autoincrement_prefetch_sz = @@session.ndb_autoincrement_prefetch_sz; 172set ndb_autoincrement_prefetch_sz = 32; 173select * from t1 order by id; 174id 1751 1762 1773 178INSERT INTO t1 () VALUES (),(),(); 179select * from t1 order by id; 180id 1811 1822 1833 1844 1855 1866 187set ndb_autoincrement_prefetch_sz = @old_ndb_autoincrement_prefetch_sz; 188select * from t1 order by id; 189id 1901 1912 1923 193drop table t1; 194set ndb_autoincrement_prefetch_sz = @old_ndb_autoincrement_prefetch_sz; 195include/rpl_end.inc 196