Do not allow Unique nodes to be scanned backwards. The code claimed that it
authorTom Lane <tgl@sss.pgh.pa.us>
Tue, 5 Aug 2008 21:29:01 +0000 (21:29 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 5 Aug 2008 21:29:01 +0000 (21:29 +0000)
commit808c935bf2a92a6363c31f3d0f2a8e5a00ac41d8
tree45dfda943a3f350eb5cc549ad8d1494c9fe9ebc9
parent7fa3d70b8bdbf8a0aa4b8ba5def7af5263f9294d
Do not allow Unique nodes to be scanned backwards.  The code claimed that it
would work, but in fact it didn't return the same rows when moving backwards
as when moving forwards.  This would have no visible effect in a DISTINCT
query (at least assuming the column datatypes use a strong definition of
equality), but it gave entirely wrong answers for DISTINCT ON queries.
src/backend/executor/execAmi.c
src/backend/executor/nodeUnique.c