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

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

Works fine on 9.1

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