为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:8
【操作系统】:linux
【CPU】:8
【问题描述】*:执行批量插入sql时,报Too many nested levels
达梦数据库配置的是兼容Oracle,批量插入sql如下:
insert into station_func_temp (id, station_id, func_id) select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual union all select ?, ?, ? from dual…
如果只有几个union all的时候,批量新增的sql是可以执行的,不会报错
报错信息:
2022-08-19T06:18:37.815545109Z org.springframework.dao.DataIntegrityViolationException:
2022-08-19T06:18:37.815547898Z ### Error updating database. Cause: dm.jdbc.driver.DMException: Error in line: 3510
2022-08-19T06:18:37.815550018Z Too many nested levels
适当调大参数N_PARSE_LEVEL