404
# A nested materialized derived table is used before being populated.
405
# (addon for bug#19077)
407
CREATE TABLE t1 (i INT, j BIGINT);
408
INSERT INTO t1 VALUES (1, 2), (2, 2), (3, 2);
409
SELECT * FROM (SELECT MIN(i) FROM t1
410
WHERE j = SUBSTRING('12', (SELECT * FROM (SELECT MIN(j) FROM t1) t2))) t3;
403
414
# End of 5.0 tests