SET STATEMENT incorrectly works on second prepared statement execution
Bug #1333650 reported by
Oleksandr "Sanja" Byelkin
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
Triaged
|
High
|
Unassigned | |||
5.7 |
Triaged
|
High
|
Unassigned |
Bug Description
Here is a test suite:
set session binlog_
PREPARE stmt1 FROM 'set statement binlog_format=row for SELECT @@binlog_format';
execute stmt1;
execute stmt1;
deallocate prepare stmt1;
Result of the execution is:
set session binlog_
PREPARE stmt1 FROM 'set statement binlog_format=row for SELECT @@binlog_format';
execute stmt1;
@@binlog_format
ROW
execute stmt1;
@@binlog_format
MIXED
deallocate prepare stmt1;
tags: | added: set-statement |
To post a comment you must log in.
I forgot to mention that it is 5.6 server