The following bug has been logged on the website:
Bug reference: 15941
Logged by: Dirk Schultheiß
Email address: dschultheiss@gsd-software.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 ) );