Closed james-whiteside closed 7 months ago
This appears to have been fixed in #549, which was released in 2.26.3. Can you please double check with a more recent version of Studio?
Confirmed working on 2.26.6. Apologies for inconvenience. I think it's a bit weird that we get null
when part of a subquery and NaN
otherwise but that's a seperate and minor issue. Closing.
we get null when part of a subquery and NaN otherwise
JSON floats cannot be NaNs and are replaced with nulls instead.
Description
If an aggregate subquery in a Fetch query returns a NaN, then
CXN07
is thrown. For example, in the following query, none of the books in the order have a price that high. The standard deviation of zero elements is undefined and resolves to NaN.However, instead of returning JSON containing a NaN, an error is thrown.
Environment