Debian Codegraph @

mysql-test/suite/rpl/r/binlog_multi_column_write_set_char.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 #
7 # Initialization
8 #
9 include/save_sysvars.inc [ "GLOBAL.binlog_transaction_dependency_tracking" ]
10 SET GLOBAL binlog_transaction_dependency_tracking = WRITESET;
11 Warnings:
12 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
13 #
14 # Check test_table last_committed and sequence_number
15 #
16 DROP TABLE IF EXISTS test_table;
17 Warnings:
18 Note 1051 Unknown table 'test.test_table'
19 CREATE TABLE test_table (
20 id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
21 t_id char(64) NOT NULL,
22 s_id char(64) NOT NULL,
23 a_type char(64) NOT NULL,
24 a_no char(192) NOT NULL,
25 PRIMARY KEY (`id`),
26 UNIQUE KEY `uniq_idx_t` (`s_id`(3),`a_type`(3),`a_no`(3),`t_id`(3))
27 ) ENGINE=InnoDB;
28 Warnings:
29 Warning 1681 Integer display width is deprecated and will be removed in a future release.
30 #
31 # Insert rows into test_table
32 #
33 include/save_binlog_position.inc
34 INSERT INTO test_table VALUES (1, 1, 'aaabbb', 'bbbccc', 2);
35 DELETE FROM test_table WHERE id = 1;
36 #
37 # Value validation int test_table
38 #
39 INSERT INTO test_table VALUES (2, 1, 'aaaddd', 'bbbeee', 2);
40 include/include/assert_logical_timestamps.inc [2 3;3 4;4 5]
41 #
42 # Check test2 last_committed and sequence_number
43 #
44 DROP TABLE IF EXISTS test2;
45 Warnings:
46 Note 1051 Unknown table 'test.test2'
47 CREATE TABLE test2 (
48 id char(64) NOT NULL,
49 did int DEFAULT NULL,
50 PRIMARY KEY (`id`(3))
51 ) ENGINE=InnoDB;
52 #
53 # Insert rows into test2
54 #
55 include/save_binlog_position.inc
56 INSERT INTO test2 VALUES ('aaabbb', 1);
57 DELETE FROM test2 WHERE did = 1;
58 INSERT INTO test2 VALUES ('aaabbc', 2);
59 DELETE FROM test2 WHERE did = 2;
60 INSERT INTO test2 VALUES ('aaabbf', 3);
61 DELETE FROM test2 WHERE did = 3;
62 #
63 # Value validation in test2
64 #
65 include/include/assert_logical_timestamps.inc [7 8;8 9;9 10;10 11;11 12;12 13]
66 #
67 # Clean up
68 #
69 DROP TABLE test_table;
70 DROP TABLE test2;
71 include/restore_sysvars.inc
72 Warnings:
73 Warning 1287 '@@binlog_transaction_dependency_tracking' is deprecated and will be removed in a future release.
74 include/rpl_end.inc