On 12/12/2017 15:38, Gabor Boros wrote: > 2017. 12. 12. 17:34 keltezéssel, Adriano dos Santos Fernandes írta: > >> Can you make this leaks using only ISQL? >> >> 1) Running the SELECT statement one after another > > > If run the next SELECT 5 times I get the below stats. > > SQL> SELECT * FROM TABLE1 ORDER BY > (CAST(SUBSTRING(TABLE1.TEXT_BLOB_FIELD FROM 1 FOR 40) AS VARCHAR(40)));
... > So, I think no, but don't know how ISQL handle transactions, etc. > My application use only one transaction (read_committed rec_version > wait read), start before run the SELECT statements and commit after. > When you say that problem does not happen with UTF8 but happens with WIN1250, isn't it because you're also using UTF8 as connection charset? If your connection charset is different from the blob one, it will create a temporary blob, a since you never finish the transaction, it will "leak". Adriano ------------------------------------------------------------------------------ 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
