Debian Codegraph @

mysql-test/suite/rpl/r/rpl_multi_valued_index_debug.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 SET SESSION sql_log_bin= 0;
7 call mtr.add_suppression('.*Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT.*');
8 SET SESSION sql_log_bin= 1;
9 include/sync_slave_sql_with_master.inc
10 CALL mtr.add_suppression(".*Column 1 of table .* cannot be converted from type.*");
11 CALL mtr.add_suppression(".*The replica coordinator and worker threads are stopped.*");
12 SET @@global.slave_rows_search_algorithms="TABLE_SCAN,INDEX_SCAN";
13 Warnings:
14 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
15 [connection master]
16 FLUSH LOGS;
17 SET binlog_row_image = MINIMAL;
18 # Test non-nullable MV index
19 CREATE TABLE t1 (id INT, c INT, j JSON NOT NULL,
20 UNIQUE INDEX i1((CAST(CAST(j AS JSON) AS UNSIGNED ARRAY))));
21 INSERT INTO t1 VALUES (1, 1, '[1,2,3,4]'), (2, 2, '[5,6,7,8]');
22 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
23 include/sync_slave_sql_with_master.inc
24 [Connection Slave]
25 SHOW STATUS LIKE 'Replica_rows_last_search_algorithm_used';
26 Variable_name Value
27 Replica_rows_last_search_algorithm_used TABLE_SCAN
28 [connection master]
29 DELETE FROM t1 WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
30 include/sync_slave_sql_with_master.inc
31 [Connection Slave]
32 SHOW STATUS LIKE 'Replica_rows_last_search_algorithm_used';
33 Variable_name Value
34 Replica_rows_last_search_algorithm_used TABLE_SCAN
35 [connection master]
36 DROP TABLE t1;
37 # Test nullable MV index
38 CREATE TABLE t1 (id INT, c INT, j JSON,
39 UNIQUE INDEX i1((CAST(CAST(j AS JSON) AS UNSIGNED ARRAY))));
40 INSERT INTO t1 VALUES (1, 1, '[1,2,3,4]'), (2, 2, '[5,6,7,8]');
41 INSERT INTO t1 VALUES (3, 3, NULL);
42 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
43 include/sync_slave_sql_with_master.inc
44 [Connection Slave]
45 SHOW STATUS LIKE 'Replica_rows_last_search_algorithm_used';
46 Variable_name Value
47 Replica_rows_last_search_algorithm_used TABLE_SCAN
48 [connection master]
49 DELETE FROM t1 WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
50 include/sync_slave_sql_with_master.inc
51 [Connection Slave]
52 SHOW STATUS LIKE 'Replica_rows_last_search_algorithm_used';
53 Variable_name Value
54 Replica_rows_last_search_algorithm_used TABLE_SCAN
55 [connection master]
56 DROP TABLE t1;
57 # Test non-unique MV index
58 CREATE TABLE t1 (id INT, c INT, j JSON NOT NULL,
59 INDEX i1((CAST(CAST(j AS JSON) AS UNSIGNED ARRAY))));
60 INSERT INTO t1 VALUES (1, 1, '[1,2,3,4]'), (2, 2, '[5,6,7,8]');
61 INSERT INTO t1 VALUES (1, 1, '[1,2,3,4]'), (2, 2, '[5,6,7,8]');
62 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
63 include/sync_slave_sql_with_master.inc
64 [Connection Slave]
65 SHOW STATUS LIKE 'Replica_rows_last_search_algorithm_used';
66 Variable_name Value
67 Replica_rows_last_search_algorithm_used TABLE_SCAN
68 [connection master]
69 DELETE FROM t1 WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
70 include/sync_slave_sql_with_master.inc
71 [Connection Slave]
72 SHOW STATUS LIKE 'Replica_rows_last_search_algorithm_used';
73 Variable_name Value
74 Replica_rows_last_search_algorithm_used TABLE_SCAN
75 [connection master]
76 DROP TABLE t1;
77 # Test composite MV index
78 CREATE TABLE t1 (id INT, c INT, j JSON NOT NULL,
79 INDEX i1((CAST(CAST(j AS JSON) AS UNSIGNED ARRAY)), id));
80 INSERT INTO t1 VALUES (1, 1, '[1,2,3,4]'), (2, 2, '[5,6,7,8]');
81 INSERT INTO t1 VALUES (1, 1, '[1,2,3,4]'), (2, 2, '[5,6,7,8]');
82 UPDATE t1 SET j = '[2,9,10]' WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
83 include/sync_slave_sql_with_master.inc
84 [Connection Slave]
85 SHOW STATUS LIKE 'Replica_rows_last_search_algorithm_used';
86 Variable_name Value
87 Replica_rows_last_search_algorithm_used TABLE_SCAN
88 [connection master]
89 DELETE FROM t1 WHERE JSON_CONTAINS(CAST(j AS JSON),'2');
90 include/sync_slave_sql_with_master.inc
91 [Connection Slave]
92 SHOW STATUS LIKE 'Replica_rows_last_search_algorithm_used';
93 Variable_name Value
94 Replica_rows_last_search_algorithm_used TABLE_SCAN
95 [connection master]
96 DROP TABLE t1;
97 SET @@global.slave_rows_search_algorithms= "INTITAL_ROW_SEARCH_CONF";
98 Warnings:
99 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
100 FLUSH LOGS;
101 include/sync_slave_sql_with_master.inc
102 SET @@global.slave_rows_search_algorithms= "INTITAL_ROW_SEARCH_CONF";
103 Warnings:
104 Warning 1287 '@@slave_rows_search_algorithms' is deprecated and will be removed in a future release.
105 include/rpl_end.inc