| 1 |
--source include/have_ndb.inc |
| 2 |
--source suite/ndb_rpl/ndb_master-slave.inc |
| 3 |
|
| 4 |
# |
| 5 |
# Test add column |
| 6 |
# |
| 7 |
--connection master |
| 8 |
CREATE TABLE t1 (c1 INT KEY) ROW_FORMAT=DYNAMIC ENGINE=NDB; |
| 9 |
|
| 10 |
INSERT INTO t1 VALUES (1),(2),(3); |
| 11 |
|
| 12 |
ALTER TABLE t1 ADD c2 INT; |
| 13 |
|
| 14 |
--sync_slave_with_master |
| 15 |
connection slave; |
| 16 |
SELECT * FROM t1 ORDER BY c1; |
| 17 |
|
| 18 |
connection master; |
| 19 |
|
| 20 |
INSERT INTO t1 VALUES (6,6),(7,7),(8,8); |
| 21 |
SELECT * FROM t1 ORDER BY c1; |
| 22 |
|
| 23 |
--sync_slave_with_master |
| 24 |
connection slave; |
| 25 |
SELECT * FROM t1 ORDER BY c1; |
| 26 |
|
| 27 |
# |
| 28 |
# Test online alter table for various types |
| 29 |
# |
| 30 |
connection master; |
| 31 |
ALTER TABLE t1 algorithm=inplace, ADD c CHAR(19); |
| 32 |
INSERT INTO t1 values (11,1,"a"); |
| 33 |
ALTER TABLE t1 algorithm=inplace, ADD d FLOAT; |
| 34 |
INSERT INTO t1 VALUES(12, 2,'b', -3.402823466E+38); |
| 35 |
#FOR BUG#32095 SO COMMNET THE DOUBLE TYPE DATA. |
| 36 |
# ALTER TABLE t1 algorithm=inplace, ADD e DOUBLE UNSIGNED; |
| 37 |
# INSERT INTO t1 VALUES(13, 3,'c', -3.402823466E+38, 1.7976931348623157E+308); |
| 38 |
ALTER TABLE t1 algorithm=inplace, ADD f DECIMAL(5,2); |
| 39 |
INSERT INTO t1 VALUES(14, 4,'d', -3.402823466E+38, 456.78); |
| 40 |
ALTER TABLE t1 algorithm=inplace, ADD g DATETIME; |
| 41 |
INSERT INTO t1 VALUES(15, 5,'e', -3.402823466E+38, 456.78, '2007-10-26 12:00:00'); |
| 42 |
ALTER TABLE t1 algorithm=inplace, ADD h BINARY(4); |
| 43 |
INSERT INTO t1 VALUES(16, 6,'f', -3.402823466E+38, 456.78, '2007-10-26 12:00:00',"abcd"); |
| 44 |
--echo ********************** |
| 45 |
--echo "Master data" |
| 46 |
--echo ********************** |
| 47 |
SELECT * FROM t1 ORDER BY c1; |
| 48 |
--sync_slave_with_master |
| 49 |
connection slave; |
| 50 |
--echo ********************** |
| 51 |
--echo "Slave data" |
| 52 |
--echo ********************** |
| 53 |
SELECT * FROM t1 ORDER BY c1; |
| 54 |
|
| 55 |
# |
| 56 |
# Update the new added column |
| 57 |
# |
| 58 |
connection master; |
| 59 |
UPDATE t1 SET c = "abcdef", d = 3.402823466E+38, f = 987.65, g = '2007-10-22 22:22:22', h = "aaaa"; |
| 60 |
--echo *************************** |
| 61 |
--echo "Master Data After Update" |
| 62 |
--echo *************************** |
| 63 |
SELECT * FROM t1 ORDER BY c1; |
| 64 |
--sync_slave_with_master |
| 65 |
connection slave; |
| 66 |
--echo ************************* |
| 67 |
--echo "Slave Data After Update" |
| 68 |
--echo ************************* |
| 69 |
SELECT * FROM t1 ORDER BY c1; |
| 70 |
|
| 71 |
connection master; |
| 72 |
DROP TABLE t1; |
| 73 |
|
| 74 |
--echo ************************************************* |
| 75 |
--echo * Insert And Update New Added Columns With Commit |
| 76 |
--echo ************************************************* |
| 77 |
connection master; |
| 78 |
CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB; |
| 79 |
INSERT INTO t1 VALUES(1,1),(2,2); |
| 80 |
BEGIN; |
| 81 |
ALTER TABLE t1 algorithm=inplace, ADD c CHAR(19), ADD d VARCHAR(255), ADD e char(255); |
| 82 |
INSERT INTO t1 VALUES (3,0,'3','3','3'),(4,0,'4','4','4'),(5,0,null,null,null); |
| 83 |
UPDATE t1 SET c = 'aaa', d = 'bbb', e = 'ccc' WHERE a = 4; |
| 84 |
COMMIT; |
| 85 |
SELECT * FROM t1 ORDER BY a; |
| 86 |
--sync_slave_with_master |
| 87 |
connection slave; |
| 88 |
--echo ************************* |
| 89 |
--echo "Slave Data With Commit |
| 90 |
--echo ************************* |
| 91 |
SELECT * FROM t1 ORDER BY a; |
| 92 |
|
| 93 |
--echo *************************************************** |
| 94 |
--echo * Insert And Update New Added Columns With Rollback |
| 95 |
--echo *************************************************** |
| 96 |
connection master; |
| 97 |
DROP TABLE t1; |
| 98 |
CREATE TABLE t1 (a INT UNSIGNED KEY, b INT UNSIGNED) ROW_FORMAT=DYNAMIC ENGINE NDB; |
| 99 |
INSERT INTO t1 VALUES(1,1),(2,2); |
| 100 |
ALTER TABLE t1 ADD c CHAR(19), ADD d VARCHAR(255), ADD e char(255); |
| 101 |
BEGIN; |
| 102 |
INSERT INTO t1 VALUES (3,0,'3','3','3'),(4,0,'4','4','4'),(5,0,null,null,null); |
| 103 |
UPDATE t1 SET c = 'aaa', d = 'bbb', e = 'ccc' WHERE a = 4; |
| 104 |
ROLLBACK; |
| 105 |
--disable_warnings |
| 106 |
SHOW CREATE TABLE t1; |
| 107 |
--enable_warnings |
| 108 |
SELECT * FROM t1 ORDER BY a; |
| 109 |
--sync_slave_with_master |
| 110 |
connection slave; |
| 111 |
--echo ************************* |
| 112 |
--echo "Slave Data With Rollback |
| 113 |
--echo ************************* |
| 114 |
--disable_warnings |
| 115 |
SHOW CREATE TABLE t1; |
| 116 |
--enable_warnings |
| 117 |
SELECT * FROM t1 ORDER BY a; |
| 118 |
|
| 119 |
# cleanup |
| 120 |
--connection master |
| 121 |
DROP TABLE t1; |
| 122 |
-- source include/rpl_end.inc |