Question 1: client navicat use SQL query, to call SQL queries, or project operation ( the execution result is right ) error
Navicat error message:
(Err), 1064 - You have an error in your SQL syntax; Check the manual that corresponds to your MySQL server version for the right syntax to use near '/* 100, 3), the' % ') AS ` Percentage ` FROM INFORMATION_SCHEMA. PROFILING the WHERE QUERY_ID='at line 1
Check the logs/router. The log
2017-07-31 16:12:10, 679 ERROR route. AbstractQueryRouter - SELECT the STATE AS ` Status `, ROUND (SUM (DURATION), 7) AS ` DURATION `, CONCAT (ROUND (SUM (DURATION)/* 100, 3), the '%') AS ` Percentage ` FROM INFORMATION_SCHEMA. PROFILING the WHERE QUERY_ID=GROUP BY the STATE ORDER BY SEQ.
Com. Meidusa. Amoeba. Parser. ParseException: com. Meidusa. Amoeba. Mysql. The parser. SQL. ParseException: Encountered "*" at line 1, column 92.
The Was expecting one of:
"CASE"...
"CAST"...
"NULL"...
"TRUE"...
"FALSE"...
"INTERVAL".... "("...
"`"...
"+"...
"-"....
"`"....
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. DoParse (MysqlParser. Java: 117)
At com. Meidusa. Amoeba. Route. SqlBaseQueryRouter. ParseStatement (SqlBaseQueryRouter. Java: 138)
At com. Meidusa. Amoeba. Route. SqlBaseQueryRouter. EvaluateTable (SqlBaseQueryRouter. Java: 50)
At com. Meidusa. Amoeba. Route. SqlBaseQueryRouter. EvaluateTable (SqlBaseQueryRouter. Java: 1)
At com. Meidusa. Amoeba. Route. AbstractQueryRouter. Evaluate (AbstractQueryRouter. Java: 136)
At com. Meidusa. Amoeba. Route. AbstractQueryRouter. SelectPool (AbstractQueryRouter. Java: 411)
At com. Meidusa. Amoeba. Mysql. Parser. MysqlQueryRouter. SelectPool (MysqlQueryRouter. Java: 59)
At com. Meidusa. Amoeba. Mysql. Parser. MysqlQueryRouter. SelectPool (MysqlQueryRouter. Java: 1)
At com. Meidusa. Amoeba. Route. AbstractQueryRouter. DoRoute (AbstractQueryRouter. Java: 111)
At com. Meidusa. Amoeba. Mysql. Handler. MySqlCommandDispatcher. HandleQueryCommandMessage (MySqlCommandDispatcher. Java: 98)
At com. Meidusa. Amoeba. Mysql. Handler. MySqlCommandDispatcher $1. The run (MySqlCommandDispatcher. Java: 242)
The at Java. Util. Concurrent. ThreadPoolExecutor. RunWorker (ThreadPoolExecutor. Java: 1142)
The at Java. Util. Concurrent. ThreadPoolExecutor $Worker. The run (ThreadPoolExecutor. Java: 617)
The at Java. Lang. Thread. The run (Thread. Java: 745)
Under Caused by: com. Meidusa. Amoeba. Mysql. Parser. SQL. ParseException: Encountered "*" at line 1, column 92.
The Was expecting one of:
"CASE"...
"CAST"...
"NULL"...
"TRUE"...
"FALSE"...
"INTERVAL".... "("...
"`"...
"+"...
"-"....
"`"....
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. GenerateParseException (MysqlParser. Java: 5848)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. Jj_consume_token (MysqlParser. Java: 5718)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. SQLPrimaryExpression (MysqlParser. Java: 3305)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. SQLUnaryExpression (MysqlParser. Java: 3106)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. SQLMultiplicativeExpression (MysqlParser. Java: 3061)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. SQLAddSubtractExpression (MysqlParser. Java: 2964)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. SQLSimpleExpression (MysqlParser. Java: 2953)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. SQLExpressionList (MysqlParser. Java: 2746)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. FunctionCall (MysqlParser. Java: 3359)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. SQLPrimaryExpression (MysqlParser. Java: 3291)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. SQLUnaryExpression (MysqlParser. Java: 3106)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. SQLMultiplicativeExpression (MysqlParser. Java: 3025)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. SQLAddSubtractExpression (MysqlParser. Java: 2964)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. SQLSimpleExpression (MysqlParser. Java: 2953)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. OverloadedFunctionCall (MysqlParser. Java: 3452)
At com. Meidusa. Amoeba. Mysql. Parser. SQL. MysqlParser. SQLPrimaryExpression (MysqlParser. Java: 3276)
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull