LP:843857 - Wrong result with views + specific join order

The following query:

SELECT STRAIGHT_JOIN *
FROM view_H
RIGHT JOIN ( view_DD LEFT JOIN BB ON view_DD.b = BB.a )
ON view_H.a = view_DD.c
WHERE view_H.b <> 102;

produces the following plan:

and the following wrong result:

-----------------------------+

all other plans produce the following result:

-----------------------------+

repeatable in maria-5.3. not repeatable in maria-5.2, mysql-5.5.

revision-id: <email address hidden>
date: 2011-09-06 20:59:29 +0400
build-date: 2011-09-07 15:56:33 +0300
revno: 3178
branch-nick: maria-5.3

switches:

--join_cache_level=8
--optimizer_switch=join_cache_incremental=ON,join_cache_bka=OFF,join_cache_hashed=OFF

test case:

CREATE TABLE t1 ( a varchar(32)) ;
INSERT INTO t1 VALUES ('know'),('j');

CREATE TABLE t2 ( b int, a int) ;
INSERT INTO t2 VALUES ('-312147968','but');

CREATE TABLE t3 ( a int NOT NULL , b varchar(32), c int) ;
INSERT INTO t3 VALUES (7,'t2',0);

CREATE OR REPLACE VIEW v2 AS SELECT * FROM t2;
CREATE OR REPLACE VIEW v3 AS SELECT * FROM t3;

SELECT STRAIGHT_JOIN *
FROM v2
RIGHT JOIN ( v3 LEFT JOIN t1 ON v3.b = t1.a )
ON v2.a = v3.c
WHERE v2.b <> 102;