Debian Codegraph @

mysql-test/suite/binlog/r/binlog_alter_table_not_blocked_by_purge.result

raw
1 #
2 # Initialization
3 #
4 RESET MASTER;
5 CREATE TABLE t1 (c1 INT PRIMARY KEY) SECONDARY_ENGINE rapid;
6 FLUSH BINARY LOGS;
7 SHOW BINARY LOGS;
8 Log_name File_size Encrypted
9 binlog.000001 SIZE No
10 binlog.000002 SIZE No
11 #
12 # Run PURGE BINARY LOGS in separate connection
13 #
14 [connection default]
15 PURGE BINARY LOGS TO 'binlog.000001';
16 [START] PURGE BINARY LOGS TO 'binlog.000001';
17 #
18 # Check ALTER TABLE statement can be executed
19 #
20 ALTER TABLE t1 SECONDARY_LOAD;
21 #
22 # Continue PURGE BINARY LOGS statement
23 #
24 [END] PURGE BINARY LOGS TO 'binlog.000001';
25 #
26 # Cleanup
27 #
28 DROP TABLE t1;