BUG #15941: Query does not return

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 ) );

Responses

Browse pgsql-bugs by date

  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