From 06eaf7232e9a920468c0f8d74dcf2fe8b555501c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 14:24:36 +0200 Subject: Adding upstream version 1:10.11.6. Signed-off-by: Daniel Baumann --- .../suite/binlog/include/insert_select-binlog.test | 38 ++++++++++++++++++++++ 1 file changed, 38 insertions(+) create mode 100644 mysql-test/suite/binlog/include/insert_select-binlog.test (limited to 'mysql-test/suite/binlog/include/insert_select-binlog.test') diff --git a/mysql-test/suite/binlog/include/insert_select-binlog.test b/mysql-test/suite/binlog/include/insert_select-binlog.test new file mode 100644 index 00000000..ef22373a --- /dev/null +++ b/mysql-test/suite/binlog/include/insert_select-binlog.test @@ -0,0 +1,38 @@ +# Embedded server doesn't support binlog +-- source include/not_embedded.inc +-- source include/have_log_bin.inc + +--disable_warnings +drop table if exists t1,t2; +--enable_warnings + +# Check if a partly-completed INSERT SELECT in a MyISAM table goes into the +# binlog + +create table t1(a int, unique(a)); +insert into t1 values(2); +create table t2(a int); +insert into t2 values(1),(2); +reset master; +--error ER_DUP_ENTRY +insert into t1 select * from t2; +# The above should produce an error, but still be in the binlog; +# verify the binlog : +let $VERSION=`select version()`; +source include/show_binlog_events.inc; +select * from t1; +drop table t1, t2; + +# Verify that a partly-completed CREATE TABLE .. SELECT does not +# get into the binlog (Bug #6682) +create table t1(a int); +insert into t1 values(1),(1); +reset master; +--error ER_DUP_ENTRY +create table t2(unique(a)) select a from t1; +# The above should produce an error, *and* not appear in the binlog +let $VERSION=`select version()`; +source include/show_binlog_events.inc; +drop table t1; + +# End of 4.1 tests -- cgit v1.2.3