On Thu, Oct 31, 2024 at 9:16 PM jian he <jian.universal...@gmail.com> wrote: > > hi. > still trying to understand v13. found a bug. > > minimum test : > drop table if exists t1, t2; > CREATE TABLE t1 (a int, b int, c int); > CREATE TABLE t2 (a int, b int, c int); > SET enable_eager_aggregate TO on; > explain(costs off, settings) SELECT avg(t2.a), t1.c FROM t1 JOIN t2 ON > t1.b = t2.b GROUP BY t1.c having grouping(t1.c) > 0; > > havingQual can have GroupingFunc. > if that happens, then segmentation fault.
Nice catch. Thanks. create_agg_clause_infos does check for GROUPING() expressions, but not in the right place. Will fix it in the next version. Thanks Richard
