[TAJO-785] CaseWhenPredicate occasionally can be wrong at where clause.

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Planner/Optimizer
• Assignee: JaeHwa Jung
• Reporter: JaeHwa Jung
• Created: 21/Apr/14 23:45
• Updated: 15/Oct/15 04:11

Description

I found a bug for CaseWhenPredicate as follows:

• SQL

  select count(*)
   from store_sales
   JOIN date_dim ON store_sales.ss_sold_date_sk = date_dim.d_date_sk
   JOIN store ON store_sales.ss_store_sk = store.s_store_sk
   JOIN household_demographics ON store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk
   where
       (date_dim.d_dom between 1 and 3 or date_dim.d_dom between 25 and 28)
   and (household_demographics.hd_buy_potential = '>10000' or
        household_demographics.hd_buy_potential = 'unknown')
   and household_demographics.hd_vehicle_count > 0
   and (case when household_demographics.hd_vehicle_count > 0
       then household_demographics.hd_dep_count/ household_demographics.hd_vehicle_count
       else null
       end)  > 1.2
   and date_dim.d_year in (1998,1999,2000)
   and store.s_county in ('Williamson County','Williamson County','Williamson County','Williamson County',
                          'Williamson County','Williamson County','Williamson County','Williamson County')
  

• Expected Result

  ?count
  -------------------------------
  325831
  

• Actual Result

  ?count
  -------------------------------
  249749
  

Issue Links

• is related to: TAJO-778 TPC-DS Q34 occurs NPE