1 #############################################################################
2 # Original Author: JBM #
3 # Original Date: Sept/15/2005 #
4 #############################################################################
5 # Test: To test the replication of the bit field #
6 #############################################################################
8 # Change Date: 2006-01-16
9 # Change: Added Order by for NDB
12 -- source include/master-slave.inc
15 # Begin clean up test section
18 DROP TABLE IF EXISTS test.t1;
22 # Begin test section 1
24 CREATE TABLE test.t1 (
25 dummyKey INTEGER NOT NULL,
63 PRIMARY KEY USING HASH (dummyKey) );
65 LOCK TABLES test.t1 WRITE;
66 INSERT INTO test.t1 VALUES (6,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,b'111111',b'111110',b'110101',4,5,5,5,5,5,5,5,5,5,3,2,1);
67 INSERT INTO test.t1 VALUES (1,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,b'111111',b'000000',b'100100',4,5,5,5,5,5,5,5,5,5,3,2,1);
68 INSERT INTO test.t1 VALUES (2,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,b'000000',b'101010',b'010101',4,5,5,5,5,5,5,5,5,5,3,2,1);
69 INSERT INTO test.t1 VALUES (3,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,b'101010',b'111111',b'000000',4,5,5,5,5,5,5,5,5,5,3,2,1);
70 INSERT INTO test.t1 VALUES (4,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,4,5,5,5,5,5,5,5,5,5,3,2,1);
71 INSERT INTO test.t1 VALUES (5,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,4,5,5,5,5,5,5,5,5,5,3,2,1);
72 INSERT INTO test.t1 VALUES (7,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,4,5,5,5,5,5,5,5,5,5,3,2,1);
73 INSERT INTO test.t1 VALUES (8,1,1,1,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,4,5,5,5,5,5,5,5,5,5,3,2,1);
77 SELECT oSupp, sSuppD, GSuppDf, VNotSupp, x034 FROM test.t1;
78 SELECT hex(bit1) FROM test.t1 ORDER BY bit1;
79 SELECT hex(bit2) from test.t1 ORDER BY bit2;
80 SELECT hex(bit3) from test.t1 ORDER BY bit3;
85 SELECT oSupp, sSuppD, GSuppDf, VNotSupp, x034 FROM test.t1;
86 SELECT hex(bit1) FROM test.t1 ORDER BY bit1;
87 SELECT hex(bit2) from test.t1 ORDER BY bit2;
88 SELECT hex(bit3) from test.t1 ORDER BY bit3;
91 DROP TABLE IF EXISTS test.t1;
92 sync_slave_with_master;
94 # End of 5.0 test case
95 --source include/rpl_end.inc