S06011
Error Code
S06011
Error Message
Please use '==' rather than '=' as equal operator in non-sql expression.
RefId: S06011
Probable Causes
Only in SQL are = and == equivalent, both
representing equal values. In non-SQL context, = is used only for
assignment.
For example, this error occurs when using = to evaluate the
expression 1=2.
1 = 2Solutions
In non-SQL context, ensure that = is used only for assignment and
replace those misused for equation with ==.
1 == 2
t = table([1,2,3] as id, [10,,30] as val)
select * from t where id = 2
select * from t where id == 2