Redundant GTID unsafe mark for CREATE/DROP TEMPORARY TABLE in RBR/MBR
| 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 |
Fix Released
|
Medium
|
Laurynas Biveinis | |||
| 5.7 |
Fix Released
|
Medium
|
Laurynas Biveinis | |||
Bug Description
Temporary tables are not logged in binlog for RBR after:
https:/
This makes tests passing for: https:/
even with:
@@ -11005,7 +11005,8 @@ bool THD::is_
GTID even if the transaction is rolled back.
This includes the execution inside Functions and Triggers.
*/
- if (in_multi_
+ if ((in_multi_
+ && !is_current_
Patch provided by customer fixes forever-opened Hibernate bug related to gtid and temporary tables inside transactions:
https:/
The bug is not applicable for upstream, because
https:/
| Nickolay Ihalainen (ihanick) wrote | #1 |
| tags: | added: merge-reg |
| tags: |
added: merge-regression removed: merge-reg |
| summary: |
- is no need in marking create/drop temporary table unsafe for gtid - (introduced in mysql-bug):77354 after lp:1668602 + redundant GTID unsafe mark for create/drop temporary table after + lp:1668602 |
| summary: |
- redundant GTID unsafe mark for create/drop temporary table after - lp:1668602 + Redundant GTID unsafe mark for CREATE/DROP TEMPORARY TABLE in RBR/MBR |
| Laurynas Biveinis (laurynas-biveinis) wrote | #2 |
| Shahriyar Rzayev (rzayev-sehriyar) wrote | #3 |
Test case:
docker run --name p7 --rm -e MYSQL_ALLOW_
create database test;
use test
set global log_bin_
delimiter //
CREATE FUNCTION `test_func` () RETURNS varchar(30) CHARSET utf8
BEGIN
DROP TEMPORARY TABLE IF EXISTS test_func_1;
DROP TEMPORARY TABLE IF EXISTS test_func_2;
DROP TEMPORARY TABLE IF EXISTS test_func_3;
DROP TEMPORARY TABLE IF EXISTS test_func_4;
RETURN "hello";
END//
delimiter ;
SELECT test_func();
show binlog events in 'mysql-bin.000003';
drop temporary table statement is not logged (compare to PS <= 5.7.17 & upstream <= 5.7.19