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

uliweb-apijson的group,sum等功能不生效 #12

Open
zhaoxii opened this issue Apr 8, 2022 · 3 comments
Open

uliweb-apijson的group,sum等功能不生效 #12

zhaoxii opened this issue Apr 8, 2022 · 3 comments
Assignees

Comments

@zhaoxii
Copy link

zhaoxii commented Apr 8, 2022

image

@zhaoxii
Copy link
Author

zhaoxii commented Apr 8, 2022

image

image

image

这是我的一些配置

@zhangchunlin
Copy link
Owner

会对apijson的配置做一个总体的review和评估: https://gitee.com/Tencent/APIJSON/blob/master/Document.md
估计不会那么快能完成。

@zhangchunlin zhangchunlin self-assigned this Apr 11, 2022
@TommyLemon
Copy link
Contributor

TommyLemon commented Apr 12, 2022

涉及 SQL 函数嵌套的地方,解析成对的括号和引号(单引号、反引号)很复杂。
Java 版为了保证安全的前提下解析简单,目前只支持单层 SQL 函数(除了固定的 now(),不能内部嵌套其它 SQL 函数),
另外分隔 SQL 函数时使用了分号 ";" 而不是 SQL 标准的逗号 ","。

另外为了安全,SQL 函数只支持 SQL_FUNTION_MAP 配置了的 450 个左右,避免 sleep 等破坏性 SQL 函数被触发
https://github.com/Tencent/APIJSON/blob/master/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java#L266-L729

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

3 participants