DBD-SQLite v1.70 Perl 5 v5.8.9 OpenBSD.amd64-openbsd

Status
Pass
From
Nigel Horne
Dist
DBD-SQLite v1.70
Platform
Perl 5 v5.8.9 OpenBSD.amd64-openbsd
Date
2021-12-23T16:17:46
ID
dd824ae8-640b-11ec-b5ae-e3f27e4ff3ac
This distribution has been tested as part of the CPAN Testers
project, supporting the Perl programming language.  See
http://wiki.cpantesters.org/ for more information or email
questions to cpan-testers-discuss@perl.org


--
Dear Kenichi Ishigaki,

This is a computer-generated report for DBD-SQLite-1.70
on perl 5.8.9, created by CPAN-Reporter-1.2018.

Thank you for uploading your work to CPAN.  Congratulations!
All tests were successful.

Sections of this report:

    * Tester comments
    * Program output
    * Prerequisites
    * Environment and other context

------------------------------
TESTER COMMENTS
------------------------------

Additional comments from tester:

none provided

------------------------------
PROGRAM OUTPUT
------------------------------

Output from '/usr/bin/make test':

"/home/njh/perl5/perlbrew/perls/perl-5.8.9/bin/perl" -MExtUtils::Command::MM -e 'cp_nonempty' -- SQLite.bs blib/arch/auto/DBD/SQLite/SQLite.bs 644
PERL_DL_NONLAZY=1 "/home/njh/perl5/perlbrew/perls/perl-5.8.9/bin/perl" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/*/*.t
# $DBI::VERSION=1.643
# Compile Options:
#   COMPILER=clang-10.0.1
#   ENABLE_COLUMN_METADATA
#   ENABLE_FTS3_PARENTHESIS
#   ENABLE_FTS4
#   ENABLE_FTS5
#   ENABLE_JSON1
#   ENABLE_MATH_FUNCTIONS
#   ENABLE_RTREE
#   SYSTEM_MALLOC
#   THREADSAFE=0
t/01_compile.t ........................................ ok
# sqlite_version=3.36.0
t/02_logon.t .......................................... ok
t/03_create_table.t ................................... ok
t/04_insert.t ......................................... ok
t/05_select.t ......................................... ok
t/06_tran.t ........................................... ok
t/07_error.t .......................................... ok
t/08_busy.t ........................................... ok
t/09_create_function.t ................................ ok
t/10_create_aggregate.t ............................... ok
t/11_get_info.t ....................................... ok
t/12_unicode.t ........................................ ok
t/13_create_collation.t ............................... ok
t/14_progress_handler.t ............................... ok
t/15_ak_dbd.t ......................................... ok
t/16_column_info.t .................................... ok
t/17_createdrop.t ..................................... ok
t/18_insertfetch.t .................................... ok
t/19_bindparam.t ...................................... ok
t/20_blobs.t .......................................... ok
t/21_blobtext.t ....................................... ok
t/22_listfields.t ..................................... ok
t/23_nulls.t .......................................... ok
t/24_numrows.t ........................................ ok
t/25_chopblanks.t ..................................... ok
t/26_commit.t ......................................... ok
t/27_metadata.t ....................................... ok
t/28_schemachange.t ................................... ok
t/30_auto_rollback.t .................................. ok
t/31_bind_weird_number_param.t ........................ ok
t/32_inactive_error.t ................................. ok
t/33_non_latin_path.t ................................. ok
t/34_online_backup.t .................................. ok
t/35_table_info.t ..................................... ok
t/36_hooks.t .......................................... ok
t/37_regexp.t ......................................... ok
t/38_empty_statement.t ................................ ok
t/39_foreign_keys.t ................................... ok
t/40_multiple_statements.t ............................ ok
t/41_placeholders.t ................................... ok
t/42_primary_key_info.t ............................... ok
t/43_fts3.t ........................................... ok
t/44_rtree.t .......................................... ok
t/45_savepoints.t ..................................... ok
t/46_mod_perl.t ....................................... skipped: requires APR::Table
t/47_execute.t ........................................ ok
t/48_bind_param_is_sticky.t ........................... ok
t/49_trace_and_profile.t .............................. ok
t/50_foreign_key_info.t ............................... ok
t/51_table_column_metadata.t .......................... ok
t/52_db_filename.t .................................... ok
t/53_status.t ......................................... ok
t/54_literal_txn.t .................................... ok
t/55_statistics_info.t ................................ ok
t/56_open_flags.t ..................................... ok
t/57_uri_filename.t ................................... ok
t/58_see_if_its_a_number_and_explicit_binding.t ....... ok
t/59_extended_result_codes.t .......................... skipped: this test is for Win32 only
t/60_readonly.t ....................................... ok
t/61_strlike.t ........................................ ok
t/62_regexp_multibyte_char_class.t .................... ok
t/63_param_values.t ................................... ok
t/64_limit.t .......................................... ok
t/65_db_config.t ...................................... ok
t/66_get_autocommit.t ................................. ok
t/cookbook_variance.t ................................. ok
t/rt_106151_outermost_savepoint.t ..................... ok
t/rt_106950_extra_warnings_with_savepoints.t .......... ok
t/rt_115465_column_info_with_spaces.t ................. ok
t/rt_124227_index_regression.t ........................ ok
t/rt_15186_prepcached.t ............................... ok
t/rt_21406_auto_finish.t .............................. ok
t/rt_25371_asymmetric_unicode.t ....................... ok
t/rt_25460_numeric_aggregate.t ........................ ok
t/rt_25924_user_defined_func_unicode.t ................ ok
t/rt_26775_distinct.t ................................. ok
t/rt_27553_prepared_cache_and_analyze.t ............... ok
t/rt_29058_group_by.t ................................. ok
t/rt_29629_sqlite_where_length.t ...................... ok
t/rt_31324_full_names.t ............................... ok
t/rt_32889_prepare_cached_reexecute.t ................. ok
t/rt_36836_duplicate_key.t ............................ ok
t/rt_36838_unique_and_bus_error.t ..................... ok
t/rt_40594_nullable.t ................................. ok
t/rt_48393_debug_panic_with_commit.t .................. skipped: set $ENV{TEST_DBD_SQLITE_WITH_DEBUGGER} to enable this test
t/rt_50503_fts3.t ..................................... ok
t/rt_52573_manual_exclusive_lock.t .................... ok
t/rt_53235_icu_compatibility.t ........................ skipped: requires SQLite ICU plugin to be enabled
t/rt_62370_diconnected_handles_operation.t ............ ok
t/rt_64177_ping_wipes_out_the_errstr.t ................ ok
t/rt_67581_bind_params_mismatch.t ..................... ok
t/rt_71311_bind_col_and_unicode.t ..................... ok
t/rt_73159_fts_tokenizer_segfault.t ................... ok
t/rt_73787_exponential_buffer_overflow.t .............. ok
t/rt_76395_int_overflow.t ............................. ok
t/rt_77724_primary_key_with_a_whitespace.t ............ ok
t/rt_78833_utf8_flag_for_column_names.t ............... ok
t/rt_81536_multi_column_primary_key_info.t ............ ok
t/rt_88228_sqlite_3_8_0_crash.t ....................... ok
t/rt_96050_db_filename_for_a_closed_database.t ........ ok
t/rt_96877_unicode_statements.t ....................... ok
t/rt_96878_fts_contentless_table.t .................... ok
t/rt_97598_crash_on_disconnect_with_virtual_tables.t .. ok
t/virtual_table/00_base.t ............................. ok
t/virtual_table/01_destroy.t .......................... ok
t/virtual_table/02_find_function.t .................... ok
t/virtual_table/10_filecontent.t ...................... ok
t/virtual_table/11_filecontent_fulltext.t ............. ok
t/virtual_table/20_perldata.t ......................... ok
t/virtual_table/21_perldata_charinfo.t ................ ok
t/virtual_table/rt_124941.t ........................... ok
t/virtual_table/rt_99748.t ............................ ok
t/virtual_table/unknown_op.t .......................... ok
All tests successful.
Files=113, Tests=3850, 186 wallclock secs ( 1.23 usr  0.40 sys + 67.87 cusr 107.45 csys = 176.95 CPU)
Result: PASS

------------------------------
PREREQUISITES
------------------------------

Prerequisite modules loaded:

requires:

    Module              Need  Have    
    ------------------- ----- --------
    DBI                 1.57  1.643   
    File::Spec          0.82  3.75    
    perl                5.006 5.008009
    Test::More          0.88  1.302188
    Tie::Hash           0     1.03    

build_requires:

    Module              Need  Have    
    ------------------- ----- --------
    ExtUtils::MakeMaker 0     7.62    

configure_requires:

    Module              Need  Have    
    ------------------- ----- --------
    DBI                 1.57  1.643   
    ExtUtils::MakeMaker 6.48  7.62    
    File::Spec          0.82  3.75    


------------------------------
ENVIRONMENT AND OTHER CONTEXT
------------------------------

Environment variables:

    NONINTERACTIVE_TESTING = 1
    PATH = /home/njh/perl5/perlbrew/bin:/home/njh/perl5/perlbrew/perls/perl-5.8.9/bin:/home/njh/perl5/perlbrew/bin:/home/njh/bin:/bin:/usr/bin:/usr/local/bin
    PERL5LIB = 
    PERL5OPT = 
    PERL5_CPANPLUS_IS_RUNNING = 17835
    PERL5_CPAN_IS_RUNNING = 17835
    PERLBREW_HOME = /home/njh/.perlbrew
    PERLBREW_LIB = 
    PERLBREW_MANPATH = /home/njh/perl5/perlbrew/perls/perl-5.8.9/man
    PERLBREW_PATH = /home/njh/perl5/perlbrew/bin:/home/njh/perl5/perlbrew/perls/perl-5.8.9/bin
    PERLBREW_PERL = perl-5.8.9
    PERLBREW_ROOT = /home/njh/perl5/perlbrew
    PERLBREW_SHELLRC_VERSION = 0.92
    PERLBREW_VERSION = 0.92
    PERL_LOCAL_LIB_ROOT = 
    PERL_MM_USE_DEFAULT = 1
    PERL_USE_UNSAFE_INC = 1
    SHELL = /usr/local/bin/bash

Perl special variables (and OS-specific diagnostics, for MSWin32):

    $^X = /home/njh/perl5/perlbrew/perls/perl-5.8.9/bin/perl
    $UID/$EUID = 1000 / 1000
    $GID = 1000 1000 0
    $EGID = 1000 1000 0

Perl module toolchain versions installed:

    Module              Have    
    ------------------- --------
    CPAN                2.28    
    CPAN::Meta          2.143240
    Cwd                 3.75    
    ExtUtils::CBuilder  0.280236
    ExtUtils::Command   7.62    
    ExtUtils::Install   2.06    
    ExtUtils::MakeMaker 7.62    
    ExtUtils::Manifest  1.70    
    ExtUtils::ParseXS   3.35    
    File::Spec          3.75    
    JSON                4.03    
    JSON::PP            4.06    
    Module::Build       0.4231  
    Module::Signature   n/a     
    Parse::CPAN::Meta   1.4414  
    Test::Harness       3.42    
    Test::More          1.302188
    YAML                1.30    
    YAML::Syck          n/a     
    version             0.9929  


--

Summary of my perl5 (revision 5 version 8 subversion 9) configuration:
  Platform:
    osname=openbsd, osvers=6.9, archname=OpenBSD.amd64-openbsd
    uname='openbsd njh2.bandsman.co.uk 6.9 generic.mp#4 amd64 '
    config_args='-de -Dprefix=/home/njh/perl5/perlbrew/perls/perl-5.8.9 -Aeval:scriptdir=/home/njh/perl5/perlbrew/perls/perl-5.8.9/bin'
    hint=recommended, useposix=true, d_sigaction=define
    usethreads=undef use5005threads=undef useithreads=undef usemultiplicity=undef
    useperlio=define d_sfio=undef uselargefiles=define usesocks=undef
    use64bitint=define use64bitall=define uselongdouble=undef
    usemymalloc=n, bincompat5005=undef
  Compiler:
    cc='cc', ccflags ='-fno-strict-aliasing -pipe -I/usr/local/include',
    optimize='-O2',
    cppflags='-fno-strict-aliasing -pipe -I/usr/local/include'
    ccversion='', gccversion='OpenBSD Clang 10.0.1 ', gccosandvers=''
    intsize=4, longsize=8, ptrsize=8, doublesize=8, byteorder=12345678
    d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=16
    ivtype='long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
    alignbytes=8, prototype=define
  Linker and Libraries:
    ld='cc', ldflags ='-Wl,-E  -L/usr/local/lib'
    libpth=/usr/local/lib /usr/lib
    libs=-lm -lutil -lc
    perllibs=-lm -lutil -lc
    libc=/usr/lib/libc.so.96.0, so=so, useshrplib=false, libperl=libperl.a
    gnulibc_version=''
  Dynamic Linking:
    dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' '
    cccdlflags='-DPIC -fPIC ', lddlflags='-shared -fPIC  -L/usr/local/lib'


Characteristics of this binary (from libperl): 
  Compile-time options: PERL_MALLOC_WRAP USE_64_BIT_ALL USE_64_BIT_INT
                        USE_FAST_STDIO USE_LARGE_FILES USE_PERLIO
  Locally applied patches:
	Devel::PatchPerl 2.08
  Built under openbsd
  Compiled at Oct 21 2021 01:46:17
  %ENV:
    PERL5LIB=""
    PERL5OPT=""
    PERL5_CPANPLUS_IS_RUNNING="17835"
    PERL5_CPAN_IS_RUNNING="17835"
    PERLBREW_HOME="/home/njh/.perlbrew"
    PERLBREW_LIB=""
    PERLBREW_MANPATH="/home/njh/perl5/perlbrew/perls/perl-5.8.9/man"
    PERLBREW_PATH="/home/njh/perl5/perlbrew/bin:/home/njh/perl5/perlbrew/perls/perl-5.8.9/bin"
    PERLBREW_PERL="perl-5.8.9"
    PERLBREW_ROOT="/home/njh/perl5/perlbrew"
    PERLBREW_SHELLRC_VERSION="0.92"
    PERLBREW_VERSION="0.92"
    PERL_LOCAL_LIB_ROOT=""
    PERL_MM_USE_DEFAULT="1"
    PERL_USE_UNSAFE_INC="1"
  @INC:
    /home/njh/perl5/perlbrew/perls/perl-5.8.9/lib/5.8.9/OpenBSD.amd64-openbsd
    /home/njh/perl5/perlbrew/perls/perl-5.8.9/lib/5.8.9
    /home/njh/perl5/perlbrew/perls/perl-5.8.9/lib/site_perl/5.8.9/OpenBSD.amd64-openbsd
    /home/njh/perl5/perlbrew/perls/perl-5.8.9/lib/site_perl/5.8.9
    .