Re: Using non-grouping-keys at HAVING clause

2023年9月8日(金) 19:07 Vik Fearing : > > On 9/8/23 09:42, Kohei KaiGai wrote: > > Hello, > > > > I got a trouble report here: > > https://github.com/heterodb/pg-strom/issues/636 > > > > It says that PG-Strom raised an error when the HAVING clause used > > non-grouping-keys, > > even though the vanilla

Re: Using non-grouping-keys at HAVING clause

On 9/8/23 09:42, Kohei KaiGai wrote: Hello, I got a trouble report here: https://github.com/heterodb/pg-strom/issues/636 It says that PG-Strom raised an error when the HAVING clause used non-grouping-keys, even though the vanilla PostgreSQL successfully processed the query. SELECT MAX(c0) FROM

Using non-grouping-keys at HAVING clause

Hello, I got a trouble report here: https://github.com/heterodb/pg-strom/issues/636 It says that PG-Strom raised an error when the HAVING clause used non-grouping-keys, even though the vanilla PostgreSQL successfully processed the query. SELECT MAX(c0) FROM t0 GROUP BY t0.c1 HAVING t0.c0