]> granicus.if.org Git - postgresql/commit
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:28:36 +0000 (21:28 +0000)
committerTom Lane <tgl@sss.pgh.pa.us>
Tue, 5 Aug 2008 21:28:36 +0000 (21:28 +0000)
commitd116bebda9eda46c960dcd2bf1cb5ee25223f5b7
tree1097b26c9442d531161c009b4f21facb66b34748
parent6bf23357262765f263db57cae59a4f345bce3de6
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