summaryrefslogtreecommitdiff
path: root/mysql-test/t/innodb.test
diff options
context:
space:
mode:
authorunknown <lars/lthalmann@dl145j.mysql.com>2007-07-02 13:42:39 +0200
committerunknown <lars/lthalmann@dl145j.mysql.com>2007-07-02 13:42:39 +0200
commitf00722b95e7fce173e51706d28fa3c5886d9f7e6 (patch)
tree999dba896cdd1de30a761a081f695ad4ed390607 /mysql-test/t/innodb.test
parentde0ba5c894df8f86512d025f4196d62687efb1bb (diff)
parente3a6b29b556fec051fbe7d8e61b23bf285dc2e02 (diff)
downloadmariadb-git-f00722b95e7fce173e51706d28fa3c5886d9f7e6.tar.gz
Merge mysql.com:/nfsdisk1/lars/bkroot/mysql-5.1-new-rpl
into mysql.com:/nfsdisk1/lars/MERGE/mysql-5.1-merge mysql-test/t/disabled.def: Auto merged sql/item_sum.cc: Auto merged sql/sql_base.cc: Auto merged sql/sql_yacc.yy: Auto merged include/my_base.h: Manual merge main->rpl 5.1 mysql-test/t/innodb.test: Manual merge main->rpl 5.1
Diffstat (limited to 'mysql-test/t/innodb.test')
-rw-r--r--mysql-test/t/innodb.test9
1 files changed, 7 insertions, 2 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test
index 1ca6b8b4d98..321a1f4763a 100644
--- a/mysql-test/t/innodb.test
+++ b/mysql-test/t/innodb.test
@@ -13,6 +13,11 @@
-- source include/not_embedded.inc
-- source include/have_innodb.inc
+-- source include/have_log_bin.inc
+
+# Disabling it temporarily for statement-based logging since some
+# tests are not safe while binlog is on.
+-- source include/have_binlog_format_mixed_or_row.inc
#
# Small basic test with ignore
@@ -774,7 +779,7 @@ CREATE TABLE `t2` (
insert into t1 values (1,1),(2,2);
insert into t2 values (1,1),(4,4);
reset master;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
UPDATE t2,t1 SET t2.a=t1.a+2;
# check
select * from t2 /* must be (3,1), (4,4) */;
@@ -786,7 +791,7 @@ delete from t2;
insert into t1 values (1,2),(3,4),(4,4);
insert into t2 values (1,2),(3,4),(4,4);
reset master;
---error ER_DUP_ENTRY_WITH_KEY_NAME
+--error ER_DUP_ENTRY
UPDATE t2,t1 SET t2.a=t2.b where t2.a=t1.a;
show master status /* there must be no UPDATE query event */;