query corruption for complexer queries on -current?

Michael Reifenberger <root@nihil.plaut.de>

From: Michael Reifenberger <root@nihil.plaut.de>
To: pgsql-bugs@postgresql.org
Date: 1999-03-15T16:38:28Z
Lists: pgsql-bugs

Attachments

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		:	Michael Reifenberger
Your email address	:	root@nihil.plaut.de


System Configuration
---------------------
  Architecture (example: Intel Pentium)  	: Intel PII

  Operating System (example: Linux 2.0.26 ELF) 	: FreeBSD 4.x -current

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

  Compiler used (example:  gcc 2.8.0)		: 2.7.2.1


Please enter a FULL description of your problem:
------------------------------------------------

using the structure from a.sql, populating with some entries, using the query in
sel_reise.sh (with hitting some tuples) I get only a subset (1 entry!) of the
matching tuples. Delting all lines in sel_reise.sh where 'e.*' is used
(3.lines), I get all tuples. The same script works without errors on pgsql 6.3
using the same data. 

Some stats with my original data:

abr=> select count(*) from reise where begt > 'Feb 01 00:00:00 1999';
count
-----
   13
(1 row)
          
abr=> select distinct mid from reise where begt > 'Feb 01 00:00:00 1999';
mid
---
605
(1 row)

abr=> select distinct mid from emp;
mid
---
  0
605
(2 rows)
         
Any clues?



Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 
----------------------------------------------------------------------

see above






Bye!
----
Michael Reifenberger
Plaut Software GmbH, R/3 Basis