From: | Michael Reifenberger <root(at)nihil(dot)plaut(dot)de> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | query corruption for complexer queries on -current? |
Date: | 1999-03-15 16:38:28 |
Message-ID: | Pine.BSF.4.10.9903151732130.394-300000@nihil.plaut.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Michael Reifenberger
Your email address : root(at)nihil(dot)plaut(dot)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
Attachment | Content-Type | Size |
---|---|---|
a.sql | text/plain | 2.4 KB |
sel_reise.sh | text/plain | 1.1 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan A. Zdziarski | 1999-03-15 17:17:40 | Solaris 7 Compiling |
Previous Message | Unprivileged user | 1999-03-15 04:47:33 | General Bug Report: Transaction END statemente generates NOTICE: EndTransactionBlock and not inprogress/abort state |