tpcds issues

[zhouqingqing]

features

• window function

-- end query 43 in stream 0 using template query43.tpl
-- start query 44 in stream 0 using template query44.tpl
select  asceding.rnk, i1.i_product_name best_performing, i2.i_product_name worst_performing
from(select *
     from (select item_sk,rank() over (order by rank_col asc) rnk

• having

                 having avg(ss_net_profit) > 0.9*(select avg(ss_net_profit) rank_col

• complex AND|OR (Q47)

• complicated CTEs

• rollups

       group by  rollup(i_category, i_class, i_brand, i_product_name, d_year, d_qoy, d_moy,s_store_id))dw1) dw2

issues

~~1. lost join predicates in cte~~ 2. setops disables memo optimization ~~3. IN predicate CE is not implemented~~ q10

  -> PhysicScanTable customer_address as ca (inccost=1000, cost=1000, rows=1000) (actual rows=7)
          Filter: ca_county[7] in ('Fairfield County','Campbell County','Washtenaw County', ... <Total: 5> )

4. wrong plan with OR subquery predicate: q10

                    -> PhysicFilter  (inccost=4338248701, cost=5366485, rows=5364601) (actual rows=0)
                        Filter: {#marker}[0] or @3
                        <ExistSubqueryExpr> 3
                            -> LogicFilter
                                Filter: true
                                -> LogicJoin
                                    Filter: cs_sold_date_sk[0]=d_date_sk[0]
                                    -> LogicMemoRef
                                        -> LogicScanTable catalog_sales
                                    -> LogicMemoRef
                                        -> LogicScanTable date_dim
                                            Filter: d_year[6]=2001 and d_moy[8]>=3 and d_moy[8]<=6