[MDEV-6603] SBR failure upon executing a prepared statement with input placeholder under anonymous block Created: 2014-08-19  Updated: 2014-10-10  Resolved: 2014-08-20

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: N/A
Fix Version/s: 10.1.1

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-5317 Compound statement / anonymous blocks Closed

 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


Generated at Thu Feb 08 07:13:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.