531
531
DROP TABLE t1,t2;
534
# Bug#54416 MAX from JOIN with HAVING returning NULL with 5.1 and Empty set
536
CREATE TABLE t1 (f1 INT(11), f2 VARCHAR(1), PRIMARY KEY (f1));
537
INSERT INTO t1 VALUES (1,'f');
538
CREATE TABLE t2 (f1 INT(11), f2 VARCHAR(1));
539
INSERT INTO t2 VALUES (2,'m');
540
INSERT INTO t2 VALUES (3,'m');
541
INSERT INTO t2 VALUES (11,NULL);
542
INSERT INTO t2 VALUES (12,'k');
543
SELECT MAX(t1.f1) field1
544
FROM t1 JOIN t2 ON t2.f2 LIKE 'x'