Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/suite/binlog/t/

Edit File: binlog_drop_temp_table_on_disconnect_row_mix.test

# ====== Purpose =======
#
# This test verifies that DROP for a temporary table created
# in Row mode is not logged in binlog at session disconnect.
#
# ====== Implementation ======
#
# Create temporary tables in Row mode using different engines,
# also create a temporary table in Statement mode, now when you connect to the session
# after a disconnect print the output of show binlog events.
# This will verify that the DROP for temporary table created in statement
# mode is written to binary log at session disconnect, but for  the temporary table
# created in Row mode no DROP statement for temporary table is logged at session
# disconnect.
#
# ====== References =======
#
# Bug#28606948:BACKPORT OF BUG #24670909 TO 5.7.22
#
# The name of this file has row_mix even though we are just testing in row
# format because we want the name of tests to be consistent in 5.7 and 8.0

--source include/have_log_bin.inc
--source include/have_myisam.inc
--source include/have_binlog_format_row.inc

RESET MASTER;

CREATE TABLE t1(a INT) ENGINE=InnoDB;
CREATE TABLE t2(a INT) ENGINE=MyISAM;

--source include/count_sessions.inc

--connect(con1,localhost,root)

SET @saved_binlog_format= @@SESSION.binlog_format;
# A DROP for tmp10 should be binlogged because CREATE TABLE is
# created in Statement mode

SET SESSION binlog_format= 'STATEMENT';
CREATE TEMPORARY TABLE tmp10 (a INT);
SET SESSION binlog_format= @saved_binlog_format;

# No DROP should be logged for any of the statements below
CREATE TEMPORARY TABLE tmp1 ENGINE=InnoDB SELECT * FROM t1;
CREATE TEMPORARY TABLE tmp2 ENGINE=MyISAM SELECT * FROM t2;
CREATE TEMPORARY TABLE tmp3 ENGINE=MyISAM SELECT * FROM t1;
CREATE TEMPORARY TABLE tmp4 ENGINE=InnoDB SELECT * FROM t2;
CREATE TEMPORARY TABLE tmp5 (a INT) ENGINE=InnoDB;
CREATE TEMPORARY TABLE tmp6 (a INT) ENGINE=MyISAM;
CREATE TEMPORARY TABLE tmp7 LIKE t1;
CREATE TEMPORARY TABLE tmp8 LIKE t2;

--disconnect con1
--connection default
--source include/wait_until_count_sessions.inc

--source include/show_binlog_events.inc

DROP TABLE t1, t2;