Calin Pirtea wrote:

>
> What we are trying to do is get a short message from the content of the
> blob which is in the first 100 chars of the blob and after various
> changes to it we place this in another field that is then aggregated.
>
> We are looking for help in identifying a workaround for this issue.

Have you considered writing an UDF which receives a blob and returns a
varchar? It shouldn't produce any temporary blobs and its input blob
will be closed right after the UDF is executed, so I don't expect any
memory to leak here.


Dmitry