TIBCQuery Error "unable to allocate memory from operating system"

[TheFastCoder]

Hi,

I have a Firebird 3.x database with a table MyTable and this field:

Code: Select all

MyField     BLOB SUB_TYPE 1 SEGMENT SIZE 512

I'm using IBDAC 8.1.1 with an TIBCQuery and this SQL statement:

Code: Select all

select cast(MyField as varchar(8000))
from MyTable
where ID = 123

This gives this error:

Code: Select all

unable to allocate memory from operating system

My record with ID 123 has only 10 chars in MyField.
If I use this SQL statement in an 3rd party database management tool (IBExpert) an run it, everything is ok.
Older versions of IBDAC have executed this code without any problems.

What can we do?

[pavelpd]

Hi,
We've reproduced the issue and fixed it. The fix will be included in the next build of our product.
As a workaround, we can send you a nightly IBDAC build including the required changes.
Please specify your license number, IDE version and send us via this contact form: https://www.devart.com/company/contactform.html