Skip site navigation (1) Skip section navigation (2)

optimizer bug report

From: "Roberto Cornacchia" <rcorna(at)tin(dot)it>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: optimizer bug report
Date: 1999-07-11 16:06:29
Message-ID: 000501becbb7$5725c7a0$558cd8d4@robertoc (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
                        POSTGRESQL BUG REPORT TEMPLATE

Your name  :    Roberto Cornacchia
                             Andrea Ghidini
Your email address :    cornacch(at)cs(dot)unibo(dot)it

System Configuration
  Architecture (example: Intel Pentium)   :   Intel Pentium II

  Operating System (example: Linux 2.0.26 ELF)  :   Linux 2.2.5-15 ELF

  PostgreSQL version (example: PostgreSQL-6.5)  :   PostgreSQL-6.5

  Compiler used (example:  gcc 2.8.0)  :   gcc egcs-2.91.66

Please enter a FULL description of your problem:
We found a behaviour in the paths pruning that seems to us anomalous even if
it does not corrupt the correctness.
During the enumeration and pruning of the paths, when deciding wether to add
new path to the current pathlist and in the situation where
- the pathlist contains an unordered path (cheapest) and some ordered paths
- the newpath is ordered and cheaper than the unordered, but the pathlist
  already contains a path with such an order
it happens that the new path simply replaces the unordered one so that the
pathlist contains two paths with the same order, when only the cheaper
be kept.
We think the right behaviour should have been to still prune the unordered
path, but not add the new one and instead go on deciding for the new path
insertion with the reminder of the pathlist.

Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
  SELECT relname
  FROM pg_class, pg_index, pg_attribute
  WHERE pg_class.oid=indrelid AND pg_class.oid=attrelid;

If you know how this problem might be fixed, list the solution below:
We have fixed the problem and generated a patch mailed to

pgsql-bugs by date

Next:From: Unprivileged userDate: 1999-07-11 21:02:34
Subject: General Bug Report: INSTALL and regression notes
Previous:From: Tom LaneDate: 1999-07-10 18:35:06
Subject: Re: [BUGS] General Bug Report: GROUP BY with NULL not done properly(Oracle8& DB/2 do this completely different)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group