[jira] [Created] (KYLIN-2150) detailed subquery + outer query filter will fail

[hongbin ma (JIRA)]

hongbin ma created KYLIN-2150:
---------------------------------

             Summary: detailed subquery + outer query filter will fail
                 Key: KYLIN-2150
                 URL: https://issues.apache.org/jira/browse/KYLIN-2150
             Project: Kylin
          Issue Type: Bug
            Reporter: hongbin ma
            Assignee: liyang


select x,y from  (select cast(seller_id as varchar(10)) x, trans_date_2 y from 
fact01_v group by cast(seller_id as varchar(10)) , trans_date_2) t  where x = 
'1000121'  group by x,y 

will succeed, 

select x, y from  (select cast(seller_id as varchar) x, trans_date_2 y from 
fact01_v ) t  group by x,y

will succeed too. However 

select x,y from  (select cast(seller_id as varchar(10)) x, trans_date_2 y from 
fact01_v group ) t  where x = '1000121'  group by x,y 

will fail



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)