[MDEV-2920] LP:674423 - More rows returned with outer_join_with_cache=on and join_cache_level=6 in maria-5.3-mwl128 Created: 2010-11-12 Updated: 2015-02-02 Resolved: 2012-10-04 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Critical |
| Reporter: | Philip Stoev (Inactive) | Assignee: | Igor Babaev |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Launchpad | ||
| Attachments: |
|
| Description |
|
The following query SELECT t2.f7 FROM t2 LEFT JOIN t1 ON t2.f7 WHERE t1.f7 OR t2.pk < 9; returns one extra NULL as compared to plan without a join buffer. explain: mysql> EXPLAIN SELECT t2.f7 FROM t2 LEFT JOIN t1 ON t2.f7 WHERE t1.f7 OR t2.pk < 9\G
Test case: DROP TABLE IF EXISTS t1; DROP TABLE IF EXISTS t2; SET optimizer_switch='outer_join_with_cache=on'; SET SESSION join_cache_level = 0; |
| Comments |
| Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ] |
|
Launchpad bug id: 674423 |