sql
sql copied to clipboard
[BUG] Internal server error on incorrect syntax
What is the bug?
{
"datasource" : "mys3",
"lang" : "sql",
"query" : "ALTER MATERIALIZED VIEW mys3.default.`mv-v10` WITH (auto_refresh = false)"
}
{
"status": 500,
"error": {
"type": "SyntaxCheckException",
"reason": "There was internal problem at backend",
"details": "Failed to parse query due to offending symbol [MATERIALIZED] at: \u0027ALTER MATERIALIZED\u0027 \u003c--- HERE... More details: Expecting tokens in {\u0027(\u0027, \u0027ADD\u0027, \u0027ALTER\u0027, \u0027ANALYZE\u0027, \u0027CACHE\u0027, \u0027CALL\u0027, \u0027CLEAR\u0027, \u0027COMMENT\u0027, \u0027COMMIT\u0027, \u0027CREATE\u0027, \u0027DECLARE\u0027, \u0027DELETE\u0027, \u0027DESC\u0027, \u0027DESCRIBE\u0027, \u0027DFS\u0027, \u0027DROP\u0027, \u0027EXPLAIN\u0027, \u0027EXPORT\u0027, \u0027FROM\u0027, \u0027GRANT\u0027, \u0027IMPORT\u0027, \u0027INSERT\u0027, \u0027LIST\u0027, \u0027LOAD\u0027, \u0027LOCK\u0027, \u0027MAP\u0027, \u0027MERGE\u0027, \u0027MSCK\u0027, \u0027REDUCE\u0027, \u0027REFRESH\u0027, \u0027REPAIR\u0027, \u0027REPLACE\u0027, \u0027REVOKE\u0027, \u0027ROLLBACK\u0027, \u0027SELECT\u0027, \u0027SET\u0027, \u0027SHOW\u0027, \u0027START\u0027, \u0027TABLE\u0027, \u0027EXECUTE\u0027, \u0027TRUNCATE\u0027, \u0027UNCACHE\u0027, \u0027UNLOCK\u0027, \u0027UPDATE\u0027, \u0027USE\u0027, \u0027VALUES\u0027, \u0027WITH\u0027}"
}
}
Expectation return 400 validation exception
[Catch All Triage - 1, 2, 3]