main.subselect, main.subselect_no_exists_to_in, main.subselect_no_mat, main.subselect_no_opts failed in buildbot

main.subselect                           w5 [ fail ]  timeout after 9000 seconds

        Test ended at 2016-04-26 22:55:19

Test case timeout after 9000 seconds

== /mnt/data/buildot/maria-slave/work-opensuse-amd64/build/mysql-test/var/5/log/subselect.log == 

set optimizer_switch = 'subquery_cache=off';

SELECT * FROM t1 WHERE ( 3, 3 ) NOT IN ( SELECT NULL, NULL ) OR a > 100;

a

SELECT *, ( 3, 3 ) NOT IN ( SELECT NULL, NULL ) FROM t1;

a	( 3, 3 ) NOT IN ( SELECT NULL, NULL )

1	NULL

2	NULL

3	NULL

set optimizer_switch=@mdev367_optimizer_switch;

DROP TABLE t1;

#

# MDEV-521 single value subselect transformation problem

#

CREATE TABLE t1 (f1 char(2), PRIMARY KEY (f1)) ENGINE=MyISAM;

INSERT INTO t1 VALUES ('u1'),('u2');

SELECT a.* FROM t1 a WHERE ( SELECT EXISTS ( SELECT 1 FROM t1 b WHERE b.f1 = a.f1 ) );

f1

u1

u2

FLUSH TABLES;

main.subselect                           w2 [ fail ]  timeout after 900 seconds

        Test ended at 2016-04-26 13:09:12

Test case timeout after 900 seconds

== /usr/local/mariadb-10.0.24-linux-i686/mysql-test/var/2/log/subselect.log == 

set optimizer_switch = 'subquery_cache=off';

SELECT * FROM t1 WHERE ( 3, 3 ) NOT IN ( SELECT NULL, NULL ) OR a > 100;

a

SELECT *, ( 3, 3 ) NOT IN ( SELECT NULL, NULL ) FROM t1;

a	( 3, 3 ) NOT IN ( SELECT NULL, NULL )

1	NULL

2	NULL

3	NULL

set optimizer_switch=@mdev367_optimizer_switch;

DROP TABLE t1;

#

# MDEV-521 single value subselect transformation problem

#

CREATE TABLE t1 (f1 char(2), PRIMARY KEY (f1)) ENGINE=MyISAM;

INSERT INTO t1 VALUES ('u1'),('u2');

SELECT a.* FROM t1 a WHERE ( SELECT EXISTS ( SELECT 1 FROM t1 b WHERE b.f1 = a.f1 ) );

f1

u1

u2

FLUSH TABLES;