[#MDEV-20168] main.innodb_icp fails in buildbot with various wrong execution plans

10.4 819c40d694071e56adb62ded97561717
main.innodb_icp 'innodb' w3 [ fail ]
Test ended at 2019-07-22 18:31:40

CURRENT_TEST: main.innodb_icp
--- /usr/local/mariadb-10.4.7-linux-i686/mysql-test/main/innodb_icp.result 2019-07-22 16:40:50.000000000 +0300
+++ /usr/local/mariadb-10.4.7-linux-i686/mysql-test/main/innodb_icp.reject 2019-07-22 18:31:40.171876075 +0300
@@ -172,7 +172,7 @@
ORDER BY ts DESC
LIMIT 2;
id select_type table type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 range PRIMARY PRIMARY 4 NULL 4 Using where
+1 SIMPLE t1 index PRIMARY PRIMARY 4 NULL 2 Using where

DROP TABLE t1;
#

mysqltest: Result content mismatch

10.4 f5390eea9a9fa307876c4f78cd876edb
main.innodb_icp 'innodb' w3 [ fail ]
Test ended at 2019-07-17 12:21:49

CURRENT_TEST: main.innodb_icp
Warning: /mnt/buildbot/build/mariadb-10.4.7/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-ca=/mnt/buildbot/build/mariadb-10.4.7/mysql-test/std_data/cacert.pem'
Warning: /mnt/buildbot/build/mariadb-10.4.7/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-cert=/mnt/buildbot/build/mariadb-10.4.7/mysql-test/std_data/client-cert.pem'
Warning: /mnt/buildbot/build/mariadb-10.4.7/libmysqld/examples/mysqltest_embedded: unknown variable 'loose-ssl-key=/mnt/buildbot/build/mariadb-10.4.7/mysql-test/std_data/client-key.pem'
Warning: /mnt/buildbot/build/mariadb-10.4.7/libmysqld/examples/mysqltest_embedded: unknown option '--loose-skip-ssl'
--- /mnt/buildbot/build/mariadb-10.4.7/mysql-test/main/innodb_icp.result 2019-07-17 07:03:53.000000000 -0400
+++ /mnt/buildbot/build/mariadb-10.4.7/mysql-test/main/innodb_icp.reject 2019-07-17 12:21:48.789562771 -0400
@@ -437,7 +437,7 @@
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY t1 ALL NULL NULL NULL NULL 3 Using where
2 DEPENDENT SUBQUERY it eq_ref PRIMARY PRIMARY 4 func 1 Using where
-2 DEPENDENT SUBQUERY t2 index NULL PRIMARY 4 NULL 3 Using index; Using join buffer (flat, BNL join)
+2 DEPENDENT SUBQUERY t2 index NULL PRIMARY 4 NULL 4 Using index; Using join buffer (flat, BNL join)
SELECT * FROM t1
WHERE pk IN (SELECT it.pk FROM t2 JOIN t2 AS it ON it.i=it.i WHERE it.pk-t1.i<10);
pk i

mysqltest: Result content mismatch

CURRENT_TEST: main.innodb_icp

--- /usr/local/mariadb-10.4.8-linux-i686/mysql-test/main/innodb_icp.result	2019-09-04 01:36:56.000000000 -0400

+++ /usr/local/mariadb-10.4.8-linux-i686/mysql-test/main/innodb_icp.reject	2019-09-04 03:08:50.771793071 -0400

@@ -690,8 +690,8 @@

 SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0

 HAVING t1.c != 5 ORDER BY t1.c;

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

-1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using filesort

-1	SIMPLE	t2	ref	a	a	515	test.t1.a	1	Using where

+1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using temporary; Using filesort

+1	SIMPLE	t2	ALL	a	NULL	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

 SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0

 HAVING t1.c != 5 ORDER BY t1.c;

b	c

@@ -701,8 +701,8 @@

 SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0

 HAVING t1.c != 5 ORDER BY t1.c;

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

-1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using filesort

-1	SIMPLE	t2	ref	a	a	515	test.t1.a	1	Using where

+1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using temporary; Using filesort

+1	SIMPLE	t2	ALL	a	NULL	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

 SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0

 HAVING t1.c != 5 ORDER BY t1.c;

b	c

mysqltest: Result length mismatch

main.innodb_icp 'innodb'                 w1 [ fail ]

        Test ended at 2020-10-22 05:40:32

CURRENT_TEST: main.innodb_icp

--- /usr/share/mysql-test/main/innodb_icp.result	2020-10-22 03:18:04.000000000 +0000

+++ /dev/shm/var/1/log/innodb_icp.reject	2020-10-22 05:40:32.615373193 +0000

@@ -690,8 +690,8 @@

 SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0

 HAVING t1.c != 5 ORDER BY t1.c;

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

-1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using filesort

-1	SIMPLE	t2	ref	a	a	515	test.t1.a	1	Using where

+1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using temporary; Using filesort

+1	SIMPLE	t2	ALL	a	NULL	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

 SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0

 HAVING t1.c != 5 ORDER BY t1.c;

b	c

@@ -701,8 +701,8 @@

 SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0

 HAVING t1.c != 5 ORDER BY t1.c;

 id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra

-1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using filesort

-1	SIMPLE	t2	ref	a	a	515	test.t1.a	1	Using where

+1	SIMPLE	t1	range	PRIMARY	PRIMARY	4	NULL	1	Using where; Using temporary; Using filesort

+1	SIMPLE	t2	ALL	a	NULL	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

 SELECT t1.b, t1.c FROM t1, t2 WHERE t1.a = t2.a AND t1.b != 0

 HAVING t1.c != 5 ORDER BY t1.c;

b	c

mysqltest: Result length mismatch

[MDEV-20168] main.innodb_icp fails in buildbot with various wrong execution plans Created: 2019-07-24 Updated: 2023-10-11 Resolved: 2023-10-04
Status:	Closed
Project:	MariaDB Server
Component/s:	Tests
Affects Version/s:	10.4, 10.5
Fix Version/s:	10.4.32, 10.5.23, 10.6.16, 10.10.7, 10.11.6, 11.0.4, 11.1.3, 11.2.2

[MDEV-20168] main.innodb_icp fails in buildbot with various wrong execution plans Created: 2019-07-24 Updated: 2023-10-11 Resolved: 2023-10-04