main.func_isnull                         [ fail ]

        Test ended at 2014-11-21 17:41:53

CURRENT_TEST: main.func_isnull

mysqltest: At line 24: query 'SELECT ISNULL((SELECT GET_LOCK('Bug#53933', 0) FROM t1 GROUP BY f1)) AS f2

FROM t1 GROUP BY f1 HAVING f2 = f2' failed: 2013: Lost connection to MySQL server during query

The result from queries just before the failure was:

drop table if exists t1;

create table t1 (id int auto_increment primary key not null, mydate date not null);

insert into t1 values (0,"2002-05-01"),(0,"2002-05-01"),(0,"2002-05-01");

flush tables;

select * from t1 where isnull(to_days(mydate));

id	mydate

drop table t1;

#

# Bug#53933 crash when using uncacheable subquery in the having clause of outer query

#

CREATE TABLE t1 (f1 INT);

INSERT INTO t1 VALUES (0),(0);

SELECT ISNULL((SELECT GET_LOCK('Bug#53933', 0) FROM t1 GROUP BY f1)) AS f2

FROM t1 GROUP BY f1 HAVING f2 = f2;

Server [mysqld.1 - pid: 270144, winpid: 270144, exit: 768] failed during test run

Server log from this test:

----------SERVER LOG START-----------

----------SERVER LOG END-------------