SELECT
REGEXP_SUBSTR( '407,81,72', '[^,]+', 1, LEVEL, 'i' )
FROM
DUAL CONNECT BY LEVEL <= ( LENGTH( '407,81,72' ) - LENGTH( REGEXP_REPLACE( '407,81,72', ',', '' ) ) + 1 )
栈信息：
version: 2016-12-30 11:09:37
packageinfo: Branch_SmartbiV62_20161124
表达式解析错误:expecting STRING_LITERAL, found ','
at line:1 column:57
SELECT
REGEXP_SUBSTR( ^P_PARAM.HS_ISSUE_ETC.ids^ , '[^,]+', 1, LEVEL, 'i' )
FROM
DUAL CONNECT BY LEVEL <= ( LENGTH( ^P_PARAM.HS_ISSUE_ETC.ids^ )
- LENGTH( REGEXP_REPLACE( ^P_PARAM.HS_ISSUE_ETC.ids^ , ',', '' ) ) + 1 )
at smartbi.freequery.expression.antlr.ExpressionParser.reportError(ExpressionParser.java:42)
at ...(...)
at smartbi.freequery.expression.antlr.ExpressionParser.specialItem(ExpressionParser.java:574)
Caused by: line 1:57: expecting STRING_LITERAL, found ','
at antlr.Parser.match(Parser.java:211)
at smartbi.freequery.expression.antlr.ExpressionParser.specialItem(ExpressionParser.java:574)
at smartbi.freequery.expression.antlr.ExpressionParser.specialNodes(ExpressionParser.java:337)
at smartbi.freequery.expression.antlr.ExpressionParser.textNodes(ExpressionParser.java:301)
at smartbi.freequery.expression.antlr.ExpressionParser.specialNodes(ExpressionParser.java:361)
at smartbi.freequery.expression.antlr.ExpressionParser.textNodes(ExpressionParser.java:301)
at smartbi.freequery.expression.antlr.ExpressionParser.parseNode(ExpressionParser.java:119)
at smartbi.freequery.expression.antlr.ExpressionParser.parse(ExpressionParser.java:81)
at smartbi.freequery.expression.ExpressionBuilder.parseExpression(ExpressionBuilder.java:24)
at smartbi.freequery.expression.Expression.<init>(Expression.java:132)
at smartbi.freequery.metadata.TextQuery.splitExp(TextQuery.java:99)
at smartbi.freequery.metadata.TextQuery.setExpressionText(TextQuery.java:165)
at smartbi.freequery.metadata.BusinessViewBO.setTextQueryValue(BusinessViewBO.java:1082)
at smartbi.freequery.client.businessview.BusinessViewService.setTextQueryValue(BusinessViewService.java:282)
at sun.reflect.GeneratedMethodAccessor581.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at smartbi.framework.rmi.ClientService.execute(Smartbi:118)
at smartbi.framework.rmi.RMIServlet.processExecute(RMIServlet.java:195)
at smartbi.framework.rmi.RMIServlet.doPost(RMIServlet.java:140)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at smartbi.extension.ExtensionFilter$2.doFilter(ExtensionFilter.java:134)
at smartbi.extension.ExtensionFilter$1.doFilter(ExtensionFilter.java:123)
at smartbi.extension.ExtensionFilter.doFilterInternal(ExtensionFilter.java:146)
at smartbi.extension.ExtensionFilter.doFilter(ExtensionFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at smartbi.framework.rmi.TransactionFilter.doFilter(Smartbi:93)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at smartbi.freequery.filter.GZIPFilter.doFilter(GZIPFilter.java:111)
at smartbi.freequery.filter.Filter.doFilter(Filter.java:36)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at smartbi.freequery.filter.CheckIsLoggedFilter.doFilter(CheckIsLoggedFilter.java:99)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:748)
|
