Debian Codegraph @

mysql-test/suite/galera/r/galera_sync_wait_show.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_2;
4 SET SESSION wsrep_sync_wait = 8;
5 connection node_1;
6 CREATE DATABASE db1;
7 connection node_2;
8 SHOW CREATE DATABASE db1;
9 Database Create Database
10 db1 CREATE DATABASE `db1` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci */
11 DROP DATABASE db1;
12 connection node_1;
13 CREATE PROCEDURE p1 () SELECT 1 FROM DUAL;
14 connection node_2;
15 SHOW CREATE PROCEDURE p1;
16 Procedure sql_mode Create Procedure character_set_client collation_connection Database Collation
17 p1 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
18 SELECT 1 FROM DUAL latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
19 DROP PROCEDURE p1;
20 connection node_1;
21 CREATE PROCEDURE p1 () SELECT 1 FROM DUAL;
22 connection node_2;
23 SHOW PROCEDURE CODE p1;
24 Pos Instruction
25 0 stmt 0 "SELECT 1 FROM DUAL"
26 DROP PROCEDURE p1;
27 connection node_1;
28 CREATE FUNCTION f1 () RETURNS INTEGER RETURN 123;
29 connection node_2;
30 SHOW CREATE FUNCTION f1;
31 Function sql_mode Create Function character_set_client collation_connection Database Collation
32 f1 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` FUNCTION `f1`() RETURNS int(11)
33 RETURN 123 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
34 DROP FUNCTION f1;
35 connection node_1;
36 CREATE FUNCTION f1 () RETURNS INTEGER RETURN 123;
37 connection node_2;
38 SHOW FUNCTION CODE f1;
39 Pos Instruction
40 0 freturn int 123
41 DROP FUNCTION f1;
42 connection node_1;
43 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
44 CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.f1 = 'a';
45 connection node_2;
46 SHOW CREATE TRIGGER tr1;
47 Trigger sql_mode SQL Original Statement character_set_client collation_connection Database Collation Created
48 tr1 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION CREATE DEFINER=`root`@`localhost` TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.f1 = 'a' latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci #
49 DROP TABLE t1;
50 connection node_1;
51 CREATE EVENT event1 ON SCHEDULE AT '2038-01-01 23:59:59' DO SELECT 1;
52 connection node_2;
53 SHOW CREATE EVENT event1;
54 Event sql_mode time_zone Create Event character_set_client collation_connection Database Collation
55 event1 STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION SYSTEM CREATE DEFINER=`root`@`localhost` EVENT `event1` ON SCHEDULE AT '2038-01-01 23:59:59' ON COMPLETION NOT PRESERVE DISABLE ON SLAVE DO SELECT 1 latin1 latin1_swedish_ci utf8mb4_uca1400_ai_ci
56 DROP EVENT event1;