Redundant GTID unsafe mark for CREATE/DROP TEMPORARY TABLE in RBR/MBR

[Nickolay Ihalainen]

Temporary tables are not logged in binlog for RBR after:
https://bugs.launchpad.net/percona-server/+bug/1668602

This makes tests passing for: https://bugs.mysql.com/bug.php?id=77354
even with:

@@ -11005,7 +11005,8 @@ bool THD::is_ddl_gtid_compatible()
GTID even if the transaction is rolled back.
This includes the execution inside Functions and Triggers.
*/
- if (in_multi_stmt_transaction_mode() || in_sub_stmt)
+ if ((in_multi_stmt_transaction_mode() || in_sub_stmt)
+ && !is_current_stmt_binlog_format_row())

Patch provided by customer fixes forever-opened Hibernate bug related to gtid and temporary tables inside transactions:
https://hibernate.atlassian.net/browse/HHH-9289

The bug is not applicable for upstream, because
https://bugs.mysql.com/bug.php?id=85258 still not applied

[Nickolay Ihalainen (ihanick)]

Test case:
docker run --name p7 --rm -e MYSQL_ALLOW_EMPTY_PASSWORD=1 -it percona:5.7.18 --server-id=51 --log-bin=mysql-bin --gtid_mode=off --log-slave-updates

create database test;
use test
set global log_bin_trust_function_creators=1;
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

[Laurynas Biveinis (laurynas-biveinis)]

https://github.com/percona/percona-server/pull/1929
https://github.com/percona/percona-server/pull/1930

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1816