Hello,
I ran into this error while running Verify and Repair on 1C 8.3.5.1383 and PostgreSQL 9.3.4-1.1C:
Quote |
---|
EET ERROR: invalid regular expression: invalid character range |
PostgreSQL query:
Code |
---|
UPDATE _Document91_VT1758 SET _Fld1761_TYPE = '\\001'::bytea, _Fld1761_S = ''::mvarchar, _Fld1761_RTRef = '\\000\\000\\000\\000'::bytea, _Fld1761_RRRef = '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea WHERE (_Document91_VT1758._LineNo1759 = 1 AND _Document91_VT1758._Fld1760RRef = '\\206q\\000\\025\\027\\015\\375\\213\\021\\337\\264\\016\\240\\211\\023\\341'::bytea AND _Document91_VT1758._Fld1761_TYPE = '\\010'::bytea AND _Document91_VT1758._Fld1761_S = ''::mvarchar AND _Document91_VT1758._Fld1761_RTRef = '\\000\\000\\000u'::bytea AND _Document91_VT1758._Fld1761_RRRef = '\\230M\\000\\014)\\236''\\374\\021\\342:3\\177\\3762:'::bytea AND (_Document91_VT1758._Fld11071)::mvarchar SIMILAR TO ('Prepayment: 12 944.79 EUR \\(30.00 % from 43 149.31 EUR [DOC 01AB-1234ABC]\\)'::mvarchar)) AND _Document91_VT1758._Document91_IDRRef = '\\203V\\000\\014)\\236''\\374\\021\\342\\204\\311\\311W\\340\\217'::bytea |
Problem:
A comment field in 1C (Variable string, unlimited) is incorrectly escaped in PostgreSQL:
Code |
---|
AND (_Document91_VT1758._Fld11071)::mvarchar SIMILAR TO ('Prepayment: 12 944.79 EUR \\(30.00 % from 43 149.31 EUR [DOC 01AB-1234ABC]\\)'::mvarchar)) |
All special characters should be fully escaped:
Code |
---|
AND (_Document91_VT1758._Fld11071)::mvarchar SIMILAR TO ('Prepayment: 12 944.79 EUR \\(30.00 \\% from 43 149.31 EUR \\[DOC 01AB-1234ABC\\]\\)'::mvarchar)) |