| From: | Michael Reifenberger <root(at)nihil(dot)plaut(dot)de> |
|---|---|
| To: | PostgreSQL Hackers <hackers(at)postgreSQL(dot)org> |
| Subject: | query corruption for complexer queries on -current? |
| Date: | 1999-03-10 22:46:21 |
| Message-ID: | Pine.BSF.4.05.9903102332510.12418-300000@nihil.plaut.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi,
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?
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 | Bruce Momjian | 1999-03-10 23:11:38 | Re: [HACKERS] Developers globe |
| Previous Message | Vince Vielhaber | 1999-03-10 21:57:26 | Re: [HACKERS] Developers globe |