[MDEV-3139] LP:715062 - Wrong result with VIEW + UNION + subquery in maria-5.3-mwl89 Created: 2011-02-08  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: Timour Katchaounov (Inactive)
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug715062.xml    

 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

 Comments   
Comment by Timour Katchaounov (Inactive) [ 2011-04-04 ]

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

  • 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.
Comment by Rasmus Johansson (Inactive) [ 2011-12-13 ]

Launchpad bug id: 715062

Generated at Thu Feb 08 06:46:35 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.