9.2 bug? "variable not found in subplan target list"

On 09/12/2012 07:36 AM, Louis-David Mitterrand wrote:

See test case at: http://titus.apartia.fr/stuff/pg_92_error_sql.txt

Works fine on 9.1

I cannot absolutely say it is a bug as I haven't yet reviewed the
relevant release notes but I can confirm that I also see your test-case
working on 9.1 and failing on 9.2.

Cheers,
Steve

Louis-David Mitterrand <vindex+lists-pgsql-hackers@apartia.org> writes:

See test case at: http://titus.apartia.fr/stuff/pg_92_error_sql.txt
Works fine on 9.1

Thanks for the example. Looks like in commit
1bc16a946008a7cbb33a9a06a7c6765a807d7f59 I overlooked the need to
twiddle the logic that computes the starting-point targetlist for
window function evaluation. Will fix.

regards, tom lane