Hacktoberfest 2026:维护者为十月标记出来的 issue,仍然开放、适合新手。 浏览 Hacktoberfest issue

DBD::SQLite: implement REGEXP for PerlOnJava

未关闭
#1,400 0 条评论 0 个 reaction 已指派 0 人 在 GitHub 查看

还没有人认领这个 Issue。

评估

难度
4/5
预计耗时
3-5 天
新手友好度
52/100
Issue 类型
缺陷
描述清晰度
基本清楚
活跃度
活跃
技术栈
perl, sqlite
领域
databases

调研方向

先从 PerlOnJava DBI/SQLite 路径和随附的 SQLite 兼容层开始,然后通过 PerlOnJava DBI 使用系统 Perl 验证来运行针对性的回归测试。完成的标准是:已注册兼容的 REGEXP 行为,该回归测试在 JVM 和解释器后端上均通过,并且 Locale::Unicode::Data v1.9.0 使用 REGEXP 的测试通过,同时 Unicode 失败仍归在 issue #1374 下。

由索引模型根据 Issue 内容生成。

描述

bug

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 REGEXP query through PerlOnJava DBI.
  • Implement or register compatible REGEXP behavior in the bundled SQLite layer.
  • Verify Locale::Unicode::Data v1.9.0 passes its REGEXP-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

贡献指南

打开贡献指南

从这里开始

  1. 先读完整个 Issue,再读项目的贡献指南。
  2. 在 Issue 下留言说明你要接手 —— 这能避免两个人做同样的事。
  3. Fork 仓库,在一个分支上完成修改。
  4. 提交 Pull Request,并在描述里引用这个 Issue 编号。

fglock/PerlOnJava 的其他 Issue

查看 fglock/PerlOnJava 的全部 Issue

相似的 Issue

更多 Perl Issue

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。