DBD-SQLite v1.76 Perl 5 v5.24.4 amd64-freebsd-thread-multi-ld
- Status
- Pass
- From
- Nigel Horne
- Dist
-
DBD-SQLite v1.76
- Platform
- Perl 5 v5.24.4 amd64-freebsd-thread-multi-ld
- Date
- 2025-08-20 13:05:32
- ID
- 5a6b51a8-7dc6-11f0-8bc0-9dad6c498f4b
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.76
on perl 5.24.4, created by CPAN-Reporter-1.2020.
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':
Running Mkbootstrap for DBD::SQLite ()
chmod 644 "SQLite.bs"
PERL_DL_NONLAZY=1 "/home/njh/perl5/perlbrew/perls/perl-5.24.4-thread-multi-ld/bin/perl5.24.4" "-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=clang-19.1.7
# 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/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/08_busy.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/28_schemachange.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/44_rtree.t .......................................... ok
t/45_savepoints.t ..................................... ok
t/46_mod_perl.t ....................................... skipped: requires APR::Table
t/43_fts3.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/47_execute.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_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_32889_prepare_cached_reexecute.t ................. ok
t/rt_50503_fts3.t ..................................... ok
t/rt_53235_icu_compatibility.t ........................ skipped: requires SQLite ICU plugin to be enabled
t/rt_52573_manual_exclusive_lock.t .................... ok
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_77724_primary_key_with_a_whitespace.t ............ ok
t/rt_76395_int_overflow.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/02_find_function.t .................... ok
t/virtual_table/10_filecontent.t ...................... ok
t/virtual_table/01_destroy.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
t/virtual_table/11_filecontent_fulltext.t ............. ok
All tests successful.
Files=113, Tests=3863, 12 wallclock secs ( 0.45 usr 0.14 sys + 5.89 cusr 1.07 csys = 7.55 CPU)
Result: PASS
------------------------------
PREREQUISITES
------------------------------
Prerequisite modules loaded:
requires:
Module Need Have
------------------- ----- --------
DBI 1.57 1.647
File::Spec 0.82 3.75
perl 5.006 5.024004
Test::More 0.88 1.302214
Tie::Hash 0 1.05
build_requires:
Module Need Have
------------------- ----- --------
ExtUtils::MakeMaker 0 7.10_02
configure_requires:
Module Need Have
------------------- ----- --------
DBI 1.57 1.647
ExtUtils::MakeMaker 6.48 7.10_02
File::Spec 0.82 3.75
------------------------------
ENVIRONMENT AND OTHER CONTEXT
------------------------------
Environment variables:
HARNESS_OPTIONS = j2:c
LANG = C.UTF-8
PATH = /home/njh/perl5/perlbrew/bin:/home/njh/perl5/perlbrew/perls/perl-5.24.4-thread-multi-ld/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/local/sbin:/usr/local/bin:/home/njh/bin
PERL5LIB =
PERL5OPT =
PERL5_CPANPLUS_IS_RUNNING = 90145
PERL5_CPAN_IS_RUNNING = 90145
PERLBREW_HOME = /home/njh/.perlbrew
PERLBREW_MANPATH = /home/njh/perl5/perlbrew/perls/perl-5.24.4-thread-multi-ld/man
PERLBREW_PATH = /home/njh/perl5/perlbrew/bin:/home/njh/perl5/perlbrew/perls/perl-5.24.4-thread-multi-ld/bin
PERLBREW_PERL = perl-5.24.4-thread-multi-ld
PERLBREW_ROOT = /home/njh/perl5/perlbrew
PERLBREW_SHELLRC_VERSION = 1.02
PERLBREW_VERSION = 1.02
SHELL = /usr/local/bin/bash
TERM = xterm
TMPDIR = /tmp
Perl special variables (and OS-specific diagnostics, for MSWin32):
$^X = /home/njh/perl5/perlbrew/perls/perl-5.24.4-thread-multi-ld/bin/perl5.24.4
$UID/$EUID = 1000 / 1000
$GID = 1000 1000 0
$EGID = 1000 1000 0
Perl module toolchain versions installed:
Module Have
------------------- ----------
CPAN 2.38
CPAN::Meta 2.150005
Cwd 3.75
ExtUtils::CBuilder 0.280225
ExtUtils::Command 7.10_02
ExtUtils::Install 2.22
ExtUtils::MakeMaker 7.10_02
ExtUtils::Manifest 1.70
ExtUtils::ParseXS 3.31
File::Spec 3.75
JSON n/a
JSON::PP 2.27300_01
Module::Build 0.4234
Module::Signature n/a
Parse::CPAN::Meta 1.4417_001
Test2 1.302214
Test::Harness 3.36_01
Test::More 1.302214
YAML 1.31
YAML::Syck 1.34
version 0.9916
--
Summary of my perl5 (revision 5 version 24 subversion 4) configuration:
Platform:
osname=freebsd, osvers=14.3-release-p2, archname=amd64-freebsd-thread-multi-ld
uname='freebsd michele.bandsman.co.uk 14.3-release-p2 freebsd 14.3-release-p2 generic amd64 '
config_args='-de -Dprefix=/home/njh/perl5/perlbrew/perls/perl-5.24.4-thread-multi-ld -Dusedevel -Dusethreads -Dusemultiplicity -Duselongdouble -Accflags=-O2 -W -Wformat=2 -Wswitch -Wshadow -Wwrite-strings -Wuninitialized -Wall -pipe -fomit-frame-pointer -pedantic -D_FORTIFY_SOURCE=2 -Wpointer-arith -Wstrict-prototypes -fstack-protector -Wstack-protector -Wextra -Wbad-function-cast -Wcast-align -Wcast-qual -Wdisabled-optimization -Wendif-labels -Wfloat-equal -Wformat-nonliteral -Winline -Wmissing-declarations -Wmissing-prototypes -Wnested-externs -Wpointer-arith -Wundef -Wformat-security -ftree-vectorize -mtune=native -fdiagnostics-color=auto -flto -mtune=native -march=native -Aeval:scriptdir=/home/njh/perl5/perlbrew/perls/perl-5.24.4-thread-multi-ld/bin'
hint=recommended, useposix=true, d_sigaction=define
useithreads=define, usemultiplicity=define
use64bitint=define, use64bitall=define, uselongdouble=define
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -O2 -W -Wformat=2 -Wswitch -Wshadow -Wwrite-strings -Wuninitialized -Wall -pipe -fomit-frame-pointer -pedantic -D_FORTIFY_SOURCE=2 -Wpointer-arith -Wstrict-prototypes -fstack-protector -Wstack-protector -Wextra -Wbad-function-cast -Wcast-align -Wcast-qual -Wdisabled-optimization -Wendif-labels -Wfloat-equal -Wformat-nonliteral -Winline -Wmissing-declarations -Wmissing-prototypes -Wnested-externs -Wpointer-arith -Wundef -Wformat-security -ftree-vectorize -mtune=native -fdiagnostics-color=auto -flto -mtune=native -march=native -fno-strict-aliasing -fstack-protector-strong -I/usr/local/include',
optimize='-O2',
cppflags='-DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -O2 -W -Wformat=2 -Wswitch -Wshadow -Wwrite-strings -Wuninitialized -Wall -pipe -fomit-frame-pointer -pedantic -D_FORTIFY_SOURCE=2 -Wpointer-arith -Wstrict-prototypes -fstack-protector -Wstack-protector -Wextra -Wbad-function-cast -Wcast-align -Wcast-qual -Wdisabled-optimization -Wendif-labels -Wfloat-equal -Wformat-nonliteral -Winline -Wmissing-declarations -Wmissing-prototypes -Wnested-externs -Wpointer-arith -Wundef -Wformat-security -ftree-vectorize -mtune=native -fdiagnostics-color=auto -flto -mtune=native -march=native -fno-strict-aliasing -fstack-protector-strong -I/usr/local/include'
ccversion='', gccversion='FreeBSD Clang 19.1.7 (https://github.com/llvm/llvm-project.git llvmorg-19.1.7-0-gcd708029e0b2)', 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='long double', nvsize=16, Off_t='off_t', lseeksize=8
alignbytes=16, prototype=define
Linker and Libraries:
ld='cc', ldflags ='-pthread -Wl,-E -fstack-protector-strong -L/usr/local/lib'
libpth=/usr/lib /usr/local/lib /usr/lib/clang/19/lib /usr/lib
libs=-lpthread -ldl -lm -lcrypt -lutil
perllibs=-lpthread -ldl -lm -lcrypt -lutil
libc=, 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 -L/usr/local/lib -fstack-protector-strong'
Characteristics of this binary (from libperl):
Compile-time options: HAS_TIMES MULTIPLICITY PERLIO_LAYERS
PERL_COPY_ON_WRITE PERL_DONT_CREATE_GVSV
PERL_HASH_FUNC_ONE_AT_A_TIME_HARD
PERL_IMPLICIT_CONTEXT PERL_MALLOC_WRAP
PERL_PRESERVE_IVUV PERL_USE_DEVEL USE_64_BIT_ALL
USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES
USE_LOCALE USE_LOCALE_COLLATE USE_LOCALE_CTYPE
USE_LOCALE_NUMERIC USE_LOCALE_TIME USE_LONG_DOUBLE
USE_PERLIO USE_PERL_ATOF USE_REENTRANT_API
Locally applied patches:
Devel::PatchPerl 2.08
Built under freebsd
Compiled at Aug 17 2025 17:58:25
%ENV:
PERL5LIB=""
PERL5OPT=""
PERL5_CPANPLUS_IS_RUNNING="90145"
PERL5_CPAN_IS_RUNNING="90145"
PERLBREW_HOME="/home/njh/.perlbrew"
PERLBREW_MANPATH="/home/njh/perl5/perlbrew/perls/perl-5.24.4-thread-multi-ld/man"
PERLBREW_PATH="/home/njh/perl5/perlbrew/bin:/home/njh/perl5/perlbrew/perls/perl-5.24.4-thread-multi-ld/bin"
PERLBREW_PERL="perl-5.24.4-thread-multi-ld"
PERLBREW_ROOT="/home/njh/perl5/perlbrew"
PERLBREW_SHELLRC_VERSION="1.02"
PERLBREW_VERSION="1.02"
@INC:
/home/njh/perl5/perlbrew/perls/perl-5.24.4-thread-multi-ld/lib/site_perl/5.24.4/amd64-freebsd-thread-multi-ld
/home/njh/perl5/perlbrew/perls/perl-5.24.4-thread-multi-ld/lib/site_perl/5.24.4
/home/njh/perl5/perlbrew/perls/perl-5.24.4-thread-multi-ld/lib/5.24.4/amd64-freebsd-thread-multi-ld
/home/njh/perl5/perlbrew/perls/perl-5.24.4-thread-multi-ld/lib/5.24.4
.