Postgres 10&11 data processing error
| От | Александр Денежкин |
|---|---|
| Тема | Postgres 10&11 data processing error |
| Дата | |
| Msg-id | CAHEfaNZpW=uQ2VZs=+NwF12V_YFf897=7b7LVwCiLjZv3T4+1A@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Postgres 10&11 data processing error
|
| Список | pgsql-bugs |
Hello, i guess there is the error in Postgresql 10.x and 11.x. I'm using russian ERP platform 1C with Postgres for data processing and storing.
Postgres 10 and 11 (both Linux and Windows) logs error:
2019-08-14 09:05:10.758 MSK [31696] ERROR: index key does not match expected index column
On query:
2019-08-14 07:40:03.417 MSK [12538] STATEMENT: SELECT
T1._IDRRef,
T1._Fld745RRef,
T1._Date_Time,
T1._Fld740
FROM _Document148 T1
LEFT OUTER JOIN _Document148 T2
ON (T1._IDRRef = T2._IDRRef) AND (T2._Fld376 = CAST(0 AS NUMERIC))
WHERE ((T1._Fld376 = CAST(0 AS NUMERIC))) AND (((T2._Fld734RRef = '\\237%\\014\\272J\\012\\005\\234B\\214\\177\\232/Ri\\350'::bytea) OR (T2._Fld734RRef = '\\244\\221k}F\\256\\031AML\\306!x\\376\\353\\234'::bytea)) AND T1._Posted = TRUE AND (T1._Fld745RRef IN ('\\274\\215\\364M0o\\375\\250\\021\\351C\\024Z(`\\236'::bytea)) AND (((T1._Date_Time >= '2019-08-14 00:00:00'::timestamp) AND (T1._Date_Time < '2019-09-10 23:59:00'::timestamp)) OR ((T1._Fld740 > '2019-08-14 00:00:00'::timestamp) AND (T1._Fld740 <= '2019-09-10 23:59:00'::timestamp))) AND (T1._Fld733RRef = '\\317\\200\\364M0o\\375\\250\\021\\351<\\016\\331\\310\\247\\022'::bytea) AND (T1._Fld754RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea))
ORDER BY (T1._Date_Time)
T1._IDRRef,
T1._Fld745RRef,
T1._Date_Time,
T1._Fld740
FROM _Document148 T1
LEFT OUTER JOIN _Document148 T2
ON (T1._IDRRef = T2._IDRRef) AND (T2._Fld376 = CAST(0 AS NUMERIC))
WHERE ((T1._Fld376 = CAST(0 AS NUMERIC))) AND (((T2._Fld734RRef = '\\237%\\014\\272J\\012\\005\\234B\\214\\177\\232/Ri\\350'::bytea) OR (T2._Fld734RRef = '\\244\\221k}F\\256\\031AML\\306!x\\376\\353\\234'::bytea)) AND T1._Posted = TRUE AND (T1._Fld745RRef IN ('\\274\\215\\364M0o\\375\\250\\021\\351C\\024Z(`\\236'::bytea)) AND (((T1._Date_Time >= '2019-08-14 00:00:00'::timestamp) AND (T1._Date_Time < '2019-09-10 23:59:00'::timestamp)) OR ((T1._Fld740 > '2019-08-14 00:00:00'::timestamp) AND (T1._Fld740 <= '2019-09-10 23:59:00'::timestamp))) AND (T1._Fld733RRef = '\\317\\200\\364M0o\\375\\250\\021\\351<\\016\\331\\310\\247\\022'::bytea) AND (T1._Fld754RRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea))
ORDER BY (T1._Date_Time)
On Postges 9.6 and earlier works fine....
You can download DB dump from http://89.169.110.237/fitness1c.sql
Let me know if you need any additional information
Thank a lot...
Вложения
В списке pgsql-bugs по дате отправления: