LP:715062 - Wrong result with VIEW + UNION + subquery in maria-5.3-mwl89

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