gregrahn / tpcds-kit

TPC-DS benchmark kit with some modifications/fixes
317 stars 200 forks source link

query51a - erroneous line break #33

Closed gregrahn closed 6 years ago

gregrahn commented 7 years ago

Line 90 has an erronous line break causing the column alias to be on two lines. Seems like an obvious mistake.

select v1.item_sk, v1.d_date, v1.web_sales, v1.store_sales, max(v2.web_sales) web_cumulative, max(v2.store_sales) s
tore_cumulative
gregrahn commented 7 years ago

Fixed in this repo via 9ef085d

gregrahn commented 7 years ago

Present in v2.4.0

gregrahn commented 6 years ago

Present in v2.6.0

gregrahn commented 6 years ago

Fixed in v2.9.0

$ diff v2.8.0rc4/query_variants/query51a.tpl v2.9.0rc2/query_variants/query51a.tpl
90,91c90
<         select v1.item_sk, v1.d_date, v1.web_sales, v1.store_sales, max(v2.web_sales) web_cumulative, max(v2.store_sales) s
< tore_cumulative
---
>         select v1.item_sk, v1.d_date, v1.web_sales, v1.store_sales, max(v2.web_sales) web_cumulative, max(v2.store_sales) store_cumulative