Debian Codegraph @

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

raw
1 #
2 # Test that the various SHOW commands obey wsrep_sync_wait - codership/mysql-wsrep#228
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_innodb.inc
7 --source include/have_debug.inc
8
9 --connection node_2
10 # MW-86 SHOW commands have now bitmap value 8
11 SET SESSION wsrep_sync_wait = 8;
12
13
14 --connection node_1
15 CREATE DATABASE db1;
16
17 --connection node_2
18 SHOW CREATE DATABASE db1;
19 DROP DATABASE db1;
20
21
22 --connection node_1
23 CREATE PROCEDURE p1 () SELECT 1 FROM DUAL;
24
25 --connection node_2
26 SHOW CREATE PROCEDURE p1;
27 DROP PROCEDURE p1;
28
29
30
31 --connection node_1
32 CREATE PROCEDURE p1 () SELECT 1 FROM DUAL;
33
34 --connection node_2
35 SHOW PROCEDURE CODE p1;
36 DROP PROCEDURE p1;
37
38
39
40 --connection node_1
41 CREATE FUNCTION f1 () RETURNS INTEGER RETURN 123;
42
43 --connection node_2
44 SHOW CREATE FUNCTION f1;
45 DROP FUNCTION f1;
46
47
48 --connection node_1
49 CREATE FUNCTION f1 () RETURNS INTEGER RETURN 123;
50
51 --connection node_2
52 SHOW FUNCTION CODE f1;
53 DROP FUNCTION f1;
54
55
56 --connection node_1
57 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
58 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.f1 = 'a';
59
60 --connection node_2
61 --replace_column 7 #
62 SHOW CREATE TRIGGER tr1;
63 DROP TABLE t1;
64
65
66 --connection node_1
67 --disable_warnings
68 CREATE EVENT event1 ON SCHEDULE AT '2038-01-01 23:59:59' DO SELECT 1;
69 --enable_warnings
70
71 --connection node_2
72 SHOW CREATE EVENT event1;
73 DROP EVENT event1;