Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
1.0.3
-
None
-
2016-19, 2016-21, 2016-22
Description
working_tpch1/view/view.sql
The subquery view test matches a NULL where it shouldn't.
Query set from the test run to reproduce this:
create or replace view v1 as (select sub1.c1 s1c1, sub1.c2 s1c2, sub2.c1 s2c1, sub2.c2 s2c2 from sub1 left join sub2 on sub1.c1 = sub2.c1);
|
create or replace view v2 as (select sub3.c1 s3c1, sub4.c1 s4c1, sub3.c2 s3c2, sub4.c2 s4c2 from sub3 right join sub4 on sub3.c1 = sub4.c1);
|
select * from v2 where s3c1 in (select s1c1 from v1) order by 1,2,3,4;
|
All the fields are INTs, when a NULL is returned by the IN subquery it matches NULL rows in v2.s3c1. This shouldn't happen and only happens with vtable mode enabled.
