Hacktoberfest 2026: the issues maintainers tagged for October, open and beginner-friendly. Browse Hacktoberfest issues

DBD::SQLite: implement REGEXP for PerlOnJava

Open
#1,400 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
52/100
Issue type
Bug
Clarity
Mostly clear
Activity status
Active
Tech stack
perl, sqlite
Domain
databases

Research direction

Start with the PerlOnJava DBI/SQLite path and the bundled SQLite compatibility layer, then run the focused regression through PerlOnJava DBI using system Perl validation. Done means compatible REGEXP behavior is registered, the regression passes on JVM and interpreter backends, and Locale::Unicode::Data v1.9.0 passes its REGEXP-using tests while Unicode failures remain under issue #1374.

Written by the indexing model from the issue text.

Description

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.
Dominant language
Perl
Stars
64
Forks
6
Avg merge
5h 38m
Merged PRs (30d)
170

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from fglock/PerlOnJava

All issues in fglock/PerlOnJava

Similar issues

More Perl issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.