diff options
| author | Alexey Kopytov <Alexey.Kopytov@Sun.com> | 2009-11-23 13:04:17 +0300 |
|---|---|---|
| committer | Alexey Kopytov <Alexey.Kopytov@Sun.com> | 2009-11-23 13:04:17 +0300 |
| commit | 38ed9324bec38b846d285071e361959a0003e26f (patch) | |
| tree | 11b0131c5336fdd1eb8ee281f64692ec5d227ac1 /mysql-test/r/group_min_max.result | |
| parent | 25b7b377f218f1ded7d4b3b67c71afd6fb20460d (diff) | |
| parent | 8cfa50e6771f1dbd6f265be44d9340a7d53084c2 (diff) | |
| download | mariadb-git-38ed9324bec38b846d285071e361959a0003e26f.tar.gz | |
Automerge.
Diffstat (limited to 'mysql-test/r/group_min_max.result')
| -rw-r--r-- | mysql-test/r/group_min_max.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/group_min_max.result b/mysql-test/r/group_min_max.result index 620f5dc19ec..662cc5be034 100644 --- a/mysql-test/r/group_min_max.result +++ b/mysql-test/r/group_min_max.result @@ -2501,6 +2501,17 @@ SELECT a, MAX(b) FROM t WHERE b > 0 AND b < 2 GROUP BY a; a MAX(b) 2 1 DROP TABLE t; +# +# Bug #48472: Loose index scan inappropriately chosen for some WHERE +# conditions +# +CREATE TABLE t (a INT, b INT, INDEX (a,b)); +INSERT INTO t VALUES (2,0), (2,0), (2,1), (2,1); +INSERT INTO t SELECT * FROM t; +SELECT a, MAX(b) FROM t WHERE 0=b+0 GROUP BY a; +a MAX(b) +2 0 +DROP TABLE t; End of 5.0 tests # # Bug #46607: Assertion failed: (cond_type == Item::FUNC_ITEM) results in |