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
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.
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
The bug has been referenced in the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=1e3aadf18792bd10d5577b971994641467258458 commit 1e3aadf18792bd10d5577b971994641467258458 Author: Kent Fredric <kentnl@gentoo.org> AuthorDate: 2018-03-03 01:53:25 +0000 Commit: Kent Fredric <kentnl@gentoo.org> 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 ) Bug: https://bugs.gentoo.org/641108 Bug: https://bugs.gentoo.org/649408 Bug: https://bugs.gentoo.org/640724 profiles/base/package.use.stable.mask | 6 ++++++ 1 file changed, 6 insertions(+)}
@leio 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.
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 <kentnl@gentoo.org> 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 Upstream: - Upgrade bundled SQLite to 3.29.0 for * security fixes * ALTER TABLE ... RENAME COLUMN * UPSERT - Add ::GetInfo - Fix to use a PV value as a virtual table column value where appropriate - 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 https://github.com/DBD-SQLite/DBD-SQLite/issues/45 - Fix ->quote($blob, SQL_BLOB) to quote correctly (injection risk) https://github.com/DBD-SQLite/DBD-SQLite/issues/51 - Add sqlite_get_autocommit private query method Package-Manager: Portage-2.3.100, Repoman-2.3.22 Signed-off-by: Kent Fredric <kentnl@gentoo.org>
The bug has been closed via the following commit(s): https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=2bc794850d57f994586939754866b45fb7917eaf commit 2bc794850d57f994586939754866b45fb7917eaf Author: Andreas K. Hüttel <dilfridge@gentoo.org> AuthorDate: 2021-05-01 14:41:14 +0000 Commit: Andreas K. Hüttel <dilfridge@gentoo.org> CommitDate: 2021-05-01 15:29:19 +0000 dev-perl/DBD-SQLite: Remove old Closes: https://bugs.gentoo.org/677680 Closes: https://bugs.gentoo.org/649408 Package-Manager: Portage-3.0.18, Repoman-3.0.2 Signed-off-by: Andreas K. Hüttel <dilfridge@gentoo.org> 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(-)
