Re: Query results vary depending on the plan cache mode used

2024-08-01 Thread Tom Lane
Richard Guo writes: > Yeah, it's not the fault of the plan cache. I noticed this because in > check_ungrouped_columns, both Const and Param are treated as always > acceptable. However, in setrefs.c these two expression types are > handled differently: Const is never matched to the lower tlist, w

Re: Query results vary depending on the plan cache mode used

2024-08-01 Thread Richard Guo
On Thu, Aug 1, 2024 at 10:34 PM Tom Lane wrote: > Richard Guo writes: > > While working on the grouping sets patches for queries with GROUP BY > > items that are constants, I noticed $subject on master. As an > > example, consider > > This particular example seems like it's just an illustration

Re: Query results vary depending on the plan cache mode used

2024-08-01 Thread Tom Lane
Richard Guo writes: > While working on the grouping sets patches for queries with GROUP BY > items that are constants, I noticed $subject on master. As an > example, consider This particular example seems like it's just an illustration of our known bugs with grouping sets using non-Var columns.