[ https://issues.apache.org/jira/browse/DRILL-867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15007335#comment-15007335 ]
Victoria Markman commented on DRILL-867: ---------------------------------------- I'm going to add these queries to the regression suite as negative tests to make sure we don't regress anything. Resolving as fixed for now. > tpcds queries 6, 9 and 10 fail to plan > -------------------------------------- > > Key: DRILL-867 > URL: https://issues.apache.org/jira/browse/DRILL-867 > Project: Apache Drill > Issue Type: Bug > Components: SQL Parser > Reporter: Krystal > Priority: Minor > Fix For: Future > > > git.commit.id.abbrev=e1e5ea0 > git.commit.time=29.05.2014 @ 15\:32\:29 PDT > query 6: > {code} > select * from (select a.ca_state state, count(*) cnt > from customer_address a > ,customer c > ,store_sales s > ,date_dim d > ,item i > where a.ca_address_sk = c.c_current_addr_sk > and c.c_customer_sk = s.ss_customer_sk > and s.ss_sold_date_sk = d.d_date_sk > and s.ss_item_sk = i.i_item_sk > and d.d_month_seq = > (select distinct (d.d_month_seq) > from date_dim d > where d.d_year = 1998 > and d.d_moy = 5 ) > and i.i_current_price > 1.2 * > (select avg(j.i_current_price) > from item j > where j.i_category = i.i_category) > group by a.ca_state > having count(*) >= 10 > order by cnt > ) limit 100; > {code} > query 7: -- This message was sent by Atlassian JIRA (v6.3.4#6332)