Wrong result from view containing outer reference in simijoin subquery
Bug #784281 reported by
Igor Babaev
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Critical
|
Igor Babaev |
Bug Description
A wrong result is returned by the query below for the test case of bug #33389 from mysql-test/
To reproduce the problem first execute the following statements:
create table t1 (a int, key(a));
create table t2 (c int);
create view v1 as select a b from t1;
create view v2 as select 1 a from t2, v1 where c in
insert into t1 values (1), (1);
insert into t2 values (1), (1);
Then run the query
select * from v2.
You'll get:
MariaDB [test]> select * from v2;
Empty set (0.00 sec)
The expected result is:
MariaDB [test]> select * from v2;
+---+
| a |
+---+
| 1 |
| 1 |
| 1 |
| 1 |
+---+
4 rows in set (0.00 sec)
Changed in maria: | |
status: | In Progress → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
This bug is observed only on the LP tree for mwl#106.