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/t/group_min_max.test | |
| parent | 25b7b377f218f1ded7d4b3b67c71afd6fb20460d (diff) | |
| parent | 8cfa50e6771f1dbd6f265be44d9340a7d53084c2 (diff) | |
| download | mariadb-git-38ed9324bec38b846d285071e361959a0003e26f.tar.gz | |
Automerge.
Diffstat (limited to 'mysql-test/t/group_min_max.test')
| -rw-r--r-- | mysql-test/t/group_min_max.test | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/group_min_max.test b/mysql-test/t/group_min_max.test index c09a4fbf490..f623df372fa 100644 --- a/mysql-test/t/group_min_max.test +++ b/mysql-test/t/group_min_max.test @@ -1016,6 +1016,18 @@ SELECT a, MAX(b) FROM t WHERE b > 0 AND b < 2 GROUP BY a; DROP TABLE t; +--echo # +--echo # Bug #48472: Loose index scan inappropriately chosen for some WHERE +--echo # conditions +--echo # + +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; + +DROP TABLE t; --echo End of 5.0 tests |