node-firebird
node-firebird copied to clipboard
Subquery returns [Function]
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] |
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