summaryrefslogtreecommitdiff
path: root/mysql-test/t/multi_update.test
diff options
context:
space:
mode:
authorunknown <mats@kindahl-laptop.dnsalias.net>2007-06-19 11:09:22 +0200
committerunknown <mats@kindahl-laptop.dnsalias.net>2007-06-19 11:09:22 +0200
commit312ae6ecfc4082a88ed123b90ff32dacf9e2883d (patch)
tree629ea4f8e48fd0953ed6a695d09383118bfd6b25 /mysql-test/t/multi_update.test
parent511ef0cc292f63cc4ae6b7d3bb0fc9d909616187 (diff)
downloadmariadb-git-312ae6ecfc4082a88ed123b90ff32dacf9e2883d.tar.gz
Fixes to tests and test results.
mysql-test/r/binlog_unsafe.result: Result change mysql-test/r/rpl_loaddata_fatal.result: Result change mysql-test/r/rpl_udf.result: Result change mysql-test/t/binlog_innodb.test: Test requires binary log mysql-test/t/binlog_unsafe.test: Test requires binary log mysql-test/t/multi_update.test: Test requires binary log. Error changed for a statement. mysql-test/t/rpl_row_basic_11bugs.test: Error changed for a statement.
Diffstat (limited to 'mysql-test/t/multi_update.test')
-rw-r--r--mysql-test/t/multi_update.test7
1 files changed, 4 insertions, 3 deletions
diff --git a/mysql-test/t/multi_update.test b/mysql-test/t/multi_update.test
index 79d3d18dd13..6f5ac70a34b 100644
--- a/mysql-test/t/multi_update.test
+++ b/mysql-test/t/multi_update.test
@@ -3,7 +3,8 @@
#
# Requires grants, so won't work with embedded server test
--- source include/not_embedded.inc
+source include/not_embedded.inc;
+source include/have_log_bin.inc;
--disable_warnings
drop table if exists t1,t2,t3;
@@ -594,7 +595,7 @@ set @@session.binlog_format= mixed;
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) */;
@@ -607,7 +608,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 the UPDATE query event */;