Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
0.13.0
-
None
Description
Following query has a little mismatch in result as compared to the non-vector mode.
select d_year, i_brand_id, i_brand, sum(ss_ext_sales_price) as sum_agg from date_dim join store_sales on date_dim.d_date_sk = store_sales.ss_sold_date_sk join item on store_sales.ss_item_sk = item.i_item_sk where i_manufact_id = 128 and d_moy = 11 group by d_year, i_brand, i_brand_id order by d_year, sum_agg desc, i_brand_id limit 100;
This query is on tpcds data.
The field ss_ext_sales_price is of type decimal(7,2) and everything else is an integer.