Details
Description
Query issued:
select name from default_shadow where floor(job_title) > 5;
Above query gives correct message since job_title is a string for CBAS:
"msg": "asterix:floor expects a numeric input type, but gets STRING"
But gives no results in case of n1ql since N1QL never gives error, it gives missing if the input is invalid.
According to Sitaram, that is the decision made due to NOSQL.
Attachments
Issue Links
- relates to
-
MB-29954 [CX] Functions should return NULL instead of raising errors
- Open