Horton

Re: "SELECT ... FROM DUAL" is not quite as silly as it appears

Laurenz Albe <laurenz.albe@cybertec.at>

View thread View on postgr.es
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: David Rowley <david.rowley@2ndquadrant.com>
Cc: Stefan Keller <sfkeller@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2019-01-28T11:59:30Z
Lists: pgsql-hackers 
David Rowley wrote:
> hmm. You both know the table of that name exists only as part of a
> regression test, right?  It'll just exist for a handful of
> milliseconds during make check.

Er, I wasn't aware of that, as I didn't read the patch.
Then I think my comment should be discarded as being overly pedantic.

Yours,
Laurenz Albe

Commits

  1. In the planner, replace an empty FROM clause with a dummy RTE.

  2. Fix jit compilation bug on wide tables.