Debian Codegraph @

mysql-test/suite/galera/t/galera_log_output_csv.test

raw
1 #
2 # Test that --log-output=FILE works with Galera.
3 # The relevant options are set using a -master.opt file
4 # wsrep_replicate_myisam is not used as it crashes in MTR with mysql-wsrep#14
5 #
6
7 --source include/galera_cluster.inc
8 --source include/have_innodb.inc
9
10 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
11 INSERT INTO t1 VALUES (1);
12
13 SELECT COUNT(*) > 0 FROM mysql.general_log;
14
15 --disable_ps2_protocol
16 SELECT 1 = 1 FROM t1;
17 SELECT COUNT(*) = 1 FROM mysql.slow_log WHERE sql_text = 'SELECT 1 = 1 FROM t1';
18 --enable_ps2_protocol
19
20 --connection node_2
21
22 --disable_ps2_protocol
23 SELECT 2 = 2 FROM t1;
24 SELECT COUNT(*) = 1 FROM mysql.slow_log WHERE sql_text = 'SELECT 2 = 2 FROM t1';
25 --enable_ps2_protocol
26
27 --connection node_1
28 DROP TABLE t1;
29 truncate table mysql.slow_log;
30 truncate table mysql.general_log;