Fails to run EXPLAIN query in SQL editor: Please check if the statement is correct

[yidoa]

数据库版本：MySQL57
平台版本:v0.11.0
部署方式：二进制部署
操作：
在 SQL editor 里面：
explain select * from abc;
报错：Please check if the statement is correct

[tianzhou]

We need to address it in both frontend and backend to whitelist EXPLAIN. @boojack PTAL

[xiaoluoboding]

@tianzhou @boojack maybe we do not need to validate the SQL statement is correct or not. pass the statement to the back-end. At the front-end, we only validate the query is a SELECT statement or not.

[tianzhou]

@xiaoluoboding

For frontend, I think do a simple validation to check whether it's SELECT or EXPLAIN SELECT is sufficient.

[boojack]

@xiaoluoboding @tianzhou This failure is because of the frontend package node-sql-parser will throw an SyntaxError with statement explain select * from abc which is correct. And I think maybe using the simple regex is more efficient than node-sql-parser in this situation.

[xiaoluoboding]

@boojack just remove isValidStatement function, will be fine. I use the noe-sql-parser to parse the SQL statement, in case we want to use the more info of the query. If we really does not need it. We can remove it.

[xiaoluoboding]

Already fixed in the latest version v0.12.0