Debian Codegraph @

mysql-test/suite/binlog/t/binlog_stm_ps.test

raw
1 # This test is to verify replication with PS
2
3 -- source include/not_embedded.inc
4 -- source include/have_binlog_format_statement.inc
5
6 disable_query_log;
7 call mtr.add_suppression("Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT");
8 enable_query_log;
9
10 -- disable_query_log
11 reset master; # get rid of previous tests binlog
12 -- enable_query_log
13
14 --disable_warnings
15 drop table if exists t1;
16 --enable_warnings
17 reset master;
18
19 #
20 # Bug #26842: master binary log contains invalid queries - replication fails
21 #
22 create table t1 (a int);
23 prepare s from "insert into t1 values (@a),(?)";
24 set @a=98; execute s using @a;
25 prepare s from "insert into t1 values (?)";
26 set @a=99; execute s using @a;
27 prepare s from "insert into t1 select 100 limit ?";
28 set @a=100; execute s using @a;
29 source include/show_binlog_events.inc;
30 drop table t1;
31
32 --echo #
33 --echo # MDEV-10709 Expressions as parameters to Dynamic SQL
34 --echo #
35
36 FLUSH LOGS;
37 SET TIMESTAMP=UNIX_TIMESTAMP('2001-01-02 10:20:30.123456');
38 CREATE TABLE t1 (a DECIMAL(30,8));
39 PREPARE stmt FROM 'INSERT INTO t1 VALUES (?)';
40 EXECUTE stmt USING 10;
41 EXECUTE stmt USING 11e0;
42 EXECUTE stmt USING 12.1;
43 EXECUTE stmt USING '13';
44 EXECUTE stmt USING CURRENT_DATE;
45 EXECUTE stmt USING MAKETIME(10,20,30);
46 EXECUTE stmt USING CURRENT_TIME;
47 EXECUTE stmt USING CURRENT_TIME(3);
48 EXECUTE stmt USING CURRENT_TIME(6);
49 EXECUTE stmt USING CURRENT_TIMESTAMP;
50 EXECUTE stmt USING CURRENT_TIMESTAMP(3);
51 EXECUTE stmt USING CURRENT_TIMESTAMP(6);
52 SELECT * FROM t1;
53 --let $binlog_file = LAST
54 source include/show_binlog_events.inc;
55 DROP TABLE t1;
56 SET TIMESTAMP=DEFAULT;
57
58 --echo #
59 --echo # MDEV-10585 EXECUTE IMMEDIATE statement
60 --echo #
61
62 FLUSH LOGS;
63 CREATE TABLE t1 (a INT);
64 EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (101)';
65 SET @a=102;
66 EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (?)' USING @a;
67 SET @a=103;
68 SET @stmt='INSERT INTO t1 VALUES (?)';
69 EXECUTE IMMEDIATE @stmt USING @a;
70 --let $binlog_file = LAST
71 source include/show_binlog_events.inc;
72 DROP TABLE t1;
73
74 --echo #
75 --echo # MDEV-11360 Dynamic SQL: DEFAULT as a bind parameter
76 --echo #
77
78 FLUSH LOGS;
79 CREATE TABLE t1 (a INT DEFAULT 10);
80 EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (Default)';
81 --echo # The output of this query in 'Note' is a syntactically incorrect query.
82 --echo # But as it's never logged, it's ok. It should be human readable only.
83 EXECUTE IMMEDIATE 'EXPLAIN EXTENDED SELECT ?' USING Default;
84 EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (?)' USING Default;
85
86 DELIMITER $$;
87 CREATE PROCEDURE p1 ()
88 BEGIN
89 INSERT INTO t1 VALUES (Default);
90 # EXPLAIN should not be logged
91 EXECUTE IMMEDIATE 'EXPLAIN EXTENDED SELECT ?' USING Default;
92 EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (?)' USING Default;
93 END;
94 $$
95 DELIMITER ;$$
96 CALL p1;
97 DROP PROCEDURE p1;
98 DROP TABLE t1;
99
100 --let $binlog_file = LAST
101 source include/show_binlog_events.inc;
102
103 --echo #
104 --echo #MDEV-14467 Item_param: replace {INT|DECIMAL|REAL|STRING|TIME}_VALUE with Type_handler
105 --echo #
106
107 FLUSH LOGS;
108 CREATE TABLE t1 (a INT);
109 EXECUTE IMMEDIATE 'INSERT INTO t1 SELECT 1 LIMIT ?' USING 10;
110 EXECUTE IMMEDIATE 'INSERT INTO t1 SELECT 1 LIMIT ?' USING 10.1;
111 EXECUTE IMMEDIATE 'INSERT INTO t1 SELECT 1 LIMIT ?' USING 10.1e0;
112 EXECUTE IMMEDIATE 'INSERT INTO t1 SELECT 1 LIMIT ?' USING '10';
113 EXECUTE IMMEDIATE 'INSERT INTO t1 SELECT 1 LIMIT ?' USING TIME'10:10:10';
114 DROP TABLE t1;
115
116 --let $binlog_file = LAST
117 source include/show_binlog_events.inc;