1791
1791
DROP TABLE t1, t2;
1793
# Bug#52051: Aggregate functions incorrectly returns NULL from outer
1796
CREATE TABLE t1 (a INT PRIMARY KEY);
1797
CREATE TABLE t2 (a INT PRIMARY KEY);
1798
INSERT INTO t2 VALUES (1), (2);
1799
EXPLAIN SELECT MIN(t2.a) FROM t2 LEFT JOIN t1 ON t2.a = t1.a;
1800
id select_type table type possible_keys key key_len ref rows Extra
1801
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Select tables optimized away
1802
SELECT MIN(t2.a) FROM t2 LEFT JOIN t1 ON t2.a = t1.a;
1805
EXPLAIN SELECT MAX(t2.a) FROM t2 LEFT JOIN t1 ON t2.a = t1.a;
1806
id select_type table type possible_keys key key_len ref rows Extra
1807
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL Select tables optimized away
1808
SELECT MAX(t2.a) FROM t2 LEFT JOIN t1 ON t2.a = t1.a;
1793
1813
# End of 5.1 tests