[TAJO-363] Columns in subquery schema cannot be resolved

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 0.13.0
• Component/s: Planner/Optimizer, SQL Parser
• Assignee: Unassigned
• Reporter: Hyunsik Choi
• Created: 03/Dec/13 04:50
• Updated: 02/Dec/17 17:33

Description

See the below SQL statement. This statement contains a subquery with schema binding. Currently, LogicalPlanner cannot recognize subquery schema. So, the below statement causes "no such a column name exception".

select 
  c_count, 
  count(*) as custdist 
from 
( 
  select 
    c_custkey, 
    count(o_orderkey) 
  from 
    customer left outer join 
    orders 
      on c_custkey = o_custkey and 
      o_comment not like '%special%requests%' 
  group by 
    c_custkey 

) as c_orders (c_custkey, c_count) 

group by 
	c_count 
order by 
	custdist desc, c_count desc;


ERROR: no such a column name c_count

Issue Links

• duplicates: TAJO-1791 Cannot recognize column name from FROM subquery