Wrong result with VIEW + UNION + subquery in maria-5.3-mwl89
Bug #715062 reported by
Philip Stoev
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
High
|
Timour Katchaounov |
Bug 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_
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
Related branches
lp:~maria-captains/maria/5.3-mwl89
(Merged)
Changed in maria: | |
milestone: | none → 5.3 |
assignee: | nobody → Timour Katchaounov (timour) |
Changed in maria: | |
status: | New → Confirmed |
importance: | Undecided → High |
Changed in maria: | |
status: | Confirmed → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Pushed only the test case. Not repeatable in the latest 5.3-mwl89:
revno: 2962 [merge]
committer: <email address hidden>
branch nick: 5.3-mwl89
timestamp: Fri 2011-04-01 15:42:59 +0300
message:
MWL#89
- Auto-merge with 5.3 main.
- Changed the test for LP BUG#719198 so that
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.