Debian Codegraph @

mysql-test/suite/mariabackup/log_tables.result

raw
1 CREATE TABLE t(i INT)
2 ENGINE ARIA TRANSACTIONAL=1 ROW_FORMAT=PAGE PAGE_CHECKSUM=1;
3 SET GLOBAL general_log = 0;
4 TRUNCATE mysql.general_log;
5 SET GLOBAL general_log = 1;
6 SET GLOBAL log_output = 'TABLE';
7 INSERT INTO t VALUES (1);
8 SELECT * FROM mysql.general_log
9 WHERE argument LIKE "INSERT INTO %" AND
10 (command_type = "Query" OR command_type = "Execute") ;
11 event_time user_host thread_id server_id command_type argument
12 TIMESTAMP USER_HOST THREAD_ID 1 Query INSERT INTO t VALUES (1)
13 # Insert new row into general_log table after it has been copied on BLOCK_DDL.
14 # Backup to dir.
15 # Xtrabackup prepare.
16 # shutdown server
17 # remove datadir
18 # xtrabackup move back
19 # restart
20 SELECT * FROM mysql.general_log
21 WHERE argument LIKE "INSERT INTO %" AND
22 (command_type = "Query" OR command_type = "Execute") ;
23 event_time user_host thread_id server_id command_type argument
24 TIMESTAMP USER_HOST THREAD_ID 1 Query INSERT INTO t VALUES (1)
25 TIMESTAMP USER_HOST THREAD_ID 1 Query INSERT INTO test.t VALUES (2)
26 DROP TABLE t;