Bug 1543286

Summary: perl-DBD-SQLite-1.54-5.fc28 FTBFS with sqlite 3.22.0: t/virtual_table/rt_99748.t: couldn't eval q{sub {my ($self, $i) = @_; my $row = $self->row($i); (defined($row->[1]) && defined($vals[0]) && $row->[1] $vals[0])}} : syntax error at (eval 20) line 1
Product: [Fedora] Fedora Reporter: Petr Pisar <ppisar>
Component: perl-DBD-SQLiteAssignee: Jitka Plesnikova <jplesnik>
Status: CLOSED RAWHIDE QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: rawhideCC: jose.p.oliveira.oss, jplesnik, kasal, perl-devel, steve, tcallawa
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
URL: https://apps.fedoraproject.org/koschei/build/4145136
Whiteboard:
Fixed In Version: perl-DBD-SQLite-1.54-6.fc28 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-02-08 09:39:41 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Petr Pisar 2018-02-08 07:20:07 UTC
perl-DBD-SQLite-1.54-5.fc28 fails to build in F28 because tests fail:

t/virtual_table/21_perldata_charinfo.t ................ ok
couldn't eval q{sub {my ($self, $i) = @_; my $row = $self->row($i); (defined($row->[1]) && defined($vals[0]) && $row->[1]  $vals[0])}} : syntax error at (eval 20) line 1, near "]  $vals"
#   Failed test 'no warnings'
#   at /usr/share/perl5/vendor_perl/Test/Builder.pm line 158.
# 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 /builddir/build/BUILD/DBD-SQLite-1.54/blib/lib/DBD/SQLite/VirtualTable/PerlData.pm line 104.
#  at /builddir/build/BUILD/DBD-SQLite-1.54/blib/lib/DBD/SQLite/VirtualTable/PerlData.pm line 104.
# 	DBD::SQLite::VirtualTable::PerlData::BEST_INDEX(DBD::SQLite::VirtualTable::PerlData=HASH(0xaaaac62ec520), ARRAY(0xaaaac628d9c8), ARRAY(0xaaaac6288138)) called at /builddir/build/BUILD/DBD-SQLite-1.54/blib/lib/DBD/SQLite.pm line 202
# 	DBD::SQLite::db::prepare(DBI::db=HASH(0xaaaac625f5e8), "SELECT a FROM vtb WHERE b IS NULL ORDER BY a", undef) called at /usr/lib64/perl5/vendor_perl/DBI.pm line 1692
# 	DBD::_::db::selectcol_arrayref(DBI::db=HASH(0xaaaac625f5e8), "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(0xaaaac625f690), "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 /builddir/build/BUILD/DBD-SQLite-1.54/blib/lib/DBD/SQLite/VirtualTable/PerlData.pm line 108.
#  at /builddir/build/BUILD/DBD-SQLite-1.54/blib/lib/DBD/SQLite/VirtualTable/PerlData.pm line 108.
# 	DBD::SQLite::VirtualTable::PerlData::BEST_INDEX(DBD::SQLite::VirtualTable::PerlData=HASH(0xaaaac62ec520), ARRAY(0xaaaac628d9c8), ARRAY(0xaaaac6288138)) called at /builddir/build/BUILD/DBD-SQLite-1.54/blib/lib/DBD/SQLite.pm line 202
# 	DBD::SQLite::db::prepare(DBI::db=HASH(0xaaaac625f5e8), "SELECT a FROM vtb WHERE b IS NULL ORDER BY a", undef) called at /usr/lib64/perl5/vendor_perl/DBI.pm line 1692
# 	DBD::_::db::selectcol_arrayref(DBI::db=HASH(0xaaaac625f5e8), "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(0xaaaac625f690), "vtb") called at t/virtual_table/rt_99748.t line 57
# 
# Looks like your test exited with 2 just after 24.
t/virtual_table/rt_99748.t ............................ 
Dubious, test returned 2 (wstat 512, 0x200)
Failed 29/52 subtests 

This is caused by upgrading sqlite-devel from 3.20.1-1.fc28 to 3.22.0-2.fc28.

Comment 1 Petr Pisar 2018-02-08 07:25:30 UTC
perl-CGI-Application-Plugin-Authentication also fails tests when upgrading sqlite-libs. Either both tests are wrong, or there is something broken in the new sqlite.

Comment 2 Jitka Plesnikova 2018-02-08 08:57:21 UTC
The issue was fixed in developer release 1.55_04.

More info:
https://github.com/DBD-SQLite/DBD-SQLite/issues/28