DBD-SQLite v1.76 Perl 5 v5.43.2 x86_64-linux

Status
Pass
From
John SJ Anderson
Dist
DBD-SQLite v1.76
Platform
Perl 5 v5.43.2 x86_64-linux
Date
2025-08-21 00:05:50
ID
98a2eb50-7e22-11f0-881c-f8aa05a44f5c
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 ISHIGAKI,

This is a computer-generated report for DBD-SQLite-1.76
on perl 5.43.2, created by App::cpanminus::reporter 0.22 (1.7048).

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 '':

Building and testing DBD-SQLite-1.76
cp lib/DBD/SQLite/VirtualTable/PerlData.pm blib/lib/DBD/SQLite/VirtualTable/PerlData.pm
cp lib/DBD/SQLite/GetInfo.pm blib/lib/DBD/SQLite/GetInfo.pm
cp lib/DBD/SQLite/Constants.pm blib/lib/DBD/SQLite/Constants.pm
cp lib/DBD/SQLite/Cookbook.pod blib/lib/DBD/SQLite/Cookbook.pod
cp lib/DBD/SQLite.pm blib/lib/DBD/SQLite.pm
cp lib/DBD/SQLite/VirtualTable.pm blib/lib/DBD/SQLite/VirtualTable.pm
cp lib/DBD/SQLite/Fulltext_search.pod blib/lib/DBD/SQLite/Fulltext_search.pod
cp lib/DBD/SQLite/VirtualTable/FileContent.pm blib/lib/DBD/SQLite/VirtualTable/FileContent.pm
Running Mkbootstrap for SQLite ()
chmod 644 "SQLite.bs"
"/opt/plenv/versions/5.43.2/bin/perl5.43.2" -MExtUtils::Command::MM -e 'cp_nonempty' -- SQLite.bs blib/arch/auto/DBD/SQLite/SQLite.bs 644
"/opt/plenv/versions/5.43.2/bin/perl5.43.2" -p -e "s/~DRIVER~/SQLite/g" /opt/plenv/versions/5.43.2/lib/perl5/site_perl/5.43.2/x86_64-linux/auto/DBI/Driver.xst > SQLite.xsi
"/opt/plenv/versions/5.43.2/bin/perl5.43.2" "/opt/plenv/versions/5.43.2/lib/perl5/5.43.2/ExtUtils/xsubpp"  -typemap '/opt/plenv/versions/5.43.2/lib/perl5/5.43.2/ExtUtils/typemap' -typemap '/home/genehack/.cpanm/work/1755730819.1777360/DBD-SQLite-1.76/typemap'  SQLite.xs > SQLite.xsc
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 48
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 66
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 79
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 95
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 111
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 126
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 138
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 152
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 163
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 216
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 241
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 252
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 263
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 274
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 308
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 330
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 344
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 358
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 372
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 384
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 395
Warning: ignoring 'static' type modifier: only valid with an XSUB name which includes a class in SQLite.xs, line 434
mv SQLite.xsc SQLite.c
cc -c  -I. -I/opt/plenv/versions/5.43.2/lib/perl5/site_perl/5.43.2/x86_64-linux/auto/DBI -fwrapv -fno-strict-aliasing -pipe -fstack-protector-strong -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_FORTIFY_SOURCE=2 -Wl,-Bsymbolic -O2   -DVERSION=\"1.76\" -DXS_VERSION=\"1.76\" -fPIC "-I/opt/plenv/versions/5.43.2/lib/perl5/5.43.2/x86_64-linux/CORE"  -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_MATH_FUNCTIONS -DNDEBUG=1 -DHAVE_USLEEP=1 SQLite.c
cc -c  -I. -I/opt/plenv/versions/5.43.2/lib/perl5/site_perl/5.43.2/x86_64-linux/auto/DBI -fwrapv -fno-strict-aliasing -pipe -fstack-protector-strong -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_FORTIFY_SOURCE=2 -Wl,-Bsymbolic -O2   -DVERSION=\"1.76\" -DXS_VERSION=\"1.76\" -fPIC "-I/opt/plenv/versions/5.43.2/lib/perl5/5.43.2/x86_64-linux/CORE"  -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_MATH_FUNCTIONS -DNDEBUG=1 -DHAVE_USLEEP=1 dbdimp.c
cc -c  -I. -I/opt/plenv/versions/5.43.2/lib/perl5/site_perl/5.43.2/x86_64-linux/auto/DBI -fwrapv -fno-strict-aliasing -pipe -fstack-protector-strong -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_FORTIFY_SOURCE=2 -Wl,-Bsymbolic -O2   -DVERSION=\"1.76\" -DXS_VERSION=\"1.76\" -fPIC "-I/opt/plenv/versions/5.43.2/lib/perl5/5.43.2/x86_64-linux/CORE"  -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_MATH_FUNCTIONS -DNDEBUG=1 -DHAVE_USLEEP=1 sqlite3.c
rm -f blib/arch/auto/DBD/SQLite/SQLite.so
cc  -shared -O2 -L/usr/local/lib -fstack-protector-strong -Wl,-Bsymbolic  SQLite.o dbdimp.o sqlite3.o  -o blib/arch/auto/DBD/SQLite/SQLite.so  \
      \
  
