DBD::SQLite: implement REGEXP for PerlOnJava
还没有人认领这个 Issue。
评估
调研方向
先从 PerlOnJava DBI/SQLite 路径和随附的 SQLite 兼容层开始,然后通过 PerlOnJava DBI 使用系统 Perl 验证来运行针对性的回归测试。完成的标准是:已注册兼容的 REGEXP 行为,该回归测试在 JVM 和解释器后端上均通过,并且 Locale::Unicode::Data v1.9.0 使用 REGEXP 的测试通过,同时 Unicode 失败仍归在 issue #1374 下。
由索引模型根据 Issue 内容生成。
描述
Summary
The bundled PerlOnJava SQLite compatibility layer does not provide the SQLite REGEXP function expected by Locale::Unicode::Data v1.9.0.
Reproduction
CPAN random tester run: 20260916-111623-23683
Distribution: Locale::Unicode::Data v1.9.0
The upstream test suite exercises queries such as:
field REGEXP(?)
Under PerlOnJava, these queries fail with:
DBI prepare failed: no such function: REGEXP
The failure is observed in the collations and unit_aliases paths, and also prevents the related timezone-format query from completing.
Expected result
The unchanged upstream suite passes under system Perl: 11 test files and 741 tests successful.
Actual result
PerlOnJava reports 17 failed subtests out of 741. The failures include the separate Unicode mojibake problem already tracked in issue #1374; this issue is specifically for the missing SQLite REGEXP function.
The failure reproduces through the PerlOnJava DBI/SQLite path and is independent of an external database service.
Impact
DBD::SQLite has 588 unique released CPAN distributions with runtime dependencies, including 118 released within the last three years. Representative recent dependants include DBIx-Lite, Database-Join, Finance-Tiller2QIF, HTTP-Cookies-Chrome, and Punk-Queue.
Acceptance criteria
- Add a focused, system-Perl-validated regression for a SQLite
REGEXPquery through PerlOnJava DBI. - Implement or register compatible
REGEXPbehavior in the bundled SQLite layer. - Verify
Locale::Unicode::Data v1.9.0passes itsREGEXP-using tests on both JVM and interpreter backends. - Keep Unicode decoding failures tracked separately under issue #1374.
- 主要语言
- Perl
- 星标
- 64
- 派生
- 6
- 平均合并
- 5 小时 38 分钟
- 30 天内合并 PR
- 170
贡献指南
从这里开始
- 先读完整个 Issue,再读项目的贡献指南。
- 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
- Fork 仓库,在一个分支上完成修改。
- 提交 Pull Request,并在描述里引用这个 Issue 编号。
fglock/PerlOnJava 的其他 Issue
-
area:cpan-port area:unicode bug
难度 2/5 1-3 小时 新手友好度 88/100
fglock/PerlOnJava#1341 ·
-
area:backend area:runtime bug
难度 4/5 3-5 天 新手友好度 45/100
fglock/PerlOnJava#1511 ·
-
area:backend area:cpan-port bug
难度 4/5 3-5 天 新手友好度 45/100
fglock/PerlOnJava#1508 · 1 条评论 ·
-
area:cpan-port area:platform enhancement
难度 5/5 一周以上 新手友好度 30/100
fglock/PerlOnJava#1507 ·
-
bug
难度 4/5 3-5 天 新手友好度 45/100
fglock/PerlOnJava#1506 ·
查看 fglock/PerlOnJava 的全部 Issue
相似的 Issue
-
documentation Needs Triage
难度 2/5 1-3 小时 新手友好度 75/100
-
难度 2/5 1-3 小时 新手友好度 75/100
trizen/youtube-viewer#456 ·
-
难度 2/5 1-3 小时 新手友好度 70/100
-
connectivity 未关闭
难度 1/5 1 小时以内 新手友好度 80/100
-
Common US ingredient names are not recognized, so about 12.4k US products miss an allergen warning 未关闭
难度 2/5 1-3 小时 新手友好度 75/100
openfoodfacts/openfoodfacts-server#14657 · 4 条评论 ·