Drizzle failed to parse an empty JSONB Array
so I have a query that calls
ARRAY_AGG()
function and the result of query returned the aggregated value
since the aggregated column is a JSONB this results in Array of JSONB, but some of the row may return an empty json,
this is the query for the selector
however due to the particular empty array i got an error SyntaxError: Unexpected token N in JSON at position 0
, I was able to confirm this by adding a limit(1)
to the query
by limiting the query which only return 1 row
the query was performed sucesfully0 Replies