Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_find_row.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 SQL_LOG_BIN=0;
7 CREATE TABLE t (a int, b int, c int, key(b));
8 SET SQL_LOG_BIN=1;
9 CREATE TABLE t (a int, b int, c int);
10 INSERT INTO t VALUES (1,2,4);
11 INSERT INTO t VALUES (4,3,4);
12 DELETE FROM t;
13 include/sync_slave_sql_with_master.inc
14 DROP TABLE t;
15 include/sync_slave_sql_with_master.inc
16 include/rpl_reset.inc
17 CREATE TABLE t1 (c1 INT NOT NULL, c2 INT NOT NULL, c3 INT, UNIQUE KEY(c1,c3), KEY(c2));
18 INSERT INTO t1(c1,c2) VALUES(1,1);
19 INSERT INTO t1(c1,c2) VALUES(1,2);
20 UPDATE t1 SET c1=1000 WHERE c2=2;
21 include/sync_slave_sql_with_master.inc
22 include/diff_tables.inc [master:t1, slave:t1]
23 DROP TABLE t1;
24 #
25 # Bug#27244826: INVISIBLE INDEXES ARE NOT RESPECTED BY SLAVE UNDER ROW
26 # FORMAT
27 #
28 CREATE TABLE t1 ( id INT, KEY idx_id(id) );
29 INSERT INTO t1 VALUES (1), (2), (3);
30 include/sync_slave_sql_with_master.inc
31 # Alter idx_id index on slave to invisible.
32 ALTER TABLE t1 ALTER INDEX idx_id INVISIBLE;
33 DELETE FROM t1;
34 include/sync_slave_sql_with_master.inc
35 # check whether invisible attribute is respected
36 SELECT table_name, index_name, is_visible
37 FROM information_schema.statistics
38 WHERE index_name = 'idx_id';
39 TABLE_NAME INDEX_NAME IS_VISIBLE
40 t1 idx_id NO
41 SELECT * FROM sys.schema_unused_indexes WHERE index_name = 'idx_id';
42 object_schema object_name index_name
43 test t1 idx_id
44 SELECT rows_selected
45 FROM sys.schema_index_statistics
46 WHERE index_name = 'idx_id';
47 rows_selected
48 0
49 DROP TABLE t1;
50 include/rpl_end.inc