Bug #89467 Redundant GTID unsafe mark for CREATE/DROP TEMPORARY TABLE in RBR/MBR
Submitted: 30 Jan 2018 9:34 Modified: 23 Oct 2018 13:59
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Replication Severity:S3 (Non-critical)
Version:8.0.4 OS:Any
Assigned to: CPU Architecture:Any

[30 Jan 2018 9:34] Laurynas Biveinis 
Description:
After fixing bug 72475, bug 83003, and bug 85258, nothing involving temporary tables is logged to binary log in row/mixed format.

However, CREATE/DROP TEMPORARY TABLE are still considered unsafe for use in stored functions / triggers / multi-statement transactions in row/mixed format, even though the underlying causes have been removed.

How to repeat:
Testcase from bug 77354

Suggested fix:
Mark CREATE/DROP TEMPORARY TABLE as unsafe inside transactions in SBR only.

I have a fix which I'm porting now to 8.0 and will upload after testing.
[2 Feb 2018 7:37] Laurynas Biveinis 
Bug 89467 fix for 8.0.4

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: bug89467-8.0.4.patch (application/octet-stream, text), 423.67 KiB.
[2 Feb 2018 15:28] MySQL Verification Team 
Hi,

Thanks for the report and for the contribution. 

all best
Bogdan
[13 Jun 2018 12:37] Laurynas Biveinis 
Bug 89467 fix for 8.0.11

(*) I confirm the code being submitted is offered under the terms of the OCA, and that I am authorized to contribute it.

Contribution: bug89467-8.0.11.patch (application/octet-stream, text), 426.86 KiB.
[23 Oct 2018 13:59] Laurynas Biveinis 
Close as duplicate of WL#8872, fixed in 8.0.13?