Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
4 call mtr.add_suppression("table or database name 'mysqltest-1'");
5 connection master;
6 CREATE DATABASE `mysqltest-1`;
7 connection slave;
8 connection master;
9 connection slave;
10 connection master;
11 Master position is not changed
12 connection slave;
13 SET @old_general_log_state = @@global.general_log;
14 SET @old_slow_log_state = @@global.slow_query_log;
15 SET @old_log_output = @@global.log_output;
16 SET GLOBAL general_log = 'ON';
17 SET GLOBAL slow_query_log = 'ON';
18 SET GLOBAL log_output = 'FILE';
19 connection master;
20 ALTER TABLE mysql.slow_log DROP COLUMN thread_id, DROP COLUMN rows_affected;
21 DROP DATABASE `mysqltest-1`;
22 connection slave;
23 connection slave;
24 SHOW CREATE TABLE mysql.slow_log;
25 Table Create Table
26 slow_log CREATE TABLE `slow_log` (
27 `start_time` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
28 `user_host` mediumtext NOT NULL,
29 `query_time` time(6) NOT NULL,
30 `lock_time` time(6) NOT NULL,
31 `rows_sent` bigint(20) unsigned NOT NULL,
32 `rows_examined` bigint(20) unsigned NOT NULL,
33 `db` varchar(512) NOT NULL,
34 `last_insert_id` int(11) NOT NULL,
35 `insert_id` int(11) NOT NULL,
36 `server_id` int(10) unsigned NOT NULL,
37 `sql_text` mediumtext NOT NULL
38 ) ENGINE=CSV DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Slow log'
39 connection master;
40 connection master;
41 Master position has been changed
42 connection slave;
43 connection slave;
44 SHOW CREATE TABLE mysql.slow_log;
45 Table Create Table
46 slow_log CREATE TABLE `slow_log` (
47 `start_time` timestamp(6) NOT NULL DEFAULT current_timestamp(6) ON UPDATE current_timestamp(6),
48 `user_host` mediumtext NOT NULL,
49 `query_time` time(6) NOT NULL,
50 `lock_time` time(6) NOT NULL,
51 `rows_sent` bigint(20) unsigned NOT NULL,
52 `rows_examined` bigint(20) unsigned NOT NULL,
53 `db` varchar(512) NOT NULL,
54 `last_insert_id` int(11) NOT NULL,
55 `insert_id` int(11) NOT NULL,
56 `server_id` int(10) unsigned NOT NULL,
57 `sql_text` mediumtext NOT NULL,
58 `thread_id` bigint(21) unsigned NOT NULL,
59 `rows_affected` bigint(20) unsigned NOT NULL
60 ) ENGINE=CSV DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci COMMENT='Slow log'
61 SET GLOBAL general_log = 'OFF';
62 SET GLOBAL slow_query_log = 'OFF';
63 truncate mysql.slow_log;
64 truncate mysql.general_log;
65 SET GLOBAL general_log = @old_general_log_state;
66 SET GLOBAL slow_query_log = @old_slow_log_state;
67 SET GLOBAL log_output = @old_log_output;
68 include/rpl_end.inc