Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: N/A
-
Fix Version/s: 10.1.1
-
Component/s: None
-
Labels:None
Description
--source include/master-slave.inc
|
--source include/have_binlog_format_statement.inc
|
|
CREATE TABLE t1 (a INT PRIMARY KEY); |
|
PREPARE stmt FROM "BEGIN NOT ATOMIC |
INSERT INTO t1 VALUES (?);
|
END"; |
SET @val = 1; |
EXECUTE stmt USING @val; |
DEALLOCATE PREPARE stmt; |
|
DROP TABLE t1; |
|
--sync_slave_with_master
|
Binlog:
CREATE TABLE t1 (a INT PRIMARY KEY)
|
/*!*/;
|
# at 449
|
#140819 12:06:18 server id 1 end_log_pos 487 GTID 0-1-2
|
/*!100001 SET @@session.gtid_seq_no=2*//*!*/;
|
BEGIN
|
/*!*/;
|
# at 487
|
#140819 12:06:18 server id 1 end_log_pos 575 Query thread_id=8 exec_time=0 error_code=0
|
SET TIMESTAMP=1408435578/*!*/;
|
SET @@session.sql_mode=11936128518282651045/*!*/;
|
INSERT INTO t1 VALUES (?)
|
/*!*/;
|
# at 575
|
#140819 12:06:18 server id 1 end_log_pos 644 Query thread_id=8 exec_time=0 error_code=0
|
SET TIMESTAMP=1408435578/*!*/;
|
COMMIT
|
/*!*/;
|
# at 644
|
#140819 12:06:18 server id 1 end_log_pos 682 GTID 0-1-3
|
/*!100001 SET @@session.gtid_seq_no=3*//*!*/;
|
# at 682
|
#140819 12:06:18 server id 1 end_log_pos 786 Query thread_id=8 exec_time=0 error_code=0
|
SET TIMESTAMP=1408435578/*!*/;
|
SET @@session.sql_mode=0/*!*/;
|
DROP TABLE `t1` /* generated by server */
|
SQL thread failure:
Last_Errno 1064
|
Last_Error Error 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '?)' at line 1' on query. Default database: 'test'. Query: 'INSERT INTO t1 VALUES (?)'
|
commit 6502f42f679e605fcdbd6c8b49d2813f553001b0
|
Author: Sergei Golubchik <serg@mariadb.org>
|
Date: Mon Aug 18 14:28:48 2014 +0200
|
Attachments
Issue Links
- relates to
-
MDEV-5317 Compound statement / anonymous blocks
-
- Closed
-