| From: | Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup |
| Date: | 2017-10-16 06:48:16 |
| Message-ID: | 87a80rli2w.fsf@news-spur.riddles.org.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
>>>>> "Andrew" == Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> writes:
Andrew> I've been testing Heikki's patch with the havingQual condition
Andrew> removed, and I haven't found any issues yet.
Further experimentation reveals that this change has the effect of
blocking constant-folding in aggregate input expressions that refer to
constant outputs of the subquery.
Is it worth doing anything about that?
--
Andrew (irc:RhodiumToad)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2017-10-16 08:58:03 | Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)? |
| Previous Message | Eduardo Pérez Ureta | 2017-10-16 05:40:36 | Re: BUG #14853: Parameter type is required even when the query does not need to know the type |