From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | dschultheiss(at)gsd-software(dot)com |
Subject: | BUG #15941: Query does not return |
Date: | 2019-08-07 13:16:05 |
Message-ID: | 15941-70a8d08012f923d3@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 15941
Logged by: Dirk Schultheiß
Email address: dschultheiss(at)gsd-software(dot)com
PostgreSQL version: 12beta2
Operating system: Windows 10 1903
Description:
If we execute the following query it will not return and more than one
postgres.exe have high load. Actually it should return 0 tuples.
We tested this query with our software and with pgAdmin as well.
If we change the two values of '2019-03-21T14:30:47' to e. g.
'2010-03-21T14:30:47' the query does return.
Select _$I.CID$$, _$I.OID$$, _$I.erstellungszeit$
From
GSD_Objects_Indexes.dokument$besitzer$$l$besitzer$string20$a$_erstellungszeit$$l$er
As _$I
Where ( _$I.OID$$ In
( Select _$1.OID$$
From
GSD_Objects_Indexes.dokument$empfaenger$$l$empfaenger$dokumentempfaenger$a
As _$1
Group By _$1.OID$$
Having Count ( * ) > 0 ) )
And ( _$I.erstellungszeit$ >= '2019-03-21T14:30:47'
And ( _$I.erstellungszeit$ > '2019-03-21T14:30:47'
Or _$I.OID$$ > 339136262 ) );
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-08-07 15:16:08 | Re: BUG #15941: Query does not return |
Previous Message | Michael Paquier | 2019-08-07 09:54:44 | Re: BUG #15910: Valgrind-detected error in DecodeTimeOnly |