Bug#919773: libdbd-sqlite3-perl FTBFS on mips: test failure

[Xavier]

Le 19/01/2019 à 14:44, Adrian Bunk a écrit :
> Source: libdbd-sqlite3-perl
> Version: 1.62-1
> Severity: serious
> Tags: ftbfs
> 
> https://buildd.debian.org/status/fetch.php?pkg=libdbd-sqlite3-perl&arch=mips&ver=1.62-1&stamp=1546291045&raw=0
> 
> ...
> t/65_db_config.t ...................................... 
> 1..79
> ok 1 - An object of class 'DBI::db' isa 'DBI::db'
> ok 2 - LOOKASIDE is not supported
> ok 3
> ok 4 - An object of class 'DBI::db' isa 'DBI::db'
> ok 5 - LOOKASIDE is not supported
> ok 6
> ok 7 - An object of class 'DBI::db' isa 'DBI::db'
> ok 8 - MAINDBNAME is not supported
> ok 9
> ok 10 - An object of class 'DBI::db' isa 'DBI::db'
> ok 11 - MAINDBNAME is not supported
> ok 12
> ok 13 - An object of class 'DBI::db' isa 'DBI::db'
> ok 14 - enable foreign key
> ok 15 - disable foreign key
> ok 16 - An object of class 'DBI::db' isa 'DBI::db'
> ok 17 - enable foreign key
> ok 18 - disable foreign key
> ok 19 - An object of class 'DBI::db' isa 'DBI::db'
> ok 20 - enable trigger
> ok 21 - disable trigger
> ok 22 - An object of class 'DBI::db' isa 'DBI::db'
> ok 23 - enable trigger
> ok 24 - disable trigger
> ok 25 - An object of class 'DBI::db' isa 'DBI::db'
> ok 26 - enable fts3_tokenizer
> ok 27 - disable fts3_tokenizer
> ok 28 - An object of class 'DBI::db' isa 'DBI::db'
> ok 29 - enable fts3_tokenizer
> ok 30 - disable fts3_tokenizer
> ok 31 - An object of class 'DBI::db' isa 'DBI::db'
> ok 32 - enable load_extension
> ok 33 - disable load_extension
> ok 34 - An object of class 'DBI::db' isa 'DBI::db'
> ok 35 - enable load_extension
> ok 36 - disable load_extension
> ok 37 - An object of class 'DBI::db' isa 'DBI::db'
> ok 38 - no checkpoint on close
> ok 39 - checkpoint on close
> ok 40 - An object of class 'DBI::db' isa 'DBI::db'
> ok 41 - no checkpoint on close
> ok 42 - checkpoint on close
> ok 43 - An object of class 'DBI::db' isa 'DBI::db'
> ok 44 - enable query planner stability guarantee
> ok 45 - disable query planner stability guarantee
> ok 46 - An object of class 'DBI::db' isa 'DBI::db'
> ok 47 - enable query planner stability guarantee
> ok 48 - disable query planner stability guarantee
> ok 49 - An object of class 'DBI::db' isa 'DBI::db'
> ok 50 - trigger explain query plan
> ok 51 - no trigger explain query plan
> ok 52 - An object of class 'DBI::db' isa 'DBI::db'
> ok 53 - trigger explain query plan
> ok 54 - no trigger explain query plan
> ok 55 - An object of class 'DBI::db' isa 'DBI::db'
> ok 56 - enable reset database
> ok 57 - disable reset database
> ok 58 - An object of class 'DBI::db' isa 'DBI::db'
> ok 59 - enable reset database
> ok 60 - disable reset database
> ok 61 - An object of class 'DBI::db' isa 'DBI::db'
> ok 62 - found sql
> ok 63
> ok 64 - updating sqlite_master is prohibited
> ok 65
> ok 66
> ok 67 - updating sqlite_master is succeeded
> ok 68 - sql not found
> ok 69 - An object of class 'DBI::db' isa 'DBI::db'
> ok 70 - found sql
> ok 71
> ok 72 - updating sqlite_master is prohibited
> ok 73
> ok 74
> ok 75 - updating sqlite_master is succeeded
> ok 76 - sql not found
> Failed 3/79 subtests
> ...
> Test Summary Report
> -------------------
> t/65_db_config.t                                    (Wstat: 11 Tests: 76 Failed: 0)
>   Non-zero wait status: 11
>   Parse errors: Bad plan.  You planned 79 tests but ran 76.
> Files=111, Tests=3794, 61 wallclock secs ( 2.80 usr  0.48 sys + 48.42 cusr  4.10 csys = 55.80 CPU)
> Result: FAIL
> Failed 1/111 test programs. 0/3794 subtests failed.
> make[1]: *** [Makefile:1086: test_dynamic] Error 255
> 
> _______________________________________________
> pkg-perl-maintainers mailing list
> pkg-perl-maintainers at alioth-lists.debian.net
> https://alioth-lists.debian.net/cgi-bin/mailman/listinfo/pkg-perl-maintainers
> 

I think the failure is here. I'm testing

diff --git a/t/65_db_config.t b/t/65_db_config.t
index 6820736..1e336cf 100644
--- a/t/65_db_config.t
+++ b/t/65_db_config.t
@@ -211,7 +211,7 @@ for my $func (@CALL_FUNCS) {

 # DEFENSIVE at connection
 SKIP: {
-    skip 'DEFENSIVE is not supported', 8 if !SQLITE_DBCONFIG_DEFENSIVE;
+    skip 'DEFENSIVE is not supported', 3 if !SQLITE_DBCONFIG_DEFENSIVE;
     my $dbh = connect_ok(RaiseError => 1, PrintError => 0,
sqlite_defensive => 1);

     my $sql = 'CREATE TABLE foo (id, text)';