diff options
| author | Sergey Glukhov <sergey.glukhov@oracle.com> | 2011-04-22 11:39:42 +0400 |
|---|---|---|
| committer | Sergey Glukhov <sergey.glukhov@oracle.com> | 2011-04-22 11:39:42 +0400 |
| commit | 1930168448ffa7941aebf2db30a0bb0160eca3f8 (patch) | |
| tree | 5acaa46f4012655873993a3e5f3b456283ba9ff8 /mysql-test/r/having.result | |
| parent | 923db5a282d52e6718ba4a096ac0f73cca809f51 (diff) | |
| parent | a5e8d9029b1340762bc88226c0a9344f241a044c (diff) | |
| download | mariadb-git-1930168448ffa7941aebf2db30a0bb0160eca3f8.tar.gz | |
5.1 -> 5.5 merge
Diffstat (limited to 'mysql-test/r/having.result')
| -rw-r--r-- | mysql-test/r/having.result | 22 |
1 files changed, 22 insertions, 0 deletions
diff --git a/mysql-test/r/having.result b/mysql-test/r/having.result index daf043860a4..1bbdd5011c4 100644 --- a/mysql-test/r/having.result +++ b/mysql-test/r/having.result @@ -547,4 +547,26 @@ FROM t1 JOIN t2 ON t2.f2 LIKE 'x' HAVING field1 < 7; field1 DROP TABLE t1,t2; +# +# Bug#48916 Server incorrectly processing HAVING clauses with an ORDER BY clause +# +CREATE TABLE t1 (f1 INT, f2 INT); +INSERT INTO t1 VALUES (1, 0), (2, 1), (3, 2); +CREATE TABLE t2 (f1 INT, f2 INT); +SELECT t1.f1 +FROM t1 +HAVING (3, 2) IN (SELECT f1, f2 FROM t2) AND t1.f1 >= 0 +ORDER BY t1.f1; +f1 +SELECT t1.f1 +FROM t1 +HAVING (3, 2) IN (SELECT 4, 2) AND t1.f1 >= 0 +ORDER BY t1.f1; +f1 +SELECT t1.f1 +FROM t1 +HAVING 2 IN (SELECT f2 FROM t2) AND t1.f1 >= 0 +ORDER BY t1.f1; +f1 +DROP TABLE t1,t2; End of 5.1 tests |