maria-discuss team mailing list archive

[Reindl Harald <h.reindl@xxxxxxxxxxxxx>]

i guess that below makes not much sense when running with 
"--binlog-format=row"

/mysql-test-run.pl --parallel=8 --max-test-fail=0 
--mysqld=--binlog-format=row

main.multi_update 'xtradb'               w8 [ fail ]
        Test ended at 2017-01-21 18:43:50

CURRENT_TEST: main.multi_update
--- /usr/share/mysql-test/r/multi_update.result 2017-01-17 
20:38:20.000000000 +0100
+++ /usr/share/mysql-test/r/multi_update.reject 2017-01-21 
18:43:49.979037948 +0100
@@ -1055,7 +1055,6 @@
 Warnings:
 Warning        1264    Out of range value for column 'field1' at row 1
 Warning        1264    Out of range value for column 'field1' at row 2
-Note   1592    Unsafe statement written to the binary log using 
statement format since BINLOG_FORMAT = STATEMENT. UPDATE IGNORE is 
unsafe because the order in which rows are updated determines which (if 
any) rows are ignored. This order cannot be predicted and may differ on 
master and the slave.
 UPDATE (SELECT 128 as col1) x, table_11757486 SET field1=x.col1;
 ERROR 22003: Out of range value for column 'field1' at row 1
 UPDATE table_11757486 SET field1=128;
@@ -1069,7 +1068,6 @@
 Warnings:
 Warning        1264    Out of range value for column 'field1' at row 1
 Warning        1264    Out of range value for column 'field1' at row 2
-Note   1592    Unsafe statement written to the binary log using 
statement format since BINLOG_FORMAT = STATEMENT. UPDATE IGNORE is 
unsafe because the order in which rows are updated determines which (if 
any) rows are ignored. This order cannot be predicted and may differ on 
master and the slave.
 DROP TABLE table_11757486;
 SET SESSION SQL_MODE=default;
 end of 10.0 tests

mysqltest: Result length mismatch