2020-10-25 21:15:44.326 ERROR com.pc.data.dataqualitycheck.async.AsyncQalityCheckService Line:244 - 'length' is not a recognized built-in function name. java.sql.SQLException: 'length' is not a recognized built-in function name. at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372) at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988) at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421) at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671) at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505) at net.sourceforge.jtds.jdbc.JtdsStatement.executeQuery(JtdsStatement.java:1427) at com.pc.data.dataqualitycheck.async.AsyncQalityCheckService.insertProblem(AsyncQalityCheckService.java:478) at com.pc.data.dataqualitycheck.async.AsyncQalityCheckService.performCheckRules(AsyncQalityCheckService.java:241) at com.pc.data.dataqualitycheck.async.AsyncQalityCheckService.executeQalityCheckAsync(AsyncQalityCheckService.java:101) at com.pc.data.dataqualitycheck.async.AsyncQalityCheckService$$FastClassBySpringCGLIB$$7e349c9.invoke() at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:115) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745)
RulesGenerator中281行length改为len即可，sql2003标准
