dianbaiyizhong opened a new pull request, #14273: URL: https://github.com/apache/dolphinscheduler/pull/14273
版本：3.1.7 报错截图：  报错异常日志 ``` Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "SELECT a.id,\000a a.field,\000a a.type,\000a a.title,\000a a.[*]value,\000a a.options,\000a a.placeholder,\000a a.option_source_type,\000a a.value_type,\000a a.input_type,\000a a.is_show,\000a a.can_edit,\000a a.is_emit,\000a a.is_validate,\000a b.values_map,\000a b.index\000a FROM t_ds_dq_rule_input_entry a join ( SELECT *\000a FROM t_ds_relation_rule_input_entry where rule_id = ? ) b\000a on a.id = b.rule_input_entry_id order by b.index"; expected "identifier"; SQL statement: SELECT a.id, a.field, a.type, a.title, a.value, a.options, a.placeholder, a.option_source_type, a.value_type, a.input_type, a.is_show, a.can_edit, a.is_emit, a.is_validate, b.values_map, b.index FROM t_ds_dq_rule_input_entry a join ( SELECT * FROM t_ds_relation_rule_input_entry where rule_id = ? ) b on a.id = b.rule_input_entry_id order by b.index [42001-210] at org.h2.message.DbException.getJdbcSQLException(DbException.java:521) at org.h2.message.DbException.getJdbcSQLException(DbException.java:496) at org.h2.message.DbException.getSyntaxError(DbException.java:265) at org.h2.command.Parser.readIdentifier(Parser.java:5759) at org.h2.command.Parser.readTermObjectDot(Parser.java:4882) at org.h2.command.Parser.readTerm(Parser.java:5201) at org.h2.command.Parser.readFactor(Parser.java:3423) at org.h2.command.Parser.readSum(Parser.java:3410) at org.h2.command.Parser.readConcat(Parser.java:3375) at org.h2.command.Parser.readCondition(Parser.java:3160) at org.h2.command.Parser.readExpression(Parser.java:3076) at org.h2.command.Parser.parseSelectExpressions(Parser.java:2876) at org.h2.command.Parser.parseSelect(Parser.java:2893) at org.h2.command.Parser.parseQueryPrimary(Parser.java:2783) at org.h2.command.Parser.parseQueryTerm(Parser.java:2650) at org.h2.command.Parser.parseQueryExpressionBody(Parser.java:2629) at org.h2.command.Parser.parseQueryExpressionBodyAndEndOfQuery(Parser.java:2622) at org.h2.command.Parser.parseQueryExpression(Parser.java:2615) at org.h2.command.Parser.parseQuery(Parser.java:2576) at org.h2.command.Parser.parsePrepared(Parser.java:707) at org.h2.command.Parser.parse(Parser.java:674) at org.h2.command.Parser.parse(Parser.java:644) at org.h2.command.Parser.prepareCommand(Parser.java:551) at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:615) at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:553) at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116) at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92) at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288) at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337) at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java) at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:86) at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88) at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59) at sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy236.prepare(Unknown Source) at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:87) at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62) at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62) at com.sun.proxy.$Proxy235.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) at sun.reflect.GeneratedMethodAccessor205.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427) ... 81 common frames omitted ``` 触发场景： 在使用默认的h2作为数据源启动下，拖入数据质量的时候会触发 ## Purpose of the pull request 我使用了反括号方式将value关键字括起来 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
