S02005

Error Code

S02005

Error Message

Unrecognized column name. RefId:S02005

Probable Causes

This error may occur when the column specified in the SELECT statement does not exist in the referenced table. For example, the "x" column to be queried does not exist in table "t".

n = 10000
type = take(1..10, n)
sys = take(char('A' + 0..3), n)
t = table(type, sys)
select x from t; // throw an exception
select sys from t; // successfully executed

Solutions

Verify that the column name used in the SELECT statement actually exists in the table being queried. Double-check for any typos or incorrect column names that may have been specified in the query.