Alexey Nalimov

and values also kept wrong

The problem is idenitied, it's not related to the case originally described. After TZQuery SQL text is changed, parameters assigned to the previous SQL are partially unchanged, i.e. parameter names are set to new SQL, but data types are unmodified !

Complier is Delphi 10.1 Berlin update 2 Postgres - got same problems with 12.5 and 11.1

My pardon, yes. AV no more reproduced with this build, possibly already solved.

Yesterday I updated to to last daily build (4156), no more AV happened. I will try to make some more stress tests, will update if something happens. As I wrote before, problem was not stable - it happens after some work time on the same connection, and on some selected queries only - i.e. some other queries on the same connection were OK.

Finally, adding or removing "{" and "}" in the guid value does not match. Resultset is returned empty. If the same query text executed directly on Postgres, result test is ok. I was wrong about 7.1 - this version does see GUID fields in the result set at all, but string parameters handling is ok. Possibly I had some older build of 7.2 that worked before.

Finally, adding or removing "{" and "}" in the guid value does not match. Resultset is returned empty. If the same query text executed directly on Postgres, result test is ok.

Hi ! I understand that direct work is not possible as soon as TParam.AsGUID is missing in DB.pas. But PostgreSQL works ok with string uuid values, even without specifying direct type case (::uuid), and query text like SELECT * from DATA where DATA.uuidfield = '8a0460d4-f58f-4f07-b4ac-a7b5b6a860a5' works peerfectly. And also variant of: SELECT * from DATA where DATA.uuidfield = :UUIDVALUE Query.ParamByName('UUIDVALUE').AsString := '8a0460d4-f58f-4f07-b4ac-a7b5b6a860a5'; had been working correct in...