Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
Using unions inside views inside subqueries causes non-matching rows to be returned in maria-5.3-mwl89. Not repeatable in maria-5.3.
SET SESSION optimizer_switch = 'in_to_exists=on,semijoin=off,materialization=on';
CREATE VIEW v1 AS SELECT 2 UNION SELECT 2 ;
SELECT 'bug' FROM DUAL WHERE ( 5 ) IN ( SELECT * FROM v1 ) ;
In this case, the IN predicate in the WHERE is obviously FALSE, however the 'bug' row is still returned.
bzr version-info:
revision-id: <email address hidden>
date: 2011-02-03 17:00:28 +0200
build-date: 2011-02-08 10:55:54 +0200
revno: 2883
branch-nick: maria-5.3-mwl89
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Launchpad bug id: 715062
Re: Wrong result with VIEW + UNION + subquery in maria-5.3-mwl89
Pushed only the test case. Not repeatable in the latest 5.3-mwl89:
revno: 2962 [merge]
committer: timour@askmonty.org
branch nick: 5.3-mwl89
timestamp: Fri 2011-04-01 15:42:59 +0300
message:
MWL#89
an two more queries were added, and removed a
query that produces a wrong result due to an
unrelated problem. The wrong result is submitted
as a separate bug.