Closed
Description
select count(*)
from information_schema.columns
where table_name = 'extend_value_info'
and column_name = 'extend_value_str'
and table_schema = DATABASE();throws:
Caused by: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "=" "="
at line 5, column 28.
Was expecting one of:
"&"
"::"
";"
"<<"
">>"
"COLLATE"
"CONNECT"
"EMIT"
"GROUP"
"HAVING"
"START"
"["
"^"
"|"
<EOF>
at net.sf.jsqlparser.parser.CCJSqlParser.generateParseException(CCJSqlParser.java:33398) ~[jsqlparser-4.5.jar:na]
at net.sf.jsqlparser.parser.CCJSqlParser.jj_consume_token(CCJSqlParser.java:33231) ~[jsqlparser-4.5.jar:na]
at net.sf.jsqlparser.parser.CCJSqlParser.Statement(CCJSqlParser.java:167) ~[jsqlparser-4.5.jar:na]
at net.sf.jsqlparser.parser.CCJSqlParserManager.parse(CCJSqlParserManager.java:23) ~[jsqlparser-4.5.jar:na]
... 54 common frames omitted
Is there any workround?
I try to around the DATABASE with "``" like this:
select count(*)
from information_schema.columns
where table_name = 'extend_value_info'
and column_name = 'extend_value_str'
and table_schema = `DATABASE()`;Then mysql can't parse it.
Metadata
Metadata
Assignees
Labels
No labels