Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
10.0(EOL)
-
None
Description
Timeouts – happened a few times in April, logs not available:
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;
|
Attachments
Issue Links
- relates to
-
MDEV-7069 Fix buildbot failures in main server trees
- Stalled