PostgreSQL Bugs

Collected from the PG bugs email list.

Bug ID15941
PG Version12beta2
OSWindows 10 1903
Opened2019-08-07 13:16:05+00
Reported byDirk Schulthei├č
StatusNew

Body of first available message related to this bug follows.

The following bug has been logged on the website:

Bug reference:      15941
Logged by:          Dirk Schulthei├č
Email address:      (redacted)
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 ) );

Messages

DateAuthorSubject
2019-08-07 13:16:05+00PG Bug reporting formBUG #15941: Query does not return
2019-08-07 15:16:08+00Tom LaneRe: BUG #15941: Query does not return