Debian Codegraph @

mysql-test/suite/compat/oracle/r/binlog_stm_ps.result

raw
1 SET sql_mode=ORACLE;
2 #
3 # MDEV-10801 sql_mode: dynamic SQL placeholders
4 #
5 CREATE TABLE t1 (a INT, b INT);
6 SET @a=10, @b=20;
7 PREPARE stmt FROM 'INSERT INTO t1 VALUES (?,?)';
8 EXECUTE stmt USING @a, @b;
9 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:a,:b)';
10 EXECUTE stmt USING @a, @b;
11 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:aaa,:bbb)';
12 EXECUTE stmt USING @a, @b;
13 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:"a",:"b")';
14 EXECUTE stmt USING @a, @b;
15 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:"aaa",:"bbb")';
16 EXECUTE stmt USING @a, @b;
17 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:1,:2)';
18 EXECUTE stmt USING @a, @b;
19 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:222,:111)';
20 EXECUTE stmt USING @a, @b;
21 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:0,:65535)';
22 EXECUTE stmt USING @a, @b;
23 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:65535,:0)';
24 EXECUTE stmt USING @a, @b;
25 SELECT * FROM t1;
26 a b
27 10 20
28 10 20
29 10 20
30 10 20
31 10 20
32 10 20
33 10 20
34 10 20
35 10 20
36 include/show_binlog_events.inc
37 Log_name Pos Event_type Server_id End_log_pos Info
38 master-bin.000001 # Gtid # # GTID #-#-#
39 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT, b INT)
40 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
41 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (10,20)
42 master-bin.000001 # Query # # COMMIT
43 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
44 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (10,20)
45 master-bin.000001 # Query # # COMMIT
46 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
47 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (10,20)
48 master-bin.000001 # Query # # COMMIT
49 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
50 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (10,20)
51 master-bin.000001 # Query # # COMMIT
52 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
53 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (10,20)
54 master-bin.000001 # Query # # COMMIT
55 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
56 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (10,20)
57 master-bin.000001 # Query # # COMMIT
58 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
59 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (10,20)
60 master-bin.000001 # Query # # COMMIT
61 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
62 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (10,20)
63 master-bin.000001 # Query # # COMMIT
64 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
65 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (10,20)
66 master-bin.000001 # Query # # COMMIT
67 DROP TABLE t1;
68 #
69 # MDEV-16095 Oracle-style placeholder inside GROUP BY..WITH ROLLUP breaks replication
70 #
71 FLUSH LOGS;
72 CREATE TABLE t1 (d DATE);
73 INSERT INTO t1 VALUES ('1985-05-13'),('1989-12-24');
74 CREATE TABLE t2 (d DATE, c BIGINT);
75 BEGIN
76 EXECUTE IMMEDIATE 'INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, :param' USING 1;
77 EXECUTE IMMEDIATE 'INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, :param WITH ROLLUP' USING 1;
78 END;
79 $$
80 DROP TABLE t1,t2;
81 include/show_binlog_events.inc
82 Log_name Pos Event_type Server_id End_log_pos Info
83 master-bin.000002 # Binlog_checkpoint # # master-bin.000002
84 master-bin.000002 # Gtid # # GTID #-#-#
85 master-bin.000002 # Query # # use `test`; CREATE TABLE t1 (d DATE)
86 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
87 master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES ('1985-05-13'),('1989-12-24')
88 master-bin.000002 # Query # # COMMIT
89 master-bin.000002 # Gtid # # GTID #-#-#
90 master-bin.000002 # Query # # use `test`; CREATE TABLE t2 (d DATE, c BIGINT)
91 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
92 master-bin.000002 # Query # # use `test`; INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, 1
93 master-bin.000002 # Query # # COMMIT
94 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
95 master-bin.000002 # Query # # use `test`; INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, 1 WITH ROLLUP
96 master-bin.000002 # Query # # COMMIT
97 master-bin.000002 # Gtid # # GTID #-#-#
98 master-bin.000002 # Query # # use `test`; DROP TABLE "t1","t2" /* generated by server */