set session binlog_format =  mixed;

create temporary table test.t22(a int) engine=MEMORY;

create temporary table test.t23(a int) engine=innodb;

begin;

 insert into test.t22(a) values(1);

 INSERT INTO test.t23 SELECT * FROM test.t22;

 SELECT SLEEP(30);

 commit;

Error 'Table 'test.t23' doesn't exist' on query. Default database: 'test'. Query: 'INSERT INTO test.t23 SELECT * FROM test.t22'

#190903 13:42:58 server id 1  end_log_pos 614 CRC32 0x84f2060c  GTID 0-1-2 ddl

/*!100001 SET @@session.gtid_seq_no=2*//*!*/;

# at 614

#190903 13:42:58 server id 1  end_log_pos 735 CRC32 0xa207f25e  Query   thread_id=15    exec_time=6     error_code=0

SET TIMESTAMP=1567510978/*!*/;

/*!\C utf8 *//*!*/;

SET @@session.character_set_client=33,@@session.collation_connection=45,@@session.collation_server=33/*!*/;

DROP /*!40005 TEMPORARY */ TABLE IF EXISTS `t23`,`t22`

/*!*/;

# at 735

#190903 13:42:58 server id 1  end_log_pos 777 CRC32 0x9d1a52fd  GTID 0-1-3 ddl

/*!100001 SET @@session.gtid_seq_no=3*//*!*/;

BEGIN

/*!*/;

# at 777

#190903 13:42:58 server id 1  end_log_pos 896 CRC32 0xfa6b3120  Query   thread_id=15    exec_time=0     error_code=0

SET TIMESTAMP=1567510978/*!*/;

/*!\C utf8mb4 *//*!*/;

SET @@session.character_set_client=45,@@session.collation_connection=45,@@session.collation_server=33/*!*/;

create temporary table test.t23(a int) engine=innodb

/*!*/;

# at 896

#190903 13:42:58 server id 1  end_log_pos 996 CRC32 0x8e6e177a  Query   thread_id=15    exec_time=0     error_code=0

SET TIMESTAMP=1567510978/*!*/;

insert into test.t22(a) values(1)

/*!*/;

# at 996

#190903 13:42:58 server id 1  end_log_pos 1106 CRC32 0x08d4bda9         Query   thread_id=15    exec_time=0     error_code=0

SET TIMESTAMP=1567510978/*!*/;

INSERT INTO test.t23 SELECT * FROM test.t22

/*!*/;

# at 1106

#190903 13:42:58 server id 1  end_log_pos 1181 CRC32 0x2ef6d902         Query   thread_id=15    exec_time=6     error_code=0

SET TIMESTAMP=1567510978/*!*/;

ROLLBACK

/*!*/;

DELIMITER ;

# End of log file

ROLLBACK /* added by mysqlbinlog */;