I noticed EDB 2.13 B2 cannot return a Clob or Blob in a subselect.

Example:

Select t1.FullName, (Select Image from Pictures where Name_Id=t1.Name_Id) from People t1;

The value returned for a Clob is an empty string and a Blob is of 0 bytes. (Neither values returned are NULL so it finds the row ok). If I replace "Image" with a text column like "Image_Name" it returns the text for Image_Name just fine in the subselect. But the Subselect cannot return a Clob or Blob value. Why?

Is this a bug or has it been fixed in a later EDB version? Or is this some sort of weird ANSI standard used to torment programmers?

TIA
Barry

Barry,

I see the same here with 2.16b2.
Looks like a bug, you should report it.
A possible workaround in case of CLOB type is to cast it as varchar.

--
Fernando Dias
[Team Elevate]

Barry,

Thinking better, even for CLOB, casting it as varchar is not a real workaround ...

--
Fernando Dias
[Team Elevate]