Jeff Seaman (jeffery(dot)l(dot)seaman(at)intel(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
Joins on over 10 tables returns unreliable results
Long Description
Running Postgres version 7.01 on Redhat linux 6.2. When joining on more than 10 tables not all of the expected results are returned. The query can be repeated several times, with different result sets when the data itself is static. The most common result is the return of only one record. 11 tables seems to be the magic limit. Joins on 10 tables works without a hitch. This join was based on a column id that exists in all of the tables.
Sample Code
No file was uploaded with this report