APIJSON icon indicating copy to clipboard operation
APIJSON copied to clipboard

[Bug] SQLServer中,使用正则匹配,语法错误

Open zdf321 opened this issue 9 months ago • 1 comments

APIJSON Version/APIJSON 版本号

8.0.0.3

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

SqlServer2022

Environment/环境信息

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

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

https://img.picui.cn/free/2025/05/06/68196cf5c01d7.png

Current Behavior/问题描述

SqlServer中的正则查询不支持REGEXP关键字

Expected Behavior/期望结果


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


zdf321 avatar May 06 '25 02:05 zdf321

@zdf321 gainRegExpString 和 isPresto() || isTrino() 一样判断 isSQLServer() ,使用对应的 regexp_like

https://github.com/Tencent/APIJSON/blob/master/APIJSONORM/src/main/java/apijson/orm/AbstractSQLConfig.java#L4263-L4295

Image

https://learn.microsoft.com/en-us/sql/t-sql/functions/regexp-like-transact-sql?view=azuresqldb-current Image

改好后给 APIJSON 提交 PR 贡献,谢谢,开源要大家一起参与贡献才会更美好~ image

提 PR 贡献代码的步骤可参考: https://github.com/Tencent/APIJSON/blob/master/CONTRIBUTING.md#%E4%B8%BA%E4%BB%80%E4%B9%88%E4%B8%80%E5%AE%9A%E8%A6%81%E8%B4%A1%E7%8C%AE%E4%BB%A3%E7%A0%81

TommyLemon avatar May 10 '25 14:05 TommyLemon