Debian Codegraph @

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

raw
1 RESET MASTER;
2 CREATE TABLE t1 (a DOUBLE DEFAULT (PI()),
3 b DOUBLE DEFAULT (RAND()));
4 CREATE TABLE t2 (x INT);
5 CREATE TABLE t3 (y DOUBLE DEFAULT (PI()));
6 # Test R1.
7 CREATE TRIGGER t2_trigger AFTER INSERT ON t2
8 FOR EACH ROW INSERT INTO t1 VALUES ();
9 include/save_binlog_position.inc
10 INSERT INTO t2 VALUES ();
11 include/assert_binlog_events.inc [!Gtid_or_anon # !Begin # Table_map # Table_map # Write_rows # Write_rows # Xid]
12 DROP TRIGGER t2_trigger;
13 CREATE TRIGGER t2_trigger AFTER INSERT ON t2
14 FOR EACH ROW INSERT INTO t1(a) VALUES (1);
15 include/save_binlog_position.inc
16 INSERT INTO t2 VALUES ();
17 include/assert_binlog_events.inc [!Gtid_or_anon # !Begin # Table_map # Table_map # Write_rows # Write_rows # Xid]
18 DROP TRIGGER t2_trigger;
19 CREATE TRIGGER t2_trigger AFTER INSERT ON t2
20 FOR EACH ROW INSERT INTO t1(b) VALUES (DEFAULT);
21 include/save_binlog_position.inc
22 INSERT INTO t2 VALUES ();
23 include/assert_binlog_events.inc [!Gtid_or_anon # !Begin # Table_map # Table_map # Write_rows # Write_rows # Xid]
24 DROP TRIGGER t2_trigger;
25 CREATE TRIGGER t2_trigger AFTER INSERT ON t2
26 FOR EACH ROW INSERT INTO t1(b) VALUES (1);
27 include/save_binlog_position.inc
28 INSERT INTO t2 VALUES ();
29 include/assert_binlog_events.inc [!Gtid_or_anon # !Begin # Table_map # Table_map # Write_rows # Write_rows # Xid]
30 DROP TRIGGER t2_trigger;
31 CREATE TRIGGER t2_trigger AFTER INSERT ON t2
32 FOR EACH ROW UPDATE t1 SET a = DEFAULT;
33 include/save_binlog_position.inc
34 INSERT INTO t2 VALUES ();
35 include/assert_binlog_events.inc [!Gtid_or_anon # !Begin # Table_map # Table_map # Write_rows # Update_rows # Xid]
36 DROP TRIGGER t2_trigger;
37 CREATE TRIGGER t2_trigger AFTER INSERT ON t2
38 FOR EACH ROW UPDATE t1 SET b = DEFAULT;
39 include/save_binlog_position.inc
40 INSERT INTO t2 VALUES ();
41 include/assert_binlog_events.inc [!Gtid_or_anon # !Begin # Table_map # Table_map # Write_rows # Update_rows # Xid]
42 DROP TRIGGER t2_trigger;
43 # Test R2.
44 CREATE TRIGGER t2_trigger AFTER INSERT ON t2
45 FOR EACH ROW INSERT INTO t3 VALUES ();
46 include/save_binlog_position.inc
47 INSERT INTO t2 VALUES ();
48 include/assert_binlog_events.inc [!Gtid_or_anon # !Begin # Query # Xid]
49 DROP TRIGGER t2_trigger;
50 # Test R3.
51 include/save_binlog_position.inc
52 INSERT INTO t1 VALUES ();
53 include/assert_binlog_events.inc [!Gtid_or_anon # !Begin # Table_map # Write_rows # Xid]
54 include/save_binlog_position.inc
55 INSERT INTO t1 (b) VALUES (DEFAULT);
56 include/assert_binlog_events.inc [!Gtid_or_anon # !Begin # Table_map # Write_rows # Xid]
57 include/save_binlog_position.inc
58 INSERT INTO t1 (b) VALUES (1);
59 include/assert_binlog_events.inc [!Gtid_or_anon # !Begin # Query # Xid]
60 DROP TABLE t1, t2, t3;