Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] Internal server error on incorrect syntax #3058

Open
noCharger opened this issue Oct 8, 2024 · 1 comment
Open

[BUG] Internal server error on incorrect syntax #3058

noCharger opened this issue Oct 8, 2024 · 1 comment
Labels
bug Something isn't working catch-all acknowledged Marks issues caught in catch-all triage for searchability

Comments

@noCharger
Copy link
Collaborator

noCharger commented Oct 8, 2024

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

@noCharger noCharger added bug Something isn't working untriaged labels Oct 8, 2024
@dblock dblock removed the untriaged label Oct 28, 2024
@dblock
Copy link
Member

dblock commented Oct 28, 2024

[Catch All Triage - 1, 2, 3]

@Swiddis Swiddis added the catch-all acknowledged Marks issues caught in catch-all triage for searchability label Jan 7, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working catch-all acknowledged Marks issues caught in catch-all triage for searchability
Projects
None yet
Development

No branches or pull requests

3 participants