[BUG]PG 多维数组的SQL，进行解析或者格式化时报错

[lovesdo79]

Database Type

PG

Database Version

PG10.5

Druid Version

1.2.23

JDK Version

JDK8

Error SQL

SELECT outer_content_v2_125_voc_order_rate.rate_tags AS "rate_tags#1_T334960", count(DISTINCT outer_content_v2_125_voc_order_rate.id) AS "id_T334960_count_distinct" FROM (SELECT unnest(rate_tags[1:][1:1]) AS rate_tags, id FROM (SELECT rate_tags, id FROM content_v2_125.voc_order_rate) AS inter_content_v2_125_voc_order_rate) AS outer_content_v2_125_voc_order_rate GROUP BY outer_content_v2_125_voc_order_rate.rate_tags ORDER BY outer_content_v2_125_voc_order_rate.rate_tags DESC NULLS LAST LIMIT 12

Testcase Code

PGSelectStatement pgSelectStatement = new PGSQLStatementParser(adapterParam.getSelectSqlStr()).parseSelect();

    log.info("最终生成SQL \n{}\n最终生成CountSQL \n{}", SQLUtils.format(adapterParam.getSelectSqlStr(), DbType.postgresql), SQLUtils.format(adapterParam.getAdsCountSql(), DbType.postgresql));

Stacktrace Info

No response

Error Info

com.alibaba.druid.sql.parser.ParserException: syntax error, expect ], actual VARIANT pos 197, line 1, column 197, token VARIANT
at com.alibaba.druid.sql.parser.SQLExprParser.accept(SQLExprParser.java:4783) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGExprParser.primaryRest(PGExprParser.java:217) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:1419) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGExprParser.primary(PGExprParser.java:163) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLExprParser.expr(SQLExprParser.java:111) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLExprParser.exprList(SQLExprParser.java:2335) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLExprParser.methodRest(SQLExprParser.java:1981) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLExprParser.parseSelectItem(SQLExprParser.java:6489) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLSelectParser.parseSelectList(SQLSelectParser.java:1079) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGSelectParser.query(PGSelectParser.java:105) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:62) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLSelectParser.parseTableSource(SQLSelectParser.java:1132) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLSelectParser.parseFrom(SQLSelectParser.java:1122) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGSelectParser.query(PGSelectParser.java:131) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:62) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGSQLStatementParser.parseSelect(PGSQLStatementParser.java:539) ~[druid-1.2.23.jar:?]
at com.bytenew.bi.brain.service.dashboard.app.common.CalculateServiceV2.sqlPostProcess(CalculateServiceV2.java:3758) ~[classes/:?]
at com.bytenew.bi.brain.service.dashboard.app.common.CalculateServiceV2.myChartNew(CalculateServiceV2.java:189) ~[classes/:?]
at com.bytenew.bi.brain.service.dashboard.app.impl.ReportAppServiceImpl.makeReportForEdit1(ReportAppServiceImpl.java:629) ~[classes/:?]
at com.bytenew.bi.brain.service.dashboard.app.impl.ReportAppServiceImpl.makeReportForEdit(ReportAppServiceImpl.java:697) ~[classes/:?]
at com.bytenew.bi.brain.service.dashboard.impl.UiServiceImpl.datan(UiServiceImpl.java:350) ~[classes/:?]
at com.bytenew.bi.brain.controller.UiController.datan(UiController.java:90) ~[classes/:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_401]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_401]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_401]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_401]
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:878) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) ~[tomcat-embed-core-9.0.41.jar:4.0.FR]
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) ~[spring-webmvc-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[tomcat-embed-core-9.0.41.jar:4.0.FR]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) ~[tomcat-embed-websocket-9.0.41.jar:9.0.41]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at com.banniuyun.work.common.isolation.web.IsolationWebFilter.doFilter(IsolationWebFilter.java:25) ~[op-common-isolation-1.0-20241126.084619-8.jar:1.0-SNAPSHOT]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at com.banniuyun.work.common.isolation.web.IsolationWebTraceFilter.doFilter(IsolationWebTraceFilter.java:32) ~[op-common-isolation-1.0-20241126.084619-8.jar:1.0-SNAPSHOT]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at com.banniuyun.work.common.dubbo.filter.MDCTraceFilter.doFilter(MDCTraceFilter.java:49) ~[op-common-dubbo-1.0-20241015.071640-21.jar:1.0-SNAPSHOT]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at javax.servlet.http.HttpFilter.doFilter(HttpFilter.java:97) ~[tomcat-embed-core-9.0.41.jar:4.0.FR]
at com.bytenew.bff.common.web.filter.SessionFilter.doFilter(SessionFilter.java:91) ~[bff-common-web-1.1-20230526.143924-2.jar:1.1-SNAPSHOT]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:93) ~[spring-boot-actuator-2.3.7.RELEASE.jar:2.3.7.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at com.bytenew.actuator.custom.rest.RequestTimeLogFilter.doFilterInternal(RequestTimeLogFilter.java:38) ~[custom-actuator-2.0.1-20241009.082409-23.jar:?]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) ~[spring-web-5.2.12.RELEASE.jar:5.2.12.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:374) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) ~[?:1.8.0_401]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) ~[?:1.8.0_401]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) ~[tomcat-embed-core-9.0.41.jar:9.0.41]
at java.lang.Thread.run(Thread.java:750) ~[?:1.8.0_401]

