H2数据库 Merge 语法解析异常

2017-09-01 20:12:08 INFO [com.alibaba.druid.pool.DruidDataSource] com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:854)- {dataSource-1} inited 2017-09-01 20:12:08 DEBUG [org.springframework.jdbc.core.JdbcTemplate] org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:505)- Executing SQL update [merge into person key(id) select * from person_test] 2017-09-01 20:12:08 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:110)- Fetching JDBC Connection from DataSource 2017-09-01 20:12:09 ERROR [com.alibaba.druid.filter.stat.StatFilter] com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:148)- merge sql error, dbType h2, sql : merge into person key(id) select * from person_test com.alibaba.druid.sql.parser.ParserException: syntax error, error in :'erge into person key(id) select * f',expect IDENTIFIER, actual IDENTIFIER pos 5, line 1, column 6, token IDENTIFIER into at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:280) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:385) at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:78) at com.alibaba.druid.sql.visitor.ParameterizedOutputVisitorUtils.parameterize(ParameterizedOutputVisitorUtils.java:43) at com.alibaba.druid.filter.stat.StatFilter.mergeSql(StatFilter.java:146) at com.alibaba.druid.filter.stat.StatFilter.createSqlStat(StatFilter.java:634) at com.alibaba.druid.filter.stat.StatFilter.internalBeforeStatementExecute(StatFilter.java:402) at com.alibaba.druid.filter.stat.StatFilter.statementExecuteUpdateBefore(StatFilter.java:330) at com.alibaba.druid.filter.FilterEventAdapter.statement_executeUpdate(FilterEventAdapter.java:324) at com.alibaba.druid.filter.FilterChainImpl.statement_executeUpdate(FilterChainImpl.java:2486) at com.alibaba.druid.proxy.jdbc.StatementProxyImpl.executeUpdate(StatementProxyImpl.java:241) at com.alibaba.druid.pool.DruidPooledStatement.executeUpdate(DruidPooledStatement.java:243) at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:509) at org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:1) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:519) at nari.test.redisson.DuridH2Test.executeNonQuery(DuridH2Test.java:48) at nari.test.redisson.DuridH2Test.main(DuridH2Test.java:56) 2017-09-01 20:12:09 DEBUG [org.springframework.jdbc.core.JdbcTemplate] org.springframework.jdbc.core.JdbcTemplate$1UpdateStatementCallback.doInStatement(JdbcTemplate.java:511)- SQL update affected 8 rows 2017-09-01 20:12:09 DEBUG [org.springframework.jdbc.datasource.DataSourceUtils] org.springframework.jdbc.datasource.DataSourceUtils.doReleaseConnection(DataSourceUtils.java:332)- Returning JDBC Connection to DataSource

原提问者GitHub用户godsmell