Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Subselect can't return Blob or Clob |
Thu, May 1 2014 9:40 PM | Permanent Link |
Barry | 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 |
Thu, May 1 2014 10:43 PM | Permanent Link |
Fernando Dias Team Elevate | 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] |
Thu, May 1 2014 10:54 PM | Permanent Link |
Fernando Dias Team Elevate | Barry,
Thinking better, even for CLOB, casting it as varchar is not a real workaround ... -- Fernando Dias [Team Elevate] |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |