diff options
| author | Igor Babaev <igor@askmonty.org> | 2011-10-30 04:18:09 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2011-10-30 04:18:09 -0700 |
| commit | e5627c9802460c745814961e721191ff4b6c91b3 (patch) | |
| tree | 205d64db03ee227472804d32542d295a7e69c85f /mysql-test/r/myisam_icp.result | |
| parent | c118219f38e9685fe1145bc7050f6e07d620ac01 (diff) | |
| download | mariadb-git-e5627c9802460c745814961e721191ff4b6c91b3.tar.gz | |
Backported the test case for bug 58838 from mysql-5.6 code line.
The bug was fixed by the patches for LP bugs 668644,702322 that
were applied earlier to the mariadb-5.3 code.
Diffstat (limited to 'mysql-test/r/myisam_icp.result')
| -rw-r--r-- | mysql-test/r/myisam_icp.result | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/mysql-test/r/myisam_icp.result b/mysql-test/r/myisam_icp.result index a029df60d18..7ab3337572a 100644 --- a/mysql-test/r/myisam_icp.result +++ b/mysql-test/r/myisam_icp.result @@ -518,6 +518,30 @@ WHERE (t2.pk <= 4 AND t1.pk IN (2,1)) OR c2 DROP TABLE t1, t2; # +# Bug#58838: "Wrong results with HAVING + LIMIT without GROUP BY when +# ICP is enabled". +# (Fixed by the patches for LP bugs #668644, #702322) +# +CREATE TABLE t1 ( +pk INT NOT NULL, +c1 INT, +PRIMARY KEY (pk), +KEY col_int_key (c1) +); +INSERT INTO t1 VALUES (1,37),(2,8),(3,-25),(4,NULL),(5,55); +SELECT pk FROM t1 WHERE c1 <> 1 HAVING pk = 3 ORDER BY pk LIMIT 0; +pk +SELECT pk FROM t1 WHERE c1 <> 1 HAVING pk = 3 ORDER BY pk LIMIT 1; +pk +3 +SELECT pk FROM t1 WHERE c1 <> 1 HAVING pk = 3 ORDER BY pk LIMIT 2; +pk +3 +SELECT pk FROM t1 WHERE c1 <> 1 HAVING pk = 3 ORDER BY pk LIMIT 5; +pk +3 +DROP TABLE t1; +# # BUG#778434 Wrong result with in_to_exists=on in maria-5.3-mwl89 # CREATE TABLE t1 ( f11 int) ; |