maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #08523
connect on IBM s390
Hi Olivier,
MariaDB fails with some Connect tests on IBM s390.
Please have a look into Debian build bot results:
https://buildd.debian.org/status/fetch.php?pkg=mariadb-10.0&arch=s390x&ver=10.0.17-1&stamp=1428754888
I currently have a temporary access to an IMB s390 machine.
It would be nice to fix the failures.
Please find the mtr log attached. This is what I got on this test
machine. The failures are very similar to what Debian build bot has.
If you don't mind, I'd like to start fixing failures with "bin" and "dbf".
1. dbf.bin fails because Connect writes the DBF file header using the
current platform endiannes, while from my understanding it should always
write the header using little endianness. This should be fixed in
the relevant DBF code in Connect. Can you please do this?
2. connect.bin fails because Connect treats columns in the current
machine byte order, while Testbal.dat was created on a little endian
machine.
I can see a few options to fix this test failure:
a. Disable on big endian machines. Bad idea.
b. Make it possible to specify endiannes of a data file
(or even per column), so we can tell in the tests that Testbal.dat
(or its relevant columns) are in little endian format.
Perhaps it's already possible in the latest Connect versions. Is it?
If it's not, how difficult would be to implement this?
c. Have two pre-created files Testbal_le.dat and Testbal_be.dat and
load the one that suites the current machine endiannes.
I'm thinking of going "c" now, with a hope to have both "b" and "c" in
the future. If you agree, we'll need a big-endian version of
Testbal.dat.
3. It seems that some other tests fail for the same reasons with #2.
Having a big-endian version of the test data files, or having
the endian flag in CREATE TABLE, would fix some of them.
I suggest we fix "bin" first, and make sure it works fine an all
platforms. Then do the same thing for the other tests.
Thanks.
Logging: ./mtr --max-test-fail=0 --force --suite=connect
vardir: /opt/maria-git/server/mysql-test/var
Checking leftover processes...
- found old pid 6689 in 'mysqld.1.pid', killing it...
process did not exist!
Removing old var directory...
Creating var directory '/opt/maria-git/server/mysql-test/var'...
Checking supported features...
MariaDB Version 10.0.18-MariaDB-debug
- SSL connections supported
- binaries are debug compiled
Using suites: connect
Collecting tests...
Installing system database...
==============================================================================
TEST RESULT TIME (ms) or COMMENT
--------------------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
connect.json [ pass ] 87
connect.part_file [ fail ]
Test ended at 2015-05-04 03:56:23
CURRENT_TEST: connect.part_file
--- /opt/maria-git/server/storage/connect/mysql-test/connect/r/part_file.result 2015-04-24 12:36:18.656342908 +0200
+++ /opt/maria-git/server/storage/connect/mysql-test/connect/r/part_file.reject 2015-05-04 03:56:22.806342908 +0200
@@ -141,22 +141,14 @@
2 2 3 t1 part3 81 eighty one
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id = 10;
id select_type table partitions type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 2 const PRIMARY PRIMARY 4 const 1
+1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
SELECT * FROM t1 WHERE id = 10;
rwid rnum prtn tbn fid id msg
-1 1 2 t1 part2 10 ten
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id >= 10;
id select_type table partitions type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 2,3 range PRIMARY PRIMARY 4 NULL 7 Using where
+1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
SELECT * FROM t1 WHERE id >= 10;
rwid rnum prtn tbn fid id msg
-1 1 2 t1 part2 10 ten
-3 3 2 t1 part2 20 twenty
-4 4 2 t1 part2 35 thirty five
-2 2 2 t1 part2 40 forty
-1 1 3 t1 part3 60 sixty
-3 3 3 t1 part3 72 seventy two
-2 2 3 t1 part3 81 eighty one
SELECT count(*) FROM t1 WHERE id < 10;
count(*)
4
@@ -172,10 +164,9 @@
3 3
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id > 50;
id select_type table partitions type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 3 range PRIMARY PRIMARY 4 NULL 3 Using where
+1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
SELECT * FROM t1 WHERE id = 35;
rwid rnum prtn tbn fid id msg
-4 4 2 t1 part2 35 thirty five
SELECT * FROM dr1 ORDER BY fname, ftype;
fname ftype
part1 .fnx
@@ -309,7 +300,7 @@
part3 .txt
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id = 10;
id select_type table partitions type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 1 ref XID XID 4 const 1
+1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
DROP INDEX XID ON t1;
SHOW INDEX FROM t1;
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
@@ -332,7 +323,7 @@
part3 .txt
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id = 10;
id select_type table partitions type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 1 const PRIMARY PRIMARY 4 const 1
+1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
ALTER TABLE t1 DROP PRIMARY KEY;
SHOW INDEX FROM t1;
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
mysqltest: Result length mismatch
- saving '/opt/maria-git/server/mysql-test/var/log/connect.part_file/' to '/opt/maria-git/server/mysql-test/var/log/connect.part_file/'
connect.part_table [ fail ]
Test ended at 2015-05-04 03:56:23
CURRENT_TEST: connect.part_table
--- /opt/maria-git/server/storage/connect/mysql-test/connect/r/part_table.result 2015-04-24 12:36:18.656342908 +0200
+++ /opt/maria-git/server/storage/connect/mysql-test/connect/r/part_table.reject 2015-05-04 03:56:23.646342908 +0200
@@ -137,7 +137,7 @@
81 eighty one
EXPLAIN PARTITIONS SELECT * FROM t1 WHERE id = 81;
id select_type table partitions type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 3 const PRIMARY PRIMARY 4 const 1
+1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
SELECT * FROM t1 WHERE id = 7;
id msg
7 seven
@@ -146,19 +146,16 @@
35 thirty five
UPDATE t1 SET msg = 'number' WHERE id in (60,72);
Warnings:
-Note 1105 xt3: 2 affected rows
+Note 1105 xt3: 0 affected rows
Note 1105 xt3: 0 affected rows
UPDATE t1 SET msg = 'soixante' WHERE id = 60;
Warnings:
-Note 1105 xt3: 1 affected rows
+Note 1105 xt3: 0 affected rows
SELECT * FROM t1 WHERE id > 50;
id msg
-60 soixante
-72 number
-81 eighty one
UPDATE t1 SET msg = 'big' WHERE id > 50;
Warnings:
-Note 1105 xt3: 3 affected rows
+Note 1105 xt3: 0 affected rows
UPDATE t1 SET msg = 'sept' WHERE id = 7;
Warnings:
Note 1105 xt1: 1 affected rows
@@ -172,12 +169,12 @@
10 ten
11 eleven
35 thirty five
-72 big
-60 big
-81 big
+72 seventy two
+60 sixty
+81 eighty one
DELETE FROM t1 WHERE id in (60,72);
Warnings:
-Note 1105 xt3: 2 affected rows
+Note 1105 xt3: 0 affected rows
Note 1105 xt3: 0 affected rows
SELECT * FROM t1;
id msg
@@ -189,7 +186,9 @@
10 ten
11 eleven
35 thirty five
-81 big
+72 seventy two
+60 sixty
+81 eighty one
DROP TABLE t1;
DROP TABLE xt1;
DROP TABLE xt2;
mysqltest: Result length mismatch
- saving '/opt/maria-git/server/mysql-test/var/log/connect.part_table/' to '/opt/maria-git/server/mysql-test/var/log/connect.part_table/'
connect.secure_file_priv [ pass ] 8
connect.alter [ fail ]
Test ended at 2015-05-04 03:56:25
CURRENT_TEST: connect.alter
--- /opt/maria-git/server/storage/connect/mysql-test/connect/r/alter.result 2015-04-24 12:36:18.656342908 +0200
+++ /opt/maria-git/server/storage/connect/mysql-test/connect/r/alter.reject 2015-05-04 03:56:25.196342908 +0200
@@ -14,7 +14,7 @@
CREATE INDEX xc ON t1(c);
DESCRIBE SELECT * FROM t1 WHERE c = 2;
id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 ref xc xc 4 const 1
+1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
DROP INDEX xc ON t1;
CREATE INDEX xd ON t1(d);
DROP INDEX xd ON t1;
@@ -147,7 +147,6 @@
t1 1 xd 1 d A NULL NULL NULL XINDEX
SELECT d FROM t1 WHERE c = 2;
d
-Two
ALTER TABLE t1 DROP INDEX xc, DROP INDEX xd;
SHOW INDEX FROM t1;
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
mysqltest: Result length mismatch
- saving '/opt/maria-git/server/mysql-test/var/log/connect.alter/' to '/opt/maria-git/server/mysql-test/var/log/connect.alter/'
connect.alter_xml [ skipped ] Need LIBXML2
connect.bin [ fail ]
Test ended at 2015-05-04 03:56:26
CURRENT_TEST: connect.bin
mysqltest: At line 28: query 'SELECT * FROM t1' failed: 1296: Got error 122 'Value -13042 too long for string of length 5' from CONNECT
The result from queries just before the failure was:
< snip >
Warnings:
Warning 1105 Open(rb) error 2 on DATADIR/test/nonexistent.txt: No such file or directory
DROP TABLE t1;
SET time_zone='+00:00';
CREATE TABLE t1
(
fig INT(4) NOT NULL FIELD_FORMAT='C',
name CHAR(10) not null,
birth DATE NOT NULL,
id CHAR(5) NOT NULL FIELD_FORMAT='S',
salary DOUBLE(9,2) NOT NULL DEFAULT 0.00 FIELD_FORMAT='F',
dept INT(4) NOT NULL FIELD_FORMAT='S'
) ENGINE=CONNECT TABLE_TYPE=BIN BLOCK_SIZE=5 FILE_NAME='Testbal.dat';
SELECT * FROM t1;
More results from queries before failure can be found in /opt/maria-git/server/mysql-test/var/log/bin.log
- saving '/opt/maria-git/server/mysql-test/var/log/connect.bin/' to '/opt/maria-git/server/mysql-test/var/log/connect.bin/'
connect.csv [ pass ] 55
connect.datest [ pass ] 12
connect.dbf [ fail ]
Test ended at 2015-05-04 03:56:27
CURRENT_TEST: connect.dbf
--- /opt/maria-git/server/storage/connect/mysql-test/connect/r/dbf.result 2015-04-24 12:36:18.656342908 +0200
+++ /opt/maria-git/server/storage/connect/mysql-test/connect/r/dbf.reject 2015-05-04 03:56:27.466342908 +0200
@@ -139,9 +139,9 @@
-------- --------
FileSize 77
DBF_Version 03
-NRecords 1
-FirstRecPos 66
-RecLength 11
+NRecords 16777216
+FirstRecPos 16896
+RecLength 2816
TableFlags 0000
CodePageMark 00
--- ---
@@ -173,9 +173,9 @@
-------- --------
FileSize 194
DBF_Version 03
-NRecords 2
-FirstRecPos 130
-RecLength 32
+NRecords 33554432
+FirstRecPos 33280
+RecLength 8192
TableFlags 0000
CodePageMark 00
--- ---
@@ -266,9 +266,9 @@
-------- --------
FileSize 108
DBF_Version 03
-NRecords 2
-FirstRecPos 66
-RecLength 21
+NRecords 33554432
+FirstRecPos 16896
+RecLength 5376
TableFlags 0000
CodePageMark 00
--- ---
@@ -310,9 +310,9 @@
-------- --------
FileSize 80
DBF_Version 03
-NRecords 2
-FirstRecPos 66
-RecLength 7
+NRecords 33554432
+FirstRecPos 16896
+RecLength 1792
TableFlags 0000
CodePageMark 00
--- ---
@@ -340,9 +340,9 @@
-------- --------
FileSize 322
DBF_Version 03
-NRecords 1
-FirstRecPos 66
-RecLength 256
+NRecords 16777216
+FirstRecPos 16896
+RecLength 1
TableFlags 0000
CodePageMark 00
--- ---
@@ -421,9 +421,9 @@
-------- --------
FileSize 75
DBF_Version 03
-NRecords 1
-FirstRecPos 66
-RecLength 9
+NRecords 16777216
+FirstRecPos 16896
+RecLength 2304
TableFlags 0000
CodePageMark 00
--- ---
@@ -451,9 +451,9 @@
-------- --------
FileSize 79
DBF_Version 03
-NRecords 1
-FirstRecPos 66
-RecLength 13
+NRecords 16777216
+FirstRecPos 16896
+RecLength 3328
TableFlags 0000
CodePageMark 00
--- ---
@@ -483,9 +483,9 @@
-------- --------
FileSize 108
DBF_Version 03
-NRecords 2
-FirstRecPos 66
-RecLength 21
+NRecords 33554432
+FirstRecPos 16896
+RecLength 5376
TableFlags 0000
CodePageMark 00
--- ---
@@ -513,9 +513,9 @@
-------- --------
FileSize 77
DBF_Version 03
-NRecords 1
-FirstRecPos 66
-RecLength 11
+NRecords 16777216
+FirstRecPos 16896
+RecLength 2816
TableFlags 0000
CodePageMark 00
--- ---
@@ -540,9 +540,9 @@
-------- --------
FileSize 77
DBF_Version 03
-NRecords 1
-FirstRecPos 66
-RecLength 11
+NRecords 16777216
+FirstRecPos 16896
+RecLength 2816
TableFlags 0000
CodePageMark 00
--- ---
@@ -569,9 +569,9 @@
-------- --------
FileSize 77
DBF_Version 03
-NRecords 1
-FirstRecPos 66
-RecLength 11
+NRecords 16777216
+FirstRecPos 16896
+RecLength 2816
TableFlags 0000
CodePageMark 00
--- ---
@@ -606,9 +606,9 @@
-------- --------
FileSize 291
DBF_Version 03
-NRecords 3
-FirstRecPos 162
-RecLength 43
+NRecords 50331648
+FirstRecPos 41472
+RecLength 11008
TableFlags 0000
CodePageMark 00
--- ---
mysqltest: Result length mismatch
- saving '/opt/maria-git/server/mysql-test/var/log/connect.dbf/' to '/opt/maria-git/server/mysql-test/var/log/connect.dbf/'
connect.dir [ pass ] 12
connect.fix [ pass ] 27
connect.fmt [ pass ] 17
connect.general [ pass ] 6
connect.grant [ pass ] 149
connect.index [ fail ]
Test ended at 2015-05-04 03:56:30
CURRENT_TEST: connect.index
--- /opt/maria-git/server/storage/connect/mysql-test/connect/r/index.result 2015-04-24 12:36:18.656342908 +0200
+++ /opt/maria-git/server/storage/connect/mysql-test/connect/r/index.reject 2015-05-04 03:56:30.456342908 +0200
@@ -57,7 +57,6 @@
#
SELECT * FROM t1 WHERE matricule = '0091';
matricule nom prenom sexe aanais mmnais ddentree ddnom brut net service sitmat formation
-91 THIVERNAL DIDIER JEAN 1 1951 10 1980-05-01 1991-10-01 14715 12024.71 1 M SANS
SELECT * FROM t1 WHERE nom = 'FOCH';
matricule nom prenom sexe aanais mmnais ddentree ddnom brut net service sitmat formation
1977 FOCH BERNADETTE 2 1958 3 1992-02-01 1991-02-01 8656 8145.03 1 . SANS
@@ -66,9 +65,20 @@
2634 FOCH JOCELYNE 2 1953 3 1996-01-01 1995-01-01 12499 10473.09 41 M INFOR
5765 FOCH ROBERT 1 1957 1 1981-03-01 1993-03-01 16081 12916.32 52 M ALLEM
4080 FOCH SERGE 1 1959 3 1981-03-01 1981-05-01 11131 9658.24 5 M SANS
+Warnings:
+Warning 1105 Out of range value for column nom at row 1
+Warning 1105 Out of range value for column nom at row 1
+Warning 1105 Out of range value for column nom at row 1
SELECT * FROM t1 WHERE nom = 'FOCH' and prenom = 'DENIS';
matricule nom prenom sexe aanais mmnais ddentree ddnom brut net service sitmat formation
5707 FOCH DENIS 1 1977 7 1996-07-01 1995-07-01 7803 7679.36 15 C COMPT
+Warnings:
+Warning 1105 Out of range value for column nom at row 1
+Warning 1105 Out of range value for column prenom at row 1
+Warning 1105 Out of range value for column nom at row 1
+Warning 1105 Out of range value for column prenom at row 1
+Warning 1105 Out of range value for column nom at row 1
+Warning 1105 Out of range value for column prenom at row 1
#
# Testing UPDATE
#
@@ -83,6 +93,10 @@
2634 FOCH JOCELYNE 2 1969 3 2012-01-01 2011-01-01 12499 10473.09 41 M INFOR
5765 FOCH ROBERT 1 1973 1 1997-03-01 2009-03-01 16081 12916.32 52 M ALLEM
4080 FOCH SERGE 1 1975 3 1997-03-01 1997-05-01 11131 9658.24 5 M SANS
+Warnings:
+Warning 1105 Out of range value for column nom at row 1
+Warning 1105 Out of range value for column nom at row 1
+Warning 1105 Out of range value for column nom at row 1
#
# Testing JOIN
#
@@ -126,12 +140,10 @@
V Veuf
SELECT nom, prenom, genre, situation FROM t1 NATURAL JOIN t2 NATURAL JOIN t3 WHERE nom = 'FOCH';
nom prenom genre situation
-FOCH BERNADETTE Feminin Inconnu
-FOCH DENIS Masculin Celibataire
-FOCH FRANCK Masculin Marie
-FOCH JOCELYNE Feminin Marie
-FOCH ROBERT Masculin Marie
-FOCH SERGE Masculin Marie
+Warnings:
+Warning 1105 Out of range value for column nom at row 1
+Warning 1105 Out of range value for column nom at row 1
+Warning 1105 Out of range value for column nom at row 1
#
# Testing DELETE
#
mysqltest: Result length mismatch
- saving '/opt/maria-git/server/mysql-test/var/log/connect.index/' to '/opt/maria-git/server/mysql-test/var/log/connect.index/'
connect.ini [ pass ] 54
connect.ini_grant [ pass ] 26
connect.json_udf [ skipped ] Needs a dynamically built ha_connect.so
connect.mrr [ fail ]
Test ended at 2015-05-04 03:56:32
CURRENT_TEST: connect.mrr
--- /opt/maria-git/server/storage/connect/mysql-test/connect/r/mrr.result 2015-04-24 12:36:18.656342908 +0200
+++ /opt/maria-git/server/storage/connect/mysql-test/connect/r/mrr.reject 2015-05-04 03:56:32.066342908 +0200
@@ -76,6 +76,22 @@
2995 ROI JEAN M 11715.50
2531 ROI MICHEL L 10240.44
5846 ROI PATRICIA M 15669.57
+Warnings:
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom at row 448
+Warning 1105 Out of range value for column nom at row 4008
+Warning 1105 Out of range value for column nom at row 597
+Warning 1105 Out of range value for column nom at row 2634
#
# Testing indexing with MRR ON
#
@@ -111,6 +127,22 @@
5846 ROI PATRICIA M 15669.57
2492 ETANG PASCAL VINCENT M 11986.62
5765 FOCH ROBERT M 12916.32
+Warnings:
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom
+Warning 1105 Out of range value for column nom at row 448
+Warning 1105 Out of range value for column nom at row 4008
+Warning 1105 Out of range value for column nom at row 597
+Warning 1105 Out of range value for column nom at row 2634
DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
mysqltest: Result length mismatch
- saving '/opt/maria-git/server/mysql-test/var/log/connect.mrr/' to '/opt/maria-git/server/mysql-test/var/log/connect.mrr/'
connect.mul [ pass ] 18
connect.mysql [ pass ] 276
connect.mysql_discovery [ pass ] 34
connect.mysql_exec [ pass ] 29
connect.mysql_grant [ pass ] 21
connect.mysql_new [ pass ] 84
connect.null [ pass ] 25
connect.occur [ pass ] 48
connect.odbc [ skipped ] No ODBC support
connect.odbc_oracle [ skipped ] No ODBC support
connect.odbc_postgresql [ skipped ] No ODBC support
connect.odbc_sqlite3 [ skipped ] No ODBC support
connect.odbc_sqlite3_grant [ skipped ] No ODBC support
connect.odbc_xls [ skipped ] No ODBC support
connect.pivot [ pass ] 65
connect.tbl [ pass ] 50
connect.temporary [ pass ] 1
connect.unsigned [ pass ] 16
connect.upd [ pass ] 333
connect.updelx [ fail ]
Test ended at 2015-05-04 03:56:39
CURRENT_TEST: connect.updelx
mysqltest: In included file "/opt/maria-git/server/storage/connect/mysql-test/connect/t/updelx.inc":
included from /opt/maria-git/server/storage/connect/mysql-test/connect/t/updelx.test at line 46:
At line 4: query 'UPDATE t1 SET msg = 'bof' WHERE id = 35' failed: 1296: Got error 122 'Error reading Index file: Resource temporarily unavailable' from CONNECT
The result from queries just before the failure was:
< snip >
1 one
35 thirty five
8 eight
ALTER TABLE t1 MAPPED=NO HUGE=YES;
DELETE FROM t1;
INSERT INTO t1 VALUES(4, 'four'),(7,'seven'),(10,'ten'),(40,'forty'),(60,'sixty'),(81,'eighty one'),(72,'seventy two'),(11,'eleven'),(1,'one'),(35,'thirty five'),(8,'eight');
SELECT * FROM t1;
id msg
4 four
7 seven
10 ten
40 forty
60 sixty
81 eighty one
72 seventy two
11 eleven
1 one
35 thirty five
8 eight
UPDATE t1 SET msg = 'bof' WHERE id = 35;
More results from queries before failure can be found in /opt/maria-git/server/mysql-test/var/log/updelx.log
- saving '/opt/maria-git/server/mysql-test/var/log/connect.updelx/' to '/opt/maria-git/server/mysql-test/var/log/connect.updelx/'
connect.updelx2 [ fail ]
Test ended at 2015-05-04 03:56:39
CURRENT_TEST: connect.updelx2
--- /opt/maria-git/server/storage/connect/mysql-test/connect/r/updelx2.result 2015-04-24 12:36:18.656342908 +0200
+++ /opt/maria-git/server/storage/connect/mysql-test/connect/r/updelx2.reject 2015-05-04 03:56:39.536342908 +0200
@@ -41,7 +41,7 @@
4 four
7 seven
8 eight
-10 dieci
+10 ten
11 eleven
40 forty
35 thirty five
@@ -52,7 +52,7 @@
4 quatre
7 sept
8 huit
-10 dieci
+10 dix
11 onze
40 quarante
35 trente cinq
@@ -66,48 +66,51 @@
4 four
7 seven
8 eight
-10 dieci
+10 ten
11 eleven
40 forty
35 thirty five
60 sixty
-72 septante deux
+72 seventy two
81 eighty one
1 un
4 quatre
7 sept
8 huit
-10 dieci
+10 dix
11 onze
40 quarante
35 trente cinq
60 soixante
-72 septante deux
+72 soixante douze
81 quatrevingt un
UPDATE t1 SET id=2, msg='deux' WHERE id=4 AND msg='quatre';
+Warnings:
+Warning 1105 Out of range value for column msg
+Warning 1105 Out of range value for column msg
SELECT * FROM t1 IGNORE INDEX (IDM);
id msg
1 one
4 four
7 seven
8 eight
-10 dieci
+10 ten
11 eleven
40 forty
35 thirty five
60 sixty
-72 septante deux
+72 seventy two
81 eighty one
1 un
-2 deux
+4 quatre
7 sept
8 huit
-10 dieci
+10 dix
11 onze
40 quarante
35 trente cinq
60 soixante
-72 septante deux
+72 soixante douze
81 quatrevingt un
DELETE FROM t1 WHERE id IN (8,40);
SELECT * FROM t1 IGNORE INDEX (IDM);
@@ -115,19 +118,23 @@
1 one
4 four
7 seven
-10 dieci
+8 eight
+10 ten
11 eleven
+40 forty
35 thirty five
60 sixty
-72 septante deux
+72 seventy two
81 eighty one
1 un
-2 deux
+4 quatre
7 sept
-10 dieci
+8 huit
+10 dix
11 onze
+40 quarante
35 trente cinq
60 soixante
-72 septante deux
+72 soixante douze
81 quatrevingt un
DROP TABLE t1;
mysqltest: Result length mismatch
- saving '/opt/maria-git/server/mysql-test/var/log/connect.updelx2/' to '/opt/maria-git/server/mysql-test/var/log/connect.updelx2/'
connect.vec [ pass ] 29
connect.xcol [ pass ] 17
connect.xml [ skipped ] Need LIBXML2
connect.xml_grant [ skipped ] Need LIBXML2
connect.xml_mdev5261 [ skipped ] Need LIBXML2
connect.xml_mult [ skipped ] Need LIBXML2
--------------------------------------------------------------------------
The servers were restarted 10 times
Spent 1.499 of 25 seconds executing testcases
Completed: Failed 9/35 tests, 74.29% were successful.
Failing test(s): connect.part_file connect.part_table connect.alter connect.bin connect.dbf connect.index connect.mrr connect.updelx connect.updelx2
The log files in var/log may give you some hint of what went wrong.
If you want to report this error, please read first the documentation
at http://dev.mysql.com/doc/mysql/en/mysql-test-suite.html
12 tests were skipped, 12 by the test itself.
mysql-test-run: *** ERROR: there were failing test cases
