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