postgreSQL为数据源的情况下，sql解析出现报错日志

[Somewhere977]

问题sql示例：
select * from user where column_2 = E'123456';
字段column_2为varchar，这种带E的语法，postgreSQL是支持的，用以指示 PostgreSQL 解析器接下来的字符串应该按 C 风格的字符串字面量来处理，即允许使用反斜杠（\）作为转义字符
日志堆栈如下：
com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'2 = E'123456'
order by ', expect RPAREN, actual LITERAL_CHARS pos 2259, line 5, column 904, token LITERAL_CHARS 213131
at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:284) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:292) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.sql.parser.SQLSelectParser.parseTableSource(SQLSelectParser.java:676) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.sql.parser.SQLSelectParser.parseFrom(SQLSelectParser.java:666) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGSelectParser.query(PGSelectParser.java:134) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:59) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGSQLStatementParser.parseSelect(PGSQLStatementParser.java:331) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGSQLStatementParser.parseSelect(PGSQLStatementParser.java:40) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:149) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:72) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:94) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:77) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:50) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:147) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.filter.stat.StatFilter.createSqlStat(StatFilter.java:648) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.filter.stat.StatFilter.statementPrepareAfter(StatFilter.java:311) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:124) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:568) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:342) ~[druid-1.1.12.jar!/:1.1.12]
at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:349) ~[druid-1.1.12.jar!/:1.1.12]
at com.banniuyun.work.dynamic.datasource.core.connection.AbstractConnection.prepareStatement(AbstractConnection.java:25) ~[banniu-dynamic-datasource-core-1.0-SNAPSHOT.jar!/:1.0-SNAPSHOT]

[lizongbo]

你使用的版本过低，请升级版本到 1.2.23,早就支持了。