Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.2.5
-
None
-
2020-7
Description
Consider the following from queries/working_tpch1_compareLogOnly/partitionOptimization/vTpch02b.sql
drop view if exists vTemp;
create view vTemp as select * from v_part where p_size=15 and p_type like '%BRASS';
select s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment
from vTemp, supplier, partsupp pso, nation, region
where p_partkey = pso.ps_partkey
and s_suppkey = pso.ps_suppkey
and s_nationkey = n_nationkey
and n_regionkey = r_regionkey
and r_name = 'EUROPE'
and pso.ps_supplycost = (select min(psi.ps_supplycost)
from partsupp psi, supplier, nation, region
where pso.ps_partkey = psi.ps_partkey
and s_suppkey = psi.ps_suppkey
and s_nationkey = n_nationkey
and n_regionkey = r_regionkey
and r_name = 'EUROPE')
order by s_acctbal desc,
n_name,
s_name,
p_partkey
limit 100;
In 1.1, this produces the correct answer.
In 1.2.5 forward, this produces:
ERROR 1815 (HY000) at line 4: Internal error: IDB-1000: 'vtemp' and 'vTemp, nation, pso, region, sub-query, supplier' are not joined.
Attachments
Issue Links
- relates to
-
MCOL-4184 Table join not working in 1.4, previous worked in 1.2
- Closed