Debian Codegraph @

mysql-test/suite/rpl/t/rpl_histograms.test

raw
1 --source include/master-slave.inc
2
3 --echo # Verify that column statistics are replicated according to the
4 --echo # "NO_WRITE_TO_BINLOG"-flag.
5 CREATE TABLE not_replicated (col1 INT);
6 CREATE TABLE replicated (col1 INT);
7 INSERT INTO not_replicated VALUES (1), (2);
8 INSERT INTO replicated VALUES (1), (2);
9 --echo # Create histograms on 'not_replicated' without writing to binlog
10 ANALYZE NO_WRITE_TO_BINLOG TABLE not_replicated
11 UPDATE HISTOGRAM ON col1 WITH 1024 BUCKETS;
12
13 --echo # Create histograms on 'replicated' (should be written to the binlog)
14 ANALYZE TABLE replicated UPDATE HISTOGRAM ON col1 WITH 1024 BUCKETS;
15
16 --echo # Both tables should be present on the master
17 SELECT schema_name, table_name, column_name,
18 JSON_REMOVE(histogram, '$."last-updated"')
19 FROM information_schema.COLUMN_STATISTICS;
20
21 --echo # Sync slave with master, and verify that we only have column statistics
22 --echo # for table 'replicated' on the slave
23 --source include/sync_slave_sql_with_master.inc
24 --connection slave
25 SELECT schema_name, table_name, column_name,
26 JSON_REMOVE(histogram, '$."last-updated"')
27 FROM information_schema.COLUMN_STATISTICS;
28
29 --connection master
30 DROP TABLE replicated, not_replicated;
31
32 --echo #
33 --echo # Bug#26041269 WL8943(RPL):ASSERTION `HEAD->VARIABLES.GTID_NEXT.TYPE !=
34 --echo # UNDEFINED_GROUP' FAILED
35 --echo #
36
37 CREATE TABLE foo (col1 INT);
38 ANALYZE TABLE foo UPDATE HISTOGRAM ON meh WITH 10 BUCKETS;
39 DROP TABLE foo;
40
41 --source include/rpl_end.inc