Debian Codegraph @

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

raw
1 #
2 # 1. Create source-replica topology
3 include/master-slave.inc
4 Warnings:
5 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
6 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.
7 [connection master]
8 #
9 # 2. Set slave_rows_search_algorithms as HASH_SCAN on the replica
10 [connection slave]
11 include/save_sysvars.inc [
12 "GLOBAL.slave_rows_search_algorithms"
13 ]
14 SET GLOBAL slave_rows_search_algorithms= 'HASH_SCAN';
15 Warnings:
16 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
17 #
18 # 3. For each Scenario [Table with index, Table with out index]
19 #
20 # 3.1 On the source, create a table and insert two rows with
21 # the same hash value
22 [connection master]
23 CREATE TABLE t1 (
24 a BIGINT UNSIGNED NOT NULL,
25 b BIGINT UNSIGNED NOT NULL,
26 c INT DEFAULT NULL,
27 KEY idx (c)
28 ) ENGINE= InnoDB ;
29 INSERT INTO t1 VALUES(0xa8e8ee744ced7ca8, 0x6850119e455ee4ed, null);
30 INSERT INTO t1 VALUES(0x135cd25c170db910, 0x6916c5057592c796, null);
31 include/sync_slave_sql_with_master.inc
32 [connection master]
33 #
34 # 3.2 On the source, perform an update on the second row
35 # and verify that the update is successful
36 UPDATE t1 SET b=1 WHERE a=0x135cd25c170db910;
37 SELECT * FROM t1;
38 a b c
39 12171240176243014824 7516527149547709677 NULL
40 1395221277543610640 1 NULL
41 #
42 # 3.3 Verify that the update is successful on the replica
43 include/sync_slave_sql_with_master.inc
44 include/diff_tables.inc [master:test.t1, slave:test.t1]
45 [connection master]
46 DROP TABLE t1;
47 include/sync_slave_sql_with_master.inc
48 #
49 # 3.1 On the source, create a table and insert two rows with
50 # the same hash value
51 [connection master]
52 CREATE TABLE t1 (
53 a BIGINT UNSIGNED NOT NULL,
54 b BIGINT UNSIGNED NOT NULL,
55 c INT DEFAULT NULL
56 ) ENGINE= InnoDB ;
57 INSERT INTO t1 VALUES(0xa8e8ee744ced7ca8, 0x6850119e455ee4ed, null);
58 INSERT INTO t1 VALUES(0x135cd25c170db910, 0x6916c5057592c796, null);
59 include/sync_slave_sql_with_master.inc
60 [connection master]
61 #
62 # 3.2 On the source, perform an update on the second row
63 # and verify that the update is successful
64 UPDATE t1 SET b=1 WHERE a=0x135cd25c170db910;
65 SELECT * FROM t1;
66 a b c
67 12171240176243014824 7516527149547709677 NULL
68 1395221277543610640 1 NULL
69 #
70 # 3.3 Verify that the update is successful on the replica
71 include/sync_slave_sql_with_master.inc
72 include/diff_tables.inc [master:test.t1, slave:test.t1]
73 [connection master]
74 DROP TABLE t1;
75 include/sync_slave_sql_with_master.inc
76 #
77 # 4. Cleanup
78 include/restore_sysvars.inc
79 Warnings:
80 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
81 include/rpl_end.inc