Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 649408 - dev-perl/DBD-SQLite-1.500.0[system-sqlite] fails tests
Summary: dev-perl/DBD-SQLite-1.500.0[system-sqlite] fails tests
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: Current packages (show other bugs)
Hardware: All Linux
: Normal normal (vote)
Assignee: Gentoo Perl team
Depends on:
Blocks: perl-testfailure
  Show dependency tree
Reported: 2018-03-02 21:36 UTC by Mart Raudsepp
Modified: 2021-05-01 15:29 UTC (History)
1 user (show)

See Also:
Package list:
Runtime testing required: ---


Note You need to log in before you can comment on or make changes to this bug.
Description Mart Raudsepp gentoo-dev 2018-03-02 21:36:27 UTC
dev-perl/DBD-SQLite-1.500.0 fails tests with USE=system-sqlite against sqlite-3.21.0 (which 1.500.0 is meant to work with, with earlier versions requiring an older sqlite). Tests appear to pass with bundled sqlite.

Test Summary Report
t/43_fts3.t                                         (Wstat: 65280 Tests: 2 Failed: 1)
  Failed test:  2
  Non-zero exit status: 255
  Parse errors: Bad plan.  You planned 35 tests but ran 2.
t/virtual_table/rt_99748.t                          (Wstat: 512 Tests: 24 Failed: 1)
  Failed test:  24
  Non-zero exit status: 2
  Parse errors: Bad plan.  You planned 52 tests but ran 24.
Files=103, Tests=3500,  5 wallclock secs ( 2.10 usr  0.34 sys + 25.63 cusr  4.04 csys = 32.11 CPU)
Result: FAIL
Failed 2/103 test programs. 2/3500 subtests failed.
Makefile:1063: recipe for target 'test_dynamic' failed
Comment 1 Mart Raudsepp gentoo-dev 2018-03-02 21:38:44 UTC
sigh, I had a typo in package.keywords and thought I was testing 1.540.0-r1. Though it seems like a missing <sqlite dep then.
Comment 2 Mart Raudsepp gentoo-dev 2018-03-02 21:45:51 UTC
I can't test 1.540.0-r1 due to system-sqlite requring an older sqlite. 1.560.0 tests pass with USE=system-sqlite against sqlite-5.21.0.
Feel free to close INVALID if not deciding to tweak the sqlite dep in old 1.500.0.

Note that 1.560.0 needs stabling or 1.540-r1 USE=system-sqlite existence reconsidered due to bug 641108
Comment 3 Larry the Git Cow gentoo-dev 2018-03-03 01:58:48 UTC
The bug has been referenced in the following commit(s):

commit 1e3aadf18792bd10d5577b971994641467258458
Author:     Kent Fredric <>
AuthorDate: 2018-03-03 01:53:25 +0000
Commit:     Kent Fredric <>
CommitDate: 2018-03-03 01:57:33 +0000

    profiles: package.use.stable.mask dev-perl/DBD-SQLite[system-sqlite]
    - Using versions of system sqlite other than the one DBD-SQLite ships
     with causes regular issues that challenge the ability for tis package
     to have a meaning stability status
    - Restricting system sqlite versions to solve the above problem causes
     significant impediments to stabilizing sqlite. ( DBD-SQLites release
     cycle is somewhat behind that of SQLites )

 profiles/base/package.use.stable.mask | 6 ++++++
 1 file changed, 6 insertions(+)}
Comment 4 Kent Fredric (IRC: kent\n) (RETIRED) gentoo-dev 2019-07-10 09:49:02 UTC

Are the mitigations presented here adequate for you? ( that is, blocking the use of this flag on systems that expect stability )

This flag exists only for people who want control, but we cannot guarantee at all that this control will give them something that works.
Comment 5 Kent Fredric (IRC: kent\n) (RETIRED) gentoo-dev 2020-07-09 03:10:08 UTC
USE=system-sqlite seems to currently work with the latest 1.640.0

And tested with the oldest version currently in tree, 3.31.1

Please retest.

commit 5aa87584945e5ae652c70e9504273ed6de9baa2f
Author: Kent Fredric <>
Date:   2020-07-09 13:59:37 +1200

    dev-perl/DBD-SQLite: Bump to version 1.640.0
    - EAPI7
    - Increase Min SQLITE for system-sqlite to 3.29
    - Simplify system-sqlite patching/pruning
    - Isolate config-only stuff to src_configure
    - Ensure CFLAGS passed to make/compiler
    - Upgrade bundled SQLite to 3.29.0 for
      * security fixes
      * UPSERT
    - Add ::GetInfo
    - Fix to use a PV value as a virtual table column value where
    - Add deferability to foreign_key_info
    - Added ability to configure SQLITE_MAX_LENGTH via ENV
    - Add $dbh->sqlite_limit to change runtime limits
    - Update constants
    - Add sqlite_backup_{from_dbh,to_dbh} methods
    - Add $dbh->sqlite_prefer_numeric_type to prefer arrays of ints instead
      of arrays of strings in TYPE statemetns
    - Add sqlite_db_config method and related constants
    - Add sqlite_defensive option to prohibit dangerous SQLite features
    - Expose some hidden extended result codes
    - Ensure an internal HV is initialized
    - Handle 'unknown' op in DBD::SQLite::VirtualTable::PerlData
    - Avoid segmentation fault on big-endian 32bit
    - Fix ->quote($blob, SQL_BLOB) to quote correctly (injection risk)
    - Add sqlite_get_autocommit private query method
    Package-Manager: Portage-2.3.100, Repoman-2.3.22
    Signed-off-by: Kent Fredric <>
Comment 6 Larry the Git Cow gentoo-dev 2021-05-01 15:29:36 UTC
The bug has been closed via the following commit(s):

commit 2bc794850d57f994586939754866b45fb7917eaf
Author:     Andreas K. Hüttel <>
AuthorDate: 2021-05-01 14:41:14 +0000
Commit:     Andreas K. Hüttel <>
CommitDate: 2021-05-01 15:29:19 +0000

    dev-perl/DBD-SQLite: Remove old
    Package-Manager: Portage-3.0.18, Repoman-3.0.2
    Signed-off-by: Andreas K. Hüttel <>

 dev-perl/DBD-SQLite/DBD-SQLite-1.560.0.ebuild | 48 ---------------------------
 dev-perl/DBD-SQLite/DBD-SQLite-1.580.0.ebuild | 48 ---------------------------
 dev-perl/DBD-SQLite/Manifest                  |  2 --
 3 files changed, 98 deletions(-)