Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
-
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