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 | eaf20c303f222f9ab40fbdc5608a31266757eb5f (patch) | |
| tree | 11b0131c5336fdd1eb8ee281f64692ec5d227ac1 /mysql-test/t/group_min_max.test | |
| parent | 9ea972dc47fa582e23c1578bc0de16ac75999ae1 (diff) | |
| parent | 7f2ba28ef9981944fdd886e86ce5b02b0b549ec0 (diff) | |
| download | mariadb-git-eaf20c303f222f9ab40fbdc5608a31266757eb5f.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 |