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

缺陷修复pgsql不支持“·“”号 #12631

Closed
floor07 opened this issue Sep 10, 2024 · 6 comments
Closed

缺陷修复pgsql不支持“·“”号 #12631

floor07 opened this issue Sep 10, 2024 · 6 comments
Labels
status/duplicate This issue or pull request already exists

Comments

@floor07
Copy link
Contributor

floor07 commented Sep 10, 2024

caused: PreparedStatementCallback; bad SQL grammar
[SELECT id,quota,usage,max_size,max_aggr_count,max_aggr_size,tenant_id FROM tenant_capacity
WHERE tenant_id = ?]; nested exception is org.postgresql.util.PSQLException:
错误: 操作符不存在: integer 建议:没有匹配指定名称和参数类型的操作符. 您也许需要增加明确的类型转换. 位置:17;caused: 错误: 操作符不存在: integer 建议:没有匹配指定名称和参数类型的操作符. 您也许需要增加明确的类型转换.
位置:17;

@floor07
Copy link
Contributor Author

floor07 commented Sep 10, 2024

@i will slove it

@fuhouyu
Copy link
Contributor

fuhouyu commented Sep 10, 2024

这个昨天提交了PR #12628
如果去除,由于usage`为Mysql关键字,在数据源为Mysql的情况下,会有SQL问题。

@huangkemingyyds
Copy link
Contributor

这个应该要对pgsql 插件中修复这个问题

@KomachiSion
Copy link
Collaborator

我测试mysql没有问题啊, pg的问题请使用nacos-group/nacos-plugin中的pg插件重试,如果也有方言问题,请在pg插件中修复。

@KomachiSion
Copy link
Collaborator

我查了一下, 应该是传给插件的字段名有问题

@KomachiSion
Copy link
Collaborator

duplicate with #12625

@KomachiSion KomachiSion closed this as not planned Won't fix, can't repro, duplicate, stale Sep 10, 2024
@KomachiSion KomachiSion added status/duplicate This issue or pull request already exists and removed kind/bug Category issues or prs related to bug. plugin labels Sep 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
status/duplicate This issue or pull request already exists
Projects
None yet
Development

No branches or pull requests

4 participants