GTT: ER_BINLOG_STMT_MODE_AND_ROW_ENGINE upon INSERT

--source include/master-slave.inc

--source include/have_innodb.inc

--source include/have_binlog_format_statement.inc

CREATE TABLE t (c INT) ENGINE=InnoDB;

CREATE GLOBAL TEMPORARY TABLE gtt (c INT) ENGINE=InnoDB ON COMMIT PRESERVE ROWS;

CREATE TRIGGER tr AFTER INSERT ON t FOR EACH ROW INSERT INTO gtt VALUES (NEW.c);

# SBR Incompatibility

# Expected: Successful INSERT (forcing ROW-based for the GTT part).

# Actual: Fails with ER_BINLOG_STMT_MODE_AND_ROW_ENGINE (1665).

INSERT INTO t VALUES (1);

--connection master

TRUNCATE TABLE gtt;

DROP TABLE t, gtt;

--source include/rpl_end.inc

mysqltest: At line 13: query 'INSERT INTO t VALUES (1)' failed: ER_BINLOG_STMT_MODE_AND_ROW_ENGINE (1665): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging.