diff options
author | jimw@mysql.com <> | 2005-04-01 19:17:15 -0800 |
---|---|---|
committer | jimw@mysql.com <> | 2005-04-01 19:17:15 -0800 |
commit | 5865330a9e27c050dd644705457eb5d4415e27fd (patch) | |
tree | 0f605570b31eecc8dd6b58343d5a07d32375e540 /mysql-test/t/insert_select.test | |
parent | 2292480e795a02973b828a37f826c6e4e0192b69 (diff) | |
parent | 623a5d5a57f8f8ee2674245e0abafaef698577fb (diff) | |
download | mariadb-git-5865330a9e27c050dd644705457eb5d4415e27fd.tar.gz |
Merge embedded server testing changes from 4.1.
Diffstat (limited to 'mysql-test/t/insert_select.test')
-rw-r--r-- | mysql-test/t/insert_select.test | 33 |
1 files changed, 0 insertions, 33 deletions
diff --git a/mysql-test/t/insert_select.test b/mysql-test/t/insert_select.test index 371df339b57..40dc4e20093 100644 --- a/mysql-test/t/insert_select.test +++ b/mysql-test/t/insert_select.test @@ -71,39 +71,6 @@ WHERE numeropost=9 ORDER BY numreponse ASC; DROP TABLE t1,t2; -# 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 1062 -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()`; ---replace_result $VERSION VERSION ---replace_column 2 # 5 # -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 ---replace_column 2 # 5 # -show binlog events; -drop table t1; - # # Test of insert ... select from same table # |