PaulHowarth/Blog/2010-09-15

Wednesday 15th September 2010

Fedora Project

Updated perl-Text-SpellChecker to 0.06 in Rawhide, EL-6, and F-14
RexDieter reviewed and approved my tidyp submission so it'll be in Fedora and EPEL soon

Local Packages

Updated perl-DBD-SQLite to 1.31; this proved to be a non-trivial update due to issues building the module with the system version of SQLite:

The addition of "-I." to the compiler flags in Makefile.PL means that the bundled "sqlite3.h" is used even when building with the system SQLite version, which may cause complete failure of the module if for instance the system version is older than 3.6.23, when this happens in the test suite:

# Failed test 'use DBD::SQLite;'
# at t/01_compile.t line 15.
# Tried to use 'DBD::SQLite'.
# Error: Can't load '/builddir/build/BUILD/DBD-SQLite-1.31/blib/arch/auto/DBD/SQLite/SQLite.so' for module DBD::SQLite: /builddir/build/BUILD/DBD-SQLite-1.31/blib/arch/auto/DBD/SQLite/SQLite.so:
undefined symbol: sqlite3_compileoption_get at /usr/lib64/perl5/DynaLoader.pm line 200.
# at (eval 7) line 2
# Compilation failed in require at (eval 7) line 2.
# BEGIN failed--compilation aborted at (eval 7) line 2.
# $DBI::VERSION=1.613
Use of inherited AUTOLOAD for non-method DBD::SQLite::compile_options()
is deprecated at t/01_compile.t line 20.
Can't locate auto/DBD/SQLite/compile_opt.al in @INC (@INC contains: inc /builddir/build/BUILD/DBD-SQLite-1.31/blib/lib /builddir/build/BUILD/DBD-SQLite-1.31/blib/arch /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/local/share/perl5 /usr/lib64/perl5 /usr/share/perl5 /usr/share/perl5 /usr/lib64/perl5 /usr/share/perl5 /usr/local/lib64/perl5/site_perl/5.10.0/x86_64-linux-thread-multi /usr/local/lib/perl5/site_perl/5.10.0 /usr/lib64/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl /usr/lib/perl5/site_perl .) at t/01_compile.t line 20
# Looks like you failed 1 test of 3.
# Looks like your test exited with 2 just after 3.
t/01_compile.t ...........................
Dubious, test returned 2 (wstat 512, 0x200)
Failed 1/3 subtests

This is because the bundled sqlite3.h says that SQLITE_VERSION_NUMBER is 3007002 and hence sqlite3_compileoption_get should be available but it's not present in the actual library so module loading fails.
I worked around this by deleting the bundled sqlite3.c, sqlite3.h and sqlite3ext.h before running Makefile.PL.
If the system SQLite wasn't built with the ENABLE_FTS3_PARENTHESIS option enabled, the test suite fails:

# Failed test 'moutons NOT lait (unicode is 0)'
# at t/43_fts3.t line 98.
# Structures begin differing at:
# $got->[0] = Does not exist
# $expected->[0] = '2'
# Failed test '(il OR elle) AND un* (unicode is 0)'
# at t/43_fts3.t line 98.
# Structures begin differing at:
# $got->[0] = Does not exist
# $expected->[0] = '1'
# Failed test 'moutons NOT lait (unicode is 1)'
# at t/43_fts3.t line 98.
# Structures begin differing at:
# $got->[0] = Does not exist
# $expected->[0] = '2'
# Failed test '(il OR elle) AND un* (unicode is 1)'
# at t/43_fts3.t line 98.
# Structures begin differing at:
# $got->[0] = Does not exist
# $expected->[0] = '1'
# Looks like you failed 4 tests of 19.
t/43_fts3.t ..............................
Dubious, test returned 4 (wstat 1024, 0x400)
Failed 4/19 subtests

I added a patch to the test to resolve that problem:

--- DBD-SQLite-1.31/t/43_fts3.t 2010-09-15 08:16:43.000000000 +0100
+++ DBD-SQLite-1.31/t/43_fts3.t 2010-09-15 14:50:58.529161202 +0100
@@ -90,6 +90,11 @@
   }
 
   # queries
+SKIP: {
+  skip "These tests require SQLite compiled with ENABLE_FTS3_PARENTHESIS option", scalar @tests
+    unless DBD::SQLite->can('compile_options') &&
+    grep /ENABLE_FTS3_PARENTHESIS/, DBD::SQLite::compile_options();
+
   my $sql = "SELECT docid FROM try_fts3 WHERE content MATCH ?";
   for my $t (@tests) {
     my ($query, @expected) = @$t;
@@ -97,6 +102,9 @@
     my $results = $dbh->selectcol_arrayref($sql, undef, $query);
     is_deeply($results, \@expected, "$query (unicode is $use_unicode)");
   }
+
+}
+
 }

I raised these issues upstream in CPAN RT#61361
Updated python-zope-interface to BR: python2-devel rather than just python-devel and not move the text files (as per the Fedora version)