git.postgresql.org Git - postgresql.git/commit

git projects / postgresql.git / commit

Do not allow Unique nodes to be scanned backwards. The code claimed that it

author Tom Lane <tgl@sss.pgh.pa.us>

Tue, 5 Aug 2008 21:28:29 +0000 (21:28 +0000)

committer Tom Lane <tgl@sss.pgh.pa.us>

Tue, 5 Aug 2008 21:28:29 +0000 (21:28 +0000)

commit 3d40d5e70ebe21b7d52467987bffad8aea16f29b

tree b7fb0cd8a67b77ed297451481c956cba430aa3f2 tree

parent c78248c91d5147a45907cb05d2c424cf4a3a792d commit | diff

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 diff | blob | blame | history

src/backend/executor/nodeUnique.c diff | blob | blame | history

This is the main PostgreSQL git repository.

RSS Atom