Provider: Troubleshoot Seismic Query Failure
Against current Seismic data in GLAB instance, certain queries executed by our test webapp may fail with the following error:
Error parsing Where parameters, got 1=1
{
Error: '_parseWhereParams is not a function or its return value is not iterable'
}
2024-07-24T05:58:29.785Z error: _parseWhereParams is not a function or its return value is not iterable
We should identify the cause and implement a fix.
Cause: AST Parser considers some column names reserved, and errors out if it encounters them. A couple of our test layers used the column "Keys" which immediately produced an error in the AST Parser.
Fix: Pass only a truncated query to the AST Parser, which contains where clause in its entirety.
Edited by Levi Remington