dianbaiyizhong opened a new pull request, #14274: URL: https://github.com/apache/dolphinscheduler/pull/14274
### version：3.1.7 ### error capture picture：  ### error log message ``` 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 ``` ### my advise ``` I think the field 'value' is a keyword, which is not supported in h2; so you can use the method of back brackets, such as `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]
