What is "change the ORDER BY ASC/DESC in a query and close/open it"?
Meanwhile I realized the sort order is not count.
Is it same statement handle?
I use FPC/Lazarus and IBX for connection.
The test code is:
procedure Proc_Query(in_Query:TIBQuery);
begin
in_Query.Close;
in_Query.SQL.Clear;
in_Query.SQL.Add('SELECT * FROM TABLE1 ORDER BY
(CAST(SUBSTRING(TABLE1.TEXT_BLOB_FIELD FROM 1 FOR 40) AS VARCHAR(40)))');
in_Query.Open;
end;
What about WIN1250 with collation WIN1250?
Leak as WIN1250 with PXW_HUN.
The WIN1250 cases are executed slower than the UTF8.
Does it fetch or pre-fetch data?
Leak exists without explicit fetch, leak more if fetch "manually"
(in_Query.Last; after in_Query.Open;).
If the problem can't be reproduces with a simple database and simple
application, it's probably another problem.
I have a simple application and three databases. Can I send to you
privately? I attached earlier but got a message about the 40 KB body limit.
Gabor
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
