Debian Codegraph @

mysql-test/suite/compat/oracle/t/binlog_stm_ps.test

raw
1 --source include/not_embedded.inc
2 --source include/have_binlog_format_statement.inc
3
4 --disable_query_log
5 reset master; # get rid of previous tests binlog
6 --enable_query_log
7
8 SET sql_mode=ORACLE;
9
10 --echo #
11 --echo # MDEV-10801 sql_mode: dynamic SQL placeholders
12 --echo #
13
14 CREATE TABLE t1 (a INT, b INT);
15 SET @a=10, @b=20;
16 PREPARE stmt FROM 'INSERT INTO t1 VALUES (?,?)';
17 EXECUTE stmt USING @a, @b;
18 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:a,:b)';
19 EXECUTE stmt USING @a, @b;
20 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:aaa,:bbb)';
21 EXECUTE stmt USING @a, @b;
22 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:"a",:"b")';
23 EXECUTE stmt USING @a, @b;
24 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:"aaa",:"bbb")';
25 EXECUTE stmt USING @a, @b;
26 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:1,:2)';
27 EXECUTE stmt USING @a, @b;
28 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:222,:111)';
29 EXECUTE stmt USING @a, @b;
30 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:0,:65535)';
31 EXECUTE stmt USING @a, @b;
32 PREPARE stmt FROM 'INSERT INTO t1 VALUES (:65535,:0)';
33 EXECUTE stmt USING @a, @b;
34 SELECT * FROM t1;
35 --let $binlog_file = LAST
36 source include/show_binlog_events.inc;
37 DROP TABLE t1;
38
39
40 --echo #
41 --echo # MDEV-16095 Oracle-style placeholder inside GROUP BY..WITH ROLLUP breaks replication
42 --echo #
43
44 FLUSH LOGS;
45 CREATE TABLE t1 (d DATE);
46 INSERT INTO t1 VALUES ('1985-05-13'),('1989-12-24');
47 CREATE TABLE t2 (d DATE, c BIGINT);
48 DELIMITER $$;
49 BEGIN
50 EXECUTE IMMEDIATE 'INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, :param' USING 1;
51 EXECUTE IMMEDIATE 'INSERT INTO t2 SELECT d, COUNT(*) FROM t1 GROUP BY d, :param WITH ROLLUP' USING 1;
52 END;
53 $$
54 DELIMITER ;$$
55 DROP TABLE t1,t2;
56 --let $binlog_file = LAST
57 source include/show_binlog_events.inc;