Bug #89467 Redundant GTID unsafe mark for CREATE/DROP TEMPORARY TABLE in RBR/MBR
Submitted: 30 Jan 9:34 Modified: 23 Oct 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 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 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 15:28] Bogdan Kecman
Hi,

Thanks for the report and for the contribution. 

all best
Bogdan
[13 Jun 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 13:59] Laurynas Biveinis
Close as duplicate of WL#8872, fixed in 8.0.13?