node-firebird icon indicating copy to clipboard operation
node-firebird copied to clipboard

Subquery returns [Function]

Open MarcelLZ opened this issue 7 years ago • 1 comments

Hi everyone!

I'm running a SQL statement and it has a sub select. But after running, the result field has a [Function] value.

Do I doing something wrong? My SQL is something like it:

SELECT
	product.CODE
	, (SELECT LIST(item.size, '/') FROM ITEMS item WHERE item.CODE = product.CODE) AS SIZES
FROM
	PRODUCTS product
WHERE
	product.CODE = '98015';

But, the result is:

CODE SIZES
98015 [Function]

MarcelLZ avatar Nov 30 '18 14:11 MarcelLZ

I can guess that LIST() returns a CLOB. So the recepie is the same as in the "READING BLOBS (ASYNCHRONOUS)" section of the readme.md

MaximS avatar Dec 12 '18 17:12 MaximS