search

nacos-group / nacos-plugin

A collection of Nacos plug-ins, providing Nacos with pluggable plug-in capabilities, support for user customization and high scalability
Apache License 2.0
114 stars 75 forks source link

Oracle Mapper中Sql错误 #52

Open 4innocent opened 2 months ago

4innocent commented 2 months ago

在HistoryConfigInfoMapperOracle文件中有这样一段sql DELETE FROM his_config_info WHERE ROWID in (SELECT ROWID FROM his_config_info WHERE gmt_modified < ? FETCH FIRST ? ROWS ONLY)

这段sql在oracle中执行不了啊，oracle不支持FETCH FIRST ? ROWS ONLY这种用法，给我整无语了。。。

HelloSSM commented 1 month ago

这个应该是你oracle的版本问题，我用的oracle 19c，这个版本是有这个语法的