aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2008-08-05 21:28:48 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2008-08-05 21:28:48 +0000
commit5d46ee4a4a59e5febf202ec53a965a4551724504 (patch)
treefd549d0b14152663b39a1c0b5e926ac1a8d272b1 /src
parenta3a8f237bdac86904053190d0f3b3c541e843456 (diff)
downloadpostgresql-5d46ee4a4a59e5febf202ec53a965a4551724504.tar.gz
postgresql-5d46ee4a4a59e5febf202ec53a965a4551724504.zip
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.
Diffstat (limited to 'src')
-rw-r--r--src/backend/executor/execAmi.c5
1 files changed, 1 insertions, 4 deletions
diff --git a/src/backend/executor/execAmi.c b/src/backend/executor/execAmi.c
index be65336c109..3a8e3f0d517 100644
--- a/src/backend/executor/execAmi.c
+++ b/src/backend/executor/execAmi.c
@@ -6,7 +6,7 @@
* Portions Copyright (c) 1996-2005, PostgreSQL Global Development Group
* Portions Copyright (c) 1994, Regents of the University of California
*
- * $PostgreSQL: pgsql/src/backend/executor/execAmi.c,v 1.85.2.2 2008/07/10 01:17:52 tgl Exp $
+ * $PostgreSQL: pgsql/src/backend/executor/execAmi.c,v 1.85.2.3 2008/08/05 21:28:48 tgl Exp $
*
*-------------------------------------------------------------------------
*/
@@ -383,9 +383,6 @@ ExecSupportsBackwardScan(Plan *node)
case T_Sort:
return true;
- case T_Unique:
- return ExecSupportsBackwardScan(outerPlan(node));
-
case T_Limit:
return ExecSupportsBackwardScan(outerPlan(node));