Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

nacos 2.2.3 版本查询配置文件历史版本接口的sql不支持postgresql #683

Open
badboyonlyme opened this issue Jun 5, 2024 · 2 comments

Comments

@badboyonlyme
Copy link

在使用nacos 2.2.3版本时,将默认的MySQL数据库改为了postgresql数据库。
遇到了一个问题,在查询某个配置文件的历史版本时(这个配置文件确认有历史版本),分页查询报错,原因是sql格式后半部分是 select xxxxx limit 0,10 这样postgresql数据库不支持,其只支持 limit 10 offset 0 有什么解决方案吗?

@badboyonlyme
Copy link
Author

忘记说了,如果查询的配置文件没有历史版本,就不会报错。

@jiangzanzan
Copy link

忘记说了,如果查询的配置文件没有历史版本,就不会报错。

请问你有解决这个问题吗

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants