565
565
DROP TABLE t1,t2;
568
--echo # Bug#48916 Server incorrectly processing HAVING clauses with an ORDER BY clause
571
CREATE TABLE t1 (f1 INT, f2 INT);
572
INSERT INTO t1 VALUES (1, 0), (2, 1), (3, 2);
573
CREATE TABLE t2 (f1 INT, f2 INT);
577
HAVING (3, 2) IN (SELECT f1, f2 FROM t2) AND t1.f1 >= 0
582
HAVING (3, 2) IN (SELECT 4, 2) AND t1.f1 >= 0
587
HAVING 2 IN (SELECT f2 FROM t2) AND t1.f1 >= 0
567
593
--echo End of 5.1 tests