summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <jimw@mysql.com>2004-12-03 00:39:55 +0100
committerunknown <jimw@mysql.com>2004-12-03 00:39:55 +0100
commit117c7611a74ec27cf2f136b14155d29880613c74 (patch)
tree53ebea55676a1cbab3ffb260b9f465ae28508351 /mysql-test
parent5fc09be9a36cdd98691ff109788c2c5b0a9a2c69 (diff)
parent9286d1c1452d53dd36c94fbe94a3f99be7b1dfb2 (diff)
downloadmariadb-git-117c7611a74ec27cf2f136b14155d29880613c74.tar.gz
Merge
BitKeeper/etc/logging_ok: auto-union mysql-test/t/insert_select.test: Auto merged sql/sql_class.h: Auto merged mysql-test/r/insert_select.result: SCCS merged sql/sql_insert.cc: merge changes sql/sql_table.cc: e merge changes
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/insert_select.result9
-rw-r--r--mysql-test/t/insert_select.test13
2 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/insert_select.result b/mysql-test/r/insert_select.result
index 7c7ac152aa5..fcb4229fcdb 100644
--- a/mysql-test/r/insert_select.result
+++ b/mysql-test/r/insert_select.result
@@ -81,6 +81,15 @@ a
1
2
drop table t1, t2;
+create table t1(a int);
+insert into t1 values(1),(1);
+reset master;
+create table t2(unique(a)) select a from t1;
+Duplicate entry '1' for key 1
+show binlog events;
+Log_name Pos Event_type Server_id Orig_log_pos Info
+master-bin.001 4 Start 1 4 Server ver: VERSION, Binlog ver: 3
+drop table t1;
create table t1 (a int not null);
create table t2 (a int not null);
insert into t1 values (1);
diff --git a/mysql-test/t/insert_select.test b/mysql-test/t/insert_select.test
index db5dc8d91da..e1459310bb9 100644
--- a/mysql-test/t/insert_select.test
+++ b/mysql-test/t/insert_select.test
@@ -89,6 +89,19 @@ show binlog events;
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 1062
+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()`;
+--replace_result $VERSION VERSION
+show binlog events;
+drop table t1;
+
#
# Test of insert ... select from same table
#