diff options
| author | Igor Babaev <igor@askmonty.org> | 2013-09-15 12:38:22 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2013-09-15 12:38:22 -0700 |
| commit | 996f6194c69b556e37a143a6a175e60a9f57ab47 (patch) | |
| tree | c7a5f792b386bf119c2c2d6074916456f9b16f18 /mysql-test/r/func_group.result | |
| parent | cf9cc19e910f3621661de6a9384a18aacf84a8dd (diff) | |
| download | mariadb-git-996f6194c69b556e37a143a6a175e60a9f57ab47.tar.gz | |
Fixed bug mdev-5015.
The patch for mdev-4355 had a defect: the cached values for bitmaps of
used tables were not updated when processing degenerate OR formulas.
Diffstat (limited to 'mysql-test/r/func_group.result')
| -rw-r--r-- | mysql-test/r/func_group.result | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/r/func_group.result b/mysql-test/r/func_group.result index 5fa37f577e9..ebb379dfd7e 100644 --- a/mysql-test/r/func_group.result +++ b/mysql-test/r/func_group.result @@ -2124,4 +2124,17 @@ select z from (select count(*) as z from t1) v group by 1; z 4 drop table t1; +CREATE TABLE t1 (i1 int, INDEX(i1)); +INSERT INTO t1 VALUES (9),(8); +CREATE TABLE t2 (i2 int); +INSERT INTO t2 VALUES (8),(4); +CREATE TABLE t3 (i3 int, INDEX(i3)); +INSERT INTO t3 VALUES (9),(8); +SELECT MAX(t3.i3) FROM t3, t2, t1 WHERE t1.i1 = t2.i2 AND ( 0 OR t3.i3 = t2.i2 ); +MAX(t3.i3) +8 +SELECT MAX(t3.i3) FROM t3, t2, t1 WHERE t1.i1 = t2.i2 AND t3.i3 = t2.i2; +MAX(t3.i3) +8 +DROP TABLE t1,t2,t3; # end of 5.3 tests |