Thread: pgsql/src/backend/optimizer/prep prepunion.c

pgsql/src/backend/optimizer/prep prepunion.c

From
Tom Lane
Date:
CVSROOT:    /home/projects/pgsql/cvsroot
Module name:    pgsql
Changes by:    tgl@hub.org    01/08/14 13:12:57

Modified files:
    src/backend/optimizer/prep: prepunion.c

Log message:
    Fix brokenness of nested EXCEPT/INTERSECT queries.  prepunion was being
    a tad sloppy about generating the targetlist for some nodes, by generating
    a tlist entry that claimed to be a constant when the value wasn't actually
    constant.  This caused setrefs.c to do the wrong thing later on.


Re: pgsql/src/backend/optimizer/prep prepunion.c

From
Bruce Momjian
Date:
Tom, thanks for fixing this.  I couldn't verify the bug because the test
case was so complex.

> CVSROOT:    /home/projects/pgsql/cvsroot
> Module name:    pgsql
> Changes by:    tgl@hub.org    01/08/14 13:12:57
>
> Modified files:
>     src/backend/optimizer/prep: prepunion.c
>
> Log message:
>     Fix brokenness of nested EXCEPT/INTERSECT queries.  prepunion was being
>     a tad sloppy about generating the targetlist for some nodes, by generating
>     a tlist entry that claimed to be a constant when the value wasn't actually
>     constant.  This caused setrefs.c to do the wrong thing later on.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026