diff options
author | unknown <jimw@mysql.com> | 2004-12-03 00:39:55 +0100 |
---|---|---|
committer | unknown <jimw@mysql.com> | 2004-12-03 00:39:55 +0100 |
commit | 117c7611a74ec27cf2f136b14155d29880613c74 (patch) | |
tree | 53ebea55676a1cbab3ffb260b9f465ae28508351 /mysql-test | |
parent | 5fc09be9a36cdd98691ff109788c2c5b0a9a2c69 (diff) | |
parent | 9286d1c1452d53dd36c94fbe94a3f99be7b1dfb2 (diff) | |
download | mariadb-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.result | 9 | ||||
-rw-r--r-- | mysql-test/t/insert_select.test | 13 |
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 # |