[lovesdo79]

尝试了一下，用Druid执行这个SQL也报错：

Caused by: java.sql.SQLException: sql injection violation, dbType postgresql, , druid-version 1.2.23, syntax error: syntax error, expect ], actual VARIANT pos 197, line 1, column 197, token VARIANT : SELECT outer_content_v2_125_voc_order_rate.rate_tags AS "rate_tags#1_T334960", count(DISTINCT outer_content_v2_125_voc_order_rate.id) AS "id_T334960_count_distinct" FROM (SELECT unnest(rate_tags[1:][1:1]) AS rate_tags, id FROM (SELECT rate_tags, id FROM content_v2_125.voc_order_rate) AS inter_content_v2_125_voc_order_rate) AS outer_content_v2_125_voc_order_rate GROUP BY outer_content_v2_125_voc_order_rate.rate_tags ORDER BY outer_content_v2_125_voc_order_rate.rate_tags DESC NULLS LAST LIMIT 12
at com.alibaba.druid.wall.WallFilter.checkInternal(WallFilter.java:876) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:318) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:547) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:908) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:116) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:547) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:328) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:369) ~[druid-1.2.23.jar:?]
at com.banniuyun.work.dynamic.datasource.core.connection.AbstractConnection.prepareStatement(AbstractConnection.java:25) ~[banniu-dynamic-datasource-core-1.0-20230629.070404-71.jar:1.0-SNAPSHOT]
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:87) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.5.6.jar:3.5.6]
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:141) ~[pagehelper-5.0.0.jar:?]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.6.jar:3.5.6]
at com.sun.proxy.$Proxy267.query(Unknown Source) ~[?:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_401]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_401]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_401]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_401]
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) ~[mybatis-3.5.6.jar:3.5.6]
at com.banniuyun.work.dynamic.datasource.interceptor.DynamicDataSourceInterceptor.intercept(DynamicDataSourceInterceptor.java:186) ~[banniu-dynamic-datasource-routing-1.0-20230629.070538-101.jar:1.0-SNAPSHOT]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.6.jar:3.5.6]
at com.sun.proxy.$Proxy267.query(Unknown Source) ~[?:?]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.6.jar:3.5.6]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_401]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_401]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_401]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_401]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) ~[mybatis-spring-2.0.5.jar:2.0.5]
... 24 more
Caused by: com.alibaba.druid.sql.parser.ParserException: syntax error, expect ], actual VARIANT pos 197, line 1, column 197, token VARIANT
at com.alibaba.druid.sql.parser.SQLExprParser.accept(SQLExprParser.java:4783) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGExprParser.primaryRest(PGExprParser.java:217) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLExprParser.primary(SQLExprParser.java:1419) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGExprParser.primary(PGExprParser.java:163) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLExprParser.expr(SQLExprParser.java:111) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLExprParser.exprList(SQLExprParser.java:2335) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLExprParser.methodRest(SQLExprParser.java:1981) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLExprParser.parseSelectItem(SQLExprParser.java:6489) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLSelectParser.parseSelectList(SQLSelectParser.java:1079) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGSelectParser.query(PGSelectParser.java:105) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:62) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLSelectParser.parseTableSource(SQLSelectParser.java:1132) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLSelectParser.parseFrom(SQLSelectParser.java:1122) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGSelectParser.query(PGSelectParser.java:131) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLSelectParser.select(SQLSelectParser.java:62) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGSQLStatementParser.parseSelect(PGSQLStatementParser.java:539) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.dialect.postgresql.parser.PGSQLStatementParser.parseSelect(PGSQLStatementParser.java:31) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:233) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:117) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.wall.WallProvider.checkInternal(WallProvider.java:494) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.wall.WallProvider.check(WallProvider.java:446) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.wall.WallFilter.checkInternal(WallFilter.java:853) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:318) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:547) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:908) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:116) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:547) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:328) ~[druid-1.2.23.jar:?]
at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:369) ~[druid-1.2.23.jar:?]
at com.banniuyun.work.dynamic.datasource.core.connection.AbstractConnection.prepareStatement(AbstractConnection.java:25) ~[banniu-dynamic-datasource-core-1.0-20230629.070404-71.jar:1.0-SNAPSHOT]
at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:87) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.5.6.jar:3.5.6]
at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:141) ~[pagehelper-5.0.0.jar:?]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.6.jar:3.5.6]
at com.sun.proxy.$Proxy267.query(Unknown Source) ~[?:?]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_401]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_401]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_401]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_401]
at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) ~[mybatis-3.5.6.jar:3.5.6]
at com.banniuyun.work.dynamic.datasource.interceptor.DynamicDataSourceInterceptor.intercept(DynamicDataSourceInterceptor.java:186) ~[banniu-dynamic-datasource-routing-1.0-20230629.070538-101.jar:1.0-SNAPSHOT]
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) ~[mybatis-3.5.6.jar:3.5.6]
at com.sun.proxy.$Proxy267.query(Unknown Source) ~[?:?]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147) ~[mybatis-3.5.6.jar:3.5.6]
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.6.jar:3.5.6]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_401]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_401]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_401]
at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_401]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426) ~[mybatis-spring-2.0.5.jar:2.0.5]
... 24 more