chmod 755 blib/arch/auto/DBD/SQLite/SQLite.so
Manifying 7 pod documents
"/opt/plenv/versions/5.43.2/bin/perl5.43.2" -MExtUtils::Command::MM -e 'cp_nonempty' -- SQLite.bs blib/arch/auto/DBD/SQLite/SQLite.bs 644
PERL_DL_NONLAZY=1 "/opt/plenv/versions/5.43.2/bin/perl5.43.2" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(0, 'blib/lib', 'blib/arch')" t/*.t t/*/*.t
# $DBI::VERSION=1.647
# Compile Options:
#   ATOMIC_INTRINSICS=1
#   COMPILER=gcc-14.2.0
#   DEFAULT_AUTOVACUUM
#   DEFAULT_CACHE_SIZE=-2000
#   DEFAULT_FILE_FORMAT=4
#   DEFAULT_JOURNAL_SIZE_LIMIT=-1
#   DEFAULT_MMAP_SIZE=0
#   DEFAULT_PAGE_SIZE=4096
#   DEFAULT_PCACHE_INITSZ=20
#   DEFAULT_RECURSIVE_TRIGGERS
#   DEFAULT_SECTOR_SIZE=4096
#   DEFAULT_SYNCHRONOUS=2
#   DEFAULT_WAL_AUTOCHECKPOINT=1000
#   DEFAULT_WAL_SYNCHRONOUS=2
#   DEFAULT_WORKER_THREADS=0
#   DIRECT_OVERFLOW_READ
#   ENABLE_COLUMN_METADATA
#   ENABLE_FTS3
#   ENABLE_FTS3_PARENTHESIS
#   ENABLE_FTS4
#   ENABLE_FTS5
#   ENABLE_MATH_FUNCTIONS
#   ENABLE_RTREE
#   MALLOC_SOFT_LIMIT=1024
#   MAX_ATTACHED=10
#   MAX_COLUMN=2000
#   MAX_COMPOUND_SELECT=500
#   MAX_DEFAULT_PAGE_SIZE=8192
#   MAX_EXPR_DEPTH=1000
#   MAX_FUNCTION_ARG=127
#   MAX_LENGTH=1000000000
#   MAX_LIKE_PATTERN_LENGTH=50000
#   MAX_MMAP_SIZE=0x7fff0000
#   MAX_PAGE_COUNT=0xfffffffe
#   MAX_PAGE_SIZE=65536
#   MAX_SQL_LENGTH=1000000000
#   MAX_TRIGGER_DEPTH=1000
#   MAX_VARIABLE_NUMBER=32766
#   MAX_VDBE_OP=250000000
#   MAX_WORKER_THREADS=8
#   MUTEX_PTHREADS
#   SYSTEM_MALLOC
#   TEMP_STORE=1
#   THREADSAFE=1
t/01_compile.t ........................................ ok
# sqlite_version=3.46.1
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=3863, 16 wallclock secs ( 0.34 usr  0.12 sys +  6.44 cusr  1.15 csys =  8.05 CPU)
Result: PASS

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

Prerequisite modules loaded:

runtime:

    Module              Need  Have    
    ------------------- ----- --------
    DBI                 1.57  1.647   
    File::Spec          0.82  3.94    
    perl                5.006 5.043002
    Test::More          0.88  1.302214
    Tie::Hash           0     1.06    

build:

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

configure:

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


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

Environment variables:

    LANG = en_US.UTF-8
    LC_ALL = en_US.UTF-8
    LC_TERMINAL = iTerm2
    LC_TERMINAL_VERSION = 3.5.10
    PATH = /opt/plenv/versions/5.43.2/bin:/opt/plenv/libexec:/opt/plenv/plugins/perl-build/bin:/opt/local/bin:/home/genehack/bin:/opt/miniconda3/condabin:/opt/plenv/shims:/opt/plenv/bin:/opt/go/bin:/opt/git/bin:/opt/emacs/bin:/opt/local/bin:/usr/local/bin:/usr/bin:/bin:/usr/games:/opt/rust/cargo/bin
    PERL_CPANM_OPT = --skip-installed --prompt
    SHELL = /bin/zsh
    TERM = screen-256color

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

    EGID = 1001 113 122 1001
    EUID = 1001
    EXECUTABLE_NAME = /opt/plenv/versions/5.43.2/bin/perl5.43.2
    GID = 1001 113 122 1001
    UID = 1001

Perl module toolchain versions installed:

    Module              Have    
    ------------------- --------
    CPAN                2.38    
    CPAN::Meta          2.150010
    Cwd                 3.94    
    ExtUtils::CBuilder  0.280242
    ExtUtils::Command   7.76    
    ExtUtils::Install   2.22    
    ExtUtils::MakeMaker 7.76    
    ExtUtils::Manifest  1.75    
    ExtUtils::ParseXS   3.59    
    File::Spec          3.94    
    JSON                4.10    
    JSON::PP            4.16    
    Module::Build       0.4234  
    Module::Signature   n/a     
    Parse::CPAN::Meta   2.150010
    Test::Harness       3.52    
    Test::More          1.302214
    YAML                1.31    
    YAML::Syck          n/a     
    version             0.9933  


--

Summary of my perl5 (revision 5 version 43 subversion 2) configuration:
   
  Platform:
    osname=linux
    osvers=5.10.0-20-amd64
    archname=x86_64-linux
    uname='linux doof 5.10.0-20-amd64 #1 smp debian 5.10.158-2 (2022-12-13) x86_64 gnulinux '
    config_args='-Dprefix=/opt/plenv/versions/5.43.2 -de -Dversiononly -Dusedevel -A'eval:scriptdir=/opt/plenv/versions/5.43.2/bin''
    hint=recommended
    useposix=true
    d_sigaction=define
    useithreads=undef
    usemultiplicity=undef
    use64bitint=define
    use64bitall=define
    uselongdouble=undef
    usemymalloc=n
    default_inc_excludes_dot=define
  Compiler:
    cc='cc'
    ccflags ='-fwrapv -fno-strict-aliasing -pipe -fstack-protector-strong -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -D_FORTIFY_SOURCE=2'
    optimize='-O2'
    cppflags='-fwrapv -fno-strict-aliasing -pipe -fstack-protector-strong -I/usr/local/include'
    ccversion=''
    gccversion='14.2.0'
    gccosandvers=''
    intsize=4
    longsize=8
    ptrsize=8
    doublesize=8
    byteorder=12345678
    doublekind=3
    d_longlong=define
    longlongsize=8
    d_longdbl=define
    longdblsize=16
    longdblkind=3
    ivtype='long'
    ivsize=8
    nvtype='double'
    nvsize=8
    Off_t='off_t'
    lseeksize=8
    alignbytes=8
    prototype=define
  Linker and Libraries:
    ld='cc'
    ldflags =' -fstack-protector-strong -L/usr/local/lib'
    libpth=/usr/local/lib /usr/lib/x86_64-linux-gnu /usr/lib /usr/lib64
    libs=-lpthread -lgdbm -ldl -lm -lcrypt -lutil -lc
    perllibs=-lpthread -ldl -lm -lcrypt -lutil -lc
    libc=/lib/x86_64-linux-gnu/libc.so.6
    so=so
    useshrplib=false
    libperl=libperl.a
    gnulibc_version='2.41'
  Dynamic Linking:
    dlsrc=dl_dlopen.xs
    dlext=so
    d_dlsymun=undef
    ccdlflags='-Wl,-E'
    cccdlflags='-fPIC'
    lddlflags='-shared -O2 -L/usr/local/lib -fstack-protector-strong'


Characteristics of this binary (from libperl): 
  Compile-time options:
    HAS_LONG_DOUBLE
    HAS_STRTOLD
    HAS_TIMES
    PERLIO_LAYERS
    PERL_COPY_ON_WRITE
    PERL_DONT_CREATE_GVSV
    PERL_HASH_FUNC_SIPHASH13
    PERL_HASH_USE_SBOX32
    PERL_MALLOC_WRAP
    PERL_OP_PARENT
    PERL_PRESERVE_IVUV
    PERL_USE_DEVEL
    PERL_USE_SAFE_PUTENV
    USE_64_BIT_ALL
    USE_64_BIT_INT
    USE_LARGE_FILES
    USE_LOCALE
    USE_LOCALE_COLLATE
    USE_LOCALE_CTYPE
    USE_LOCALE_NUMERIC
    USE_LOCALE_TIME
    USE_PERLIO
    USE_PERL_ATOF
  Built under linux
  Compiled at Aug 20 2025 15:38:45
  %ENV:
    PERL_CPANM_OPT="--skip-installed --prompt"
  @INC:
    /opt/plenv/versions/5.43.2/lib/perl5/site_perl/5.43.2/x86_64-linux
    /opt/plenv/versions/5.43.2/lib/perl5/site_perl/5.43.2
    /opt/plenv/versions/5.43.2/lib/perl5/5.43.2/x86_64-linux
    /opt/plenv/versions/5.43.2/lib/perl5/5.43.2