BUG #15941: Query does not return

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #15941: Query does not return

PG Bug reporting form
The following bug has been logged on the website:

Bug reference:      15941
Logged by:          Dirk Schultheiß
Email address:      [hidden email]
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 ) );

Reply | Threaded
Open this post in threaded view
|

Re: BUG #15941: Query does not return

Tom Lane-2
PG Bug reporting form <[hidden email]> writes:
> If we execute the following query it will not return and more than one
> postgres.exe have high load.

This is not a bug, or at least you've presented no evidence why
it should be considered one.  Actually, you've presented no evidence
period, because an unintelligible query given in isolation isn't
something anyone can comment on.  Please review

https://wiki.postgresql.org/wiki/Slow_Query_Questions

                        regards, tom lane