Debian Codegraph @

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

raw
1 drop table if exists t1;
2 reset master;
3 create table t1 (a int);
4 prepare s from "insert into t1 values (@a),(?)";
5 set @a=98;
6 execute s using @a;
7 prepare s from "insert into t1 values (?)";
8 set @a=99;
9 execute s using @a;
10 prepare s from "insert into t1 select 100 limit ?";
11 set @a=100;
12 execute s using @a;
13 Warnings:
14 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted
15 include/show_binlog_events.inc
16 Log_name Pos Event_type Server_id End_log_pos Info
17 master-bin.000001 # Gtid # # GTID #-#-#
18 master-bin.000001 # Query # # use `test`; create table t1 (a int)
19 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
20 master-bin.000001 # User var # # @`a`=98
21 master-bin.000001 # Query # # use `test`; insert into t1 values (@a),(98)
22 master-bin.000001 # Query # # COMMIT
23 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
24 master-bin.000001 # Query # # use `test`; insert into t1 values (99)
25 master-bin.000001 # Query # # COMMIT
26 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
27 master-bin.000001 # Query # # use `test`; insert into t1 select 100 limit 100
28 master-bin.000001 # Query # # COMMIT
29 drop table t1;
30 #
31 # MDEV-10709 Expressions as parameters to Dynamic SQL
32 #
33 FLUSH LOGS;
34 SET TIMESTAMP=UNIX_TIMESTAMP('2001-01-02 10:20:30.123456');
35 CREATE TABLE t1 (a DECIMAL(30,8));
36 PREPARE stmt FROM 'INSERT INTO t1 VALUES (?)';
37 EXECUTE stmt USING 10;
38 EXECUTE stmt USING 11e0;
39 EXECUTE stmt USING 12.1;
40 EXECUTE stmt USING '13';
41 EXECUTE stmt USING CURRENT_DATE;
42 EXECUTE stmt USING MAKETIME(10,20,30);
43 EXECUTE stmt USING CURRENT_TIME;
44 EXECUTE stmt USING CURRENT_TIME(3);
45 EXECUTE stmt USING CURRENT_TIME(6);
46 EXECUTE stmt USING CURRENT_TIMESTAMP;
47 EXECUTE stmt USING CURRENT_TIMESTAMP(3);
48 EXECUTE stmt USING CURRENT_TIMESTAMP(6);
49 SELECT * FROM t1;
50 a
51 10.00000000
52 11.00000000
53 12.10000000
54 13.00000000
55 20010102.00000000
56 102030.00000000
57 102030.00000000
58 102030.12300000
59 102030.12345600
60 20010102102030.00000000
61 20010102102030.12300000
62 20010102102030.12345600
63 include/show_binlog_events.inc
64 Log_name Pos Event_type Server_id End_log_pos Info
65 master-bin.000002 # Binlog_checkpoint # # master-bin.000002
66 master-bin.000002 # Gtid # # GTID #-#-#
67 master-bin.000002 # Query # # use `test`; CREATE TABLE t1 (a DECIMAL(30,8))
68 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
69 master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (10)
70 master-bin.000002 # Query # # COMMIT
71 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
72 master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (11)
73 master-bin.000002 # Query # # COMMIT
74 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
75 master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (12.1)
76 master-bin.000002 # Query # # COMMIT
77 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
78 master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES ('13')
79 master-bin.000002 # Query # # COMMIT
80 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
81 master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (DATE'2001-01-02')
82 master-bin.000002 # Query # # COMMIT
83 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
84 master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (TIME'10:20:30')
85 master-bin.000002 # Query # # COMMIT
86 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
87 master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (TIME'10:20:30')
88 master-bin.000002 # Query # # COMMIT
89 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
90 master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (TIME'10:20:30.123')
91 master-bin.000002 # Query # # COMMIT
92 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
93 master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (TIME'10:20:30.123456')
94 master-bin.000002 # Query # # COMMIT
95 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
96 master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (TIMESTAMP'2001-01-02 10:20:30')
97 master-bin.000002 # Query # # COMMIT
98 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
99 master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (TIMESTAMP'2001-01-02 10:20:30.123')
100 master-bin.000002 # Query # # COMMIT
101 master-bin.000002 # Gtid # # BEGIN GTID #-#-#
102 master-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (TIMESTAMP'2001-01-02 10:20:30.123456')
103 master-bin.000002 # Query # # COMMIT
104 DROP TABLE t1;
105 SET TIMESTAMP=DEFAULT;
106 #
107 # MDEV-10585 EXECUTE IMMEDIATE statement
108 #
109 FLUSH LOGS;
110 CREATE TABLE t1 (a INT);
111 EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (101)';
112 SET @a=102;
113 EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (?)' USING @a;
114 SET @a=103;
115 SET @stmt='INSERT INTO t1 VALUES (?)';
116 EXECUTE IMMEDIATE @stmt USING @a;
117 include/show_binlog_events.inc
118 Log_name Pos Event_type Server_id End_log_pos Info
119 master-bin.000003 # Binlog_checkpoint # # master-bin.000003
120 master-bin.000003 # Gtid # # GTID #-#-#
121 master-bin.000003 # Query # # use `test`; CREATE TABLE t1 (a INT)
122 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
123 master-bin.000003 # Query # # use `test`; INSERT INTO t1 VALUES (101)
124 master-bin.000003 # Query # # COMMIT
125 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
126 master-bin.000003 # Query # # use `test`; INSERT INTO t1 VALUES (102)
127 master-bin.000003 # Query # # COMMIT
128 master-bin.000003 # Gtid # # BEGIN GTID #-#-#
129 master-bin.000003 # Query # # use `test`; INSERT INTO t1 VALUES (103)
130 master-bin.000003 # Query # # COMMIT
131 DROP TABLE t1;
132 #
133 # MDEV-11360 Dynamic SQL: DEFAULT as a bind parameter
134 #
135 FLUSH LOGS;
136 CREATE TABLE t1 (a INT DEFAULT 10);
137 EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (Default)';
138 # The output of this query in 'Note' is a syntactically incorrect query.
139 # But as it's never logged, it's ok. It should be human readable only.
140 EXECUTE IMMEDIATE 'EXPLAIN EXTENDED SELECT ?' USING Default;
141 id select_type table type possible_keys key key_len ref rows filtered Extra
142 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
143 Warnings:
144 Note 1003 select default AS `?`
145 EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (?)' USING Default;
146 CREATE PROCEDURE p1 ()
147 BEGIN
148 INSERT INTO t1 VALUES (Default);
149 # EXPLAIN should not be logged
150 EXECUTE IMMEDIATE 'EXPLAIN EXTENDED SELECT ?' USING Default;
151 EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (?)' USING Default;
152 END;
153 $$
154 CALL p1;
155 id select_type table type possible_keys key key_len ref rows filtered Extra
156 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used
157 DROP PROCEDURE p1;
158 DROP TABLE t1;
159 include/show_binlog_events.inc
160 Log_name Pos Event_type Server_id End_log_pos Info
161 master-bin.000004 # Binlog_checkpoint # # master-bin.000004
162 master-bin.000004 # Gtid # # GTID #-#-#
163 master-bin.000004 # Query # # use `test`; CREATE TABLE t1 (a INT DEFAULT 10)
164 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
165 master-bin.000004 # Query # # use `test`; INSERT INTO t1 VALUES (Default)
166 master-bin.000004 # Query # # COMMIT
167 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
168 master-bin.000004 # Query # # use `test`; INSERT INTO t1 VALUES (DEFAULT)
169 master-bin.000004 # Query # # COMMIT
170 master-bin.000004 # Gtid # # GTID #-#-#
171 master-bin.000004 # Query # # use `test`; CREATE DEFINER=`root`@`localhost` PROCEDURE `p1`()
172 BEGIN
173 INSERT INTO t1 VALUES (Default);
174 # EXPLAIN should not be logged
175 EXECUTE IMMEDIATE 'EXPLAIN EXTENDED SELECT ?' USING Default;
176 EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (?)' USING Default;
177 END
178 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
179 master-bin.000004 # Query # # use `test`; INSERT INTO t1 VALUES (Default)
180 master-bin.000004 # Query # # COMMIT
181 master-bin.000004 # Gtid # # BEGIN GTID #-#-#
182 master-bin.000004 # Query # # use `test`; INSERT INTO t1 VALUES (DEFAULT)
183 master-bin.000004 # Query # # COMMIT
184 master-bin.000004 # Gtid # # GTID #-#-#
185 master-bin.000004 # Query # # use `test`; DROP PROCEDURE p1
186 master-bin.000004 # Gtid # # GTID #-#-#
187 master-bin.000004 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
188 #
189 #MDEV-14467 Item_param: replace {INT|DECIMAL|REAL|STRING|TIME}_VALUE with Type_handler
190 #
191 FLUSH LOGS;
192 CREATE TABLE t1 (a INT);
193 EXECUTE IMMEDIATE 'INSERT INTO t1 SELECT 1 LIMIT ?' USING 10;
194 Warnings:
195 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted
196 EXECUTE IMMEDIATE 'INSERT INTO t1 SELECT 1 LIMIT ?' USING 10.1;
197 Warnings:
198 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted
199 EXECUTE IMMEDIATE 'INSERT INTO t1 SELECT 1 LIMIT ?' USING 10.1e0;
200 Warnings:
201 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted
202 EXECUTE IMMEDIATE 'INSERT INTO t1 SELECT 1 LIMIT ?' USING '10';
203 Warnings:
204 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted
205 EXECUTE IMMEDIATE 'INSERT INTO t1 SELECT 1 LIMIT ?' USING TIME'10:10:10';
206 Warnings:
207 Note 1592 Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because it uses a LIMIT clause. This is unsafe because the set of rows included cannot be predicted
208 DROP TABLE t1;
209 include/show_binlog_events.inc
210 Log_name Pos Event_type Server_id End_log_pos Info
211 master-bin.000005 # Binlog_checkpoint # # master-bin.000005
212 master-bin.000005 # Gtid # # GTID #-#-#
213 master-bin.000005 # Query # # use `test`; CREATE TABLE t1 (a INT)
214 master-bin.000005 # Gtid # # BEGIN GTID #-#-#
215 master-bin.000005 # Query # # use `test`; INSERT INTO t1 SELECT 1 LIMIT 10
216 master-bin.000005 # Query # # COMMIT
217 master-bin.000005 # Gtid # # BEGIN GTID #-#-#
218 master-bin.000005 # Query # # use `test`; INSERT INTO t1 SELECT 1 LIMIT 10
219 master-bin.000005 # Query # # COMMIT
220 master-bin.000005 # Gtid # # BEGIN GTID #-#-#
221 master-bin.000005 # Query # # use `test`; INSERT INTO t1 SELECT 1 LIMIT 10
222 master-bin.000005 # Query # # COMMIT
223 master-bin.000005 # Gtid # # BEGIN GTID #-#-#
224 master-bin.000005 # Query # # use `test`; INSERT INTO t1 SELECT 1 LIMIT 10
225 master-bin.000005 # Query # # COMMIT
226 master-bin.000005 # Gtid # # BEGIN GTID #-#-#
227 master-bin.000005 # Query # # use `test`; INSERT INTO t1 SELECT 1 LIMIT 101010
228 master-bin.000005 # Query # # COMMIT
229 master-bin.000005 # Gtid # # GTID #-#-#
230 master-bin.000005 # Query # # use `test`; DROP TABLE `t1` /* generated by server */