[MDEV-3319] LP:752992 - Wrong results for a subquery with 'semijoin=on' Created: 2011-04-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: | Critical |
| Reporter: | Igor Babaev | Assignee: | Sergei Petrunia |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | Launchpad | ||
| Attachments: |
|
| Description |
|
Create and populate tables t1 and t2 with the following commands: CREATE TABLE t1 (pk INTEGER PRIMARY KEY, i INTEGER NOT NULL); The subquery returns wrong results with the setting MariaDB [test]> set optimizer_switch='semijoin=on'; MariaDB [test]> SELECT * FROM t1
---
--- With the setting: MariaDB [test]> set optimizer_switch='semijoin=off'; MariaDB [test]> SELECT * FROM t1
---
--- The bug is reproducible on both 5.3 tree and 5.3-subqueries-mwl90 |
| Comments |
| Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ] |
|
Launchpad bug id: 752992 |