summaryrefslogtreecommitdiff
path: root/mysql-test/t/insert_select.test
diff options
context:
space:
mode:
authorjimw@mysql.com <>2005-03-30 17:32:44 -0800
committerjimw@mysql.com <>2005-03-30 17:32:44 -0800
commitaa4f3522300c692bb404bb445220ea7e7bd8c1e4 (patch)
treea533884083f291e5f5e1769824ce9cfb3354c78c /mysql-test/t/insert_select.test
parent690183d1a0b088ec49d37948a38cee5304d1d3e5 (diff)
downloadmariadb-git-aa4f3522300c692bb404bb445220ea7e7bd8c1e4.tar.gz
Remove result.es files and support for them, which requires splitting
up a couple of tests and adjusting the output of others. Exposes two bugs (9472 and 9508).
Diffstat (limited to 'mysql-test/t/insert_select.test')
-rw-r--r--mysql-test/t/insert_select.test31
1 files changed, 0 insertions, 31 deletions
diff --git a/mysql-test/t/insert_select.test b/mysql-test/t/insert_select.test
index 39b8bfcaaaa..ecc83e3883b 100644
--- a/mysql-test/t/insert_select.test
+++ b/mysql-test/t/insert_select.test
@@ -71,37 +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
-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
#