S06010

Error Code

S06010

Error Message

To form a pair, both operands must have the same data category. RefId: S06009

Probable Causes

This error occurs when the keyword IS is not followed by NULL or NOT NULL (case insensitive).

For example:

t = table([1,2,3] as id, [10,,30] as val)
select * from t where val is 10

Solutions

Ensure that the keyword IS is followed by NULL or NOT NULL (case insensitive).

t = table([1,2,3] as id, [10,,30] as val)
select * from t where val is null
select * from t where val is not null
select * from t where val = 10