[MDEV-3689] LP:685952 - Wrong result with "union" in maria-5.3-wl21 Created: 2010-12-06 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: | Major |
| Reporter: | Philip Stoev (Inactive) | Assignee: | Igor Babaev |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Launchpad | ||
| Attachments: |
|
| Description |
|
The following query: SELECT * FROM t1 FORCE KEY (PRIMARY,f3,f4) returns no rows when executed with "union" in maria-5.1-wl21 and 1 row when executed with other optimizations and other trees. In 5.1 , the "union" optimization is not used. test case: CREATE TABLE t1 (f1 int,f2 int,f3 int,f4 int, SET SESSION optimizer_switch='index_merge_intersection=off,index_merge_sort_intersection=off'; SELECT * FROM t1 FORCE KEY (PRIMARY,f3,f4) explain: id: 1 |
| Comments |
| Comment by Igor Babaev [ 2010-12-06 ] |
|
Re: Wrong result with "union" in maria-5.3-wl21 |
| Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ] |
|
Launchpad bug id: 685952 |