bugs in query22a

Question

bugs in query22a

gregrahn opened this issue 8 years ago · 6 comments

As of v2.4 the results CTE has a group by that appears to be a mistake. There is no aggregate and when removing the group by query22a returns the same result then as query22.

ERROR:  column "inventory.inv_quantity_on_hand" must appear in the GROUP BY clause or be used in an aggregate function
LINE 6:              ,inv_quantity_on_hand qoh
                      ^

Additionally query22a has a reference to the warehouse table and corresponding join -- which is not present in query22.

from inventory
           ,date_dim
           ,item
           ,warehouse  -- <<< Not in query22
       where  inv_date_sk=d_date_sk
              and inv_item_sk=i_item_sk
              and inv_warehouse_sk = w_warehouse_sk  -- <<< Not in query22
              and d_month_seq between [DMS] and [DMS] + 11

Answer 1 · 2017-04-27T04:22:26.000Z

Fixed in this repo via 3a3d823.

Answer 2 · 2017-05-20T20:49:56.000Z

Present in v2.4.0

Answer 3 · 2017-10-18T05:38:08.000Z

Present in v2.6.0

Answer 4 · 2018-07-22T21:10:15.000Z

Present in v2.9.0

Answer 5 · 2019-05-21T00:03:34.000Z

Present in v2.11.0

Answer 6 · 2020-03-11T19:45:43.000Z

Removed references to warehouse in 5a3a817