Details
-
Bug
-
Resolution: Fixed
-
Major
-
5.5.0
-
Enterprise Edition 5.5.0 build 2211
-
Untriaged
-
No
-
CX Sprint 96, CX Sprint 97, CX Sprint 112, CX Sprint 113
Description
As per definition in N1QL for IFINF(expression1, expression2, ...):
Returns first non-MISSING, non-Inf number. Returns MISSING or NULL if a non-number input is encountered first.
Select IFINF(2,1/0); In this statement the first input is a number and second is an infinite value.
N1QL returns 2 but analytics gives an error:
[
{ "code": 1, "msg": "Exception: java.lang.ArithmeticException: Division by Zero.", "query_from_user": "select IFINF(2,1/0)" }]