BUG #15941: Query does not return
От | PG Bug reporting form |
---|---|
Тема | BUG #15941: Query does not return |
Дата | |
Msg-id | 15941-70a8d08012f923d3@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15941: Query does not return
|
Список | pgsql-bugs |
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 ) );
В списке pgsql-bugs по дате отправления: