Bug#881291: libdbd-sqlite3-perl FTBFS with libsqlite3-dev 3.21.0-1

[Damyan Ivanov]

Control: tag -1 confirmed upstream

-=| Adrian Bunk, 09.11.2017 20:25:17 +0200 |=-
> Source: libdbd-sqlite3-perl
> Version: 1.54-2
> Severity: serious
> 
> https://tests.reproducible-builds.org/debian/rb-pkg/unstable/amd64/libdbd-sqlite3-perl.html
> 
> ...
> Test Summary Report
> -------------------
> 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=105, Tests=3555, 22 wallclock secs ( 0.81 usr  0.26 sys + 12.46 cusr  1.88 csys = 15.41 CPU)
> Result: FAIL
> Failed 1/105 test programs. 1/3555 subtests failed.
> Makefile:1078: recipe for target 'test_dynamic' failed

This also falils in a current sbuild chroot:

#   Failed test 'no warnings'
#   at /usr/share/perl/5.26/Test/Builder.pm line 135.
# There were 2 warning(s)
#       Previous test 23 'SELECT rowid FROM vtb WHERE c = 'six''
#       Use of uninitialized value $op in pattern match (m//) at /<<PKGBUILDDIR>>/blib/lib/DBD/SQLite/VirtualTable/PerlData.pm line 104.
#  at /<<PKGBUILDDIR>>/blib/lib/DBD/SQLite/VirtualTable/PerlData.pm line 104.
#       DBD::SQLite::VirtualTable::PerlData::BEST_INDEX(DBD::SQLite::VirtualTable::PerlData=HASH(0x55efd272a948), ARRAY(0x55efd2757f10), ARRAY(0x55efd26e8c98)) called at /<<PKGBUILDDIR>>/blib/lib/DBD/SQLite.pm line 202
#       DBD::SQLite::db::prepare(DBI::db=HASH(0x55efd26dc460), "SELECT a FROM vtb WHERE b IS NULL ORDER BY a", undef) called at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 1690
#       DBD::_::db::selectcol_arrayref(DBI::db=HASH(0x55efd26dc460), "SELECT a FROMvtb WHERE b IS NULL ORDER BY a") called at t/virtual_table/rt_99748.t line 80
#       main::test_table(DBI::db=HASH(0x55efd26dc508), "vtb") called at t/virtual_table/rt_99748.t line 57
#
# ----------
#       Previous test 23 'SELECT rowid FROM vtb WHERE c = 'six''
#       Use of uninitialized value $op in concatenation (.) or string at /<<PKGBUILDDIR>>/blib/lib/DBD/SQLite/VirtualTable/PerlData.pm line 108.
#  at /<<PKGBUILDDIR>>/blib/lib/DBD/SQLite/VirtualTable/PerlData.pm line 108.
#       DBD::SQLite::VirtualTable::PerlData::BEST_INDEX(DBD::SQLite::VirtualTable::PerlData=HASH(0x55efd272a948), ARRAY(0x55efd2757f10), ARRAY(0x55efd26e8c98)) called at /<<PKGBUILDDIR>>/blib/lib/DBD/SQLite.pm line 202
#       DBD::SQLite::db::prepare(DBI::db=HASH(0x55efd26dc460), "SELECT a FROM vtb WHERE b IS NULL ORDER BY a", undef) called at /usr/lib/x86_64-linux-gnu/perl5/5.26/DBI.pm line 1690
#       DBD::_::db::selectcol_arrayref(DBI::db=HASH(0x55efd26dc460), "SELECT a FROM vtb WHERE b IS NULL ORDER BY a") called at t/virtual_table/rt_99748.t line 80
#       main::test_table(DBI::db=HASH(0x55efd26dc508), "vtb") called at t/virtual_table/rt_99748.t line 57

Some observations:

 - no similar bug report exists upstream 
   (https://rt.cpan.org/Dist/Display.html?Queue=DBD-SQLite)
 - disabling the use_system_sqlite patch works around the failure
 - applying the patch from 
   https://rt.cpan.org/Ticket/Display.html?id=114138 for guaranteed 
   usage of system sqlite3.h does not help.
 - removing the upstream sqlite3.h from debian/rules also does not 
   help

So this seems like a genuine problem with newer sqlite. Upstream's 
sqlite3.h is 3.13.0, while Debian/unstable now has 3.21.0.

-- dam