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

[Bug] TDengine数据库分页查询,count关键词报错 #772

Open
QingShan512 opened this issue Oct 18, 2024 · 2 comments
Open

[Bug] TDengine数据库分页查询,count关键词报错 #772

QingShan512 opened this issue Oct 18, 2024 · 2 comments

Comments

@QingShan512
Copy link

APIJSON Version/APIJSON 版本号

7.0.3

Database Type & Version/数据库类型及版本号

TDengine3

Environment/环境信息

- JDK/基础库: 17
- OS/系统:

APIAuto Screenshots/APIAuto 请求与结果完整截屏

TDengine ERROR (0x2600): sql

Current Behavior/问题描述

修改了apijson.SQL 265行,给count加上了``; return function(fun, column) + AS + "`" + fun + "` ";

这样会对其他方面有影响吗?

Expected Behavior/期望结果

正常查询 TDengine 数据

Any additional comments?/其它补充说明?

No response

@TommyLemon
Copy link
Collaborator

Oracle,PostgreSQL,SQLServer 等需要双引号,可以在 AbstractSQLExecutor 传 getQuote 的值给 SQL.functionAs 函数(加个 quote 参数)用来拼接

@QingShan512
Copy link
Author

收到,谢谢

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

No branches or pull requests

2 participants