Why jsonArrayFrom converts a Generated<number> field into string | number?
Look at this pic
Solution:Jump to solution
Since you're not using table specifiers, are you sure some "parent" table doesn't also have those columns and you are actually selecting them?
5 Replies
using a $castTo solves it, but I'd like to understand the behavior
another weird type change, here country and state aren't nullable but jsonObjectFrom changes them:
Solution
Since you're not using table specifiers, are you sure some "parent" table doesn't also have those columns and you are actually selecting them?
It's much easier to help if you provide a playground or even the full code as a text
you nailed it, I feel so dumb!
thanks a lot @koskimas