SQL-Translator v1.66 Perl 5 v5.40.0 OpenBSD.amd64-openbsd
- Status
- Pass
- From
- Nigel Horne
- Dist
-
SQL-Translator v1.66
- Platform
- Perl 5 v5.40.0 OpenBSD.amd64-openbsd
- Date
- 2025-01-15 04:34:14
- ID
- f9b5e8d6-d2f9-11ef-8615-d7af0c58fe55
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 Avishai Goldman,
This is a computer-generated report for SQL-Translator-1.66
on perl 5.40.0, 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:
this report is from an automated smoke testing program
and was not reviewed by a human for accuracy
------------------------------
PROGRAM OUTPUT
------------------------------
Output from '/usr/bin/make test':
Skip blib/lib/auto/share/dist/SQL-Translator/DiaUml/layer.tt2 (unchanged)
Skip blib/lib/auto/share/dist/SQL-Translator/DiaUml/uml-class.tt2 (unchanged)
Skip blib/lib/auto/share/dist/SQL-Translator/DiaUml/uml-class-start.tt2 (unchanged)
Skip blib/lib/auto/share/dist/SQL-Translator/DiaUml/diagram.tt2 (unchanged)
Skip blib/lib/auto/share/dist/SQL-Translator/PrecompiledParsers/Parse/RecDescent/DDL/SQLT/README (unchanged)
Skip blib/lib/auto/share/dist/SQL-Translator/DiaUml/uml-class-end.tt2 (unchanged)
Skip blib/lib/auto/share/dist/SQL-Translator/DiaUml/schema.tt2 (unchanged)
Skip blib/lib/auto/share/dist/SQL-Translator/DiaUml/uml-class-all.tt2 (unchanged)
Skip blib/lib/auto/share/dist/SQL-Translator/DiaUml/uml-attribute.tt2 (unchanged)
PERL_DL_NONLAZY=1 "/home/njh/perl5/perlbrew/perls/perl-5.40.0/bin/perl" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/02mysql-parser.t ...................... ok
t/03mysql-to-oracle.t ................... ok
t/04file,fh,string.t .................... ok
t/05bgep-re.t ........................... ok
t/06xsv.t ............................... skipped: Missing dependency: Text::RecordParser
t/07p_args.t ............................ ok
t/08postgres-to-mysql.t ................. ok
t/09sqlt-diagram.t ...................... skipped: Missing dependencies: GD, Graph::Directed, GD
t/10excel.t ............................. skipped: Missing dependency: Spreadsheet::ParseExcel
t/11normalize.t ......................... ok
t/12header_comment.t .................... ok
t/13schema.t ............................ ok
t/14postgres-parser.t ................... ok
t/15oracle-parser.t ..................... ok
t/16xml-parser.t ........................ ok
t/17sqlfxml-producer.t .................. ok
t/18ttschema-producer.t ................. ok
t/19sybase-parser.t ..................... ok
t/20format_X_name.t ..................... ok
t/23json.t .............................. ok
t/24yaml.t .............................. ok
t/25storable.t .......................... ok
t/26sybase.t ............................ ok
t/27sqlite-parser.t ..................... ok
t/29html.t .............................. skipped: Missing dependency: CGI
t/30sqlt-new-diff-mysql.t ............... ok
t/30sqlt-new-diff-pgsql.t ............... ok
t/30sqlt-new-diff-sqlite.t .............. ok
t/30sqlt-new-diff.t ..................... ok
t/31dumper.t ............................ ok
t/32schema-lookups.t .................... ok
t/33tt-table-producer.t ................. ok
t/34tt-base.t ........................... ok
t/35-access-parser.t .................... ok
t/36-filters.t .......................... ok
t/38-filter-names.t ..................... ok
t/38-mysql-producer.t ................... ok
t/39-filter-globals.t ................... ok
t/40oracle-parser-dbi.t ................. ok
t/43xml-to-db2.t ........................ ok
t/44-xml-to-db2-array.t ................. ok
t/45db2-producer.t ...................... ok
t/46xml-to-pg.t ......................... ok
t/47postgres-producer.t ................. ok
t/48xml-to-sqlite.t ..................... ok
t/49xml-to-pg-samefield.t ............... ok
t/50-sqlserver-parser.t ................. ok
t/51-xml-to-oracle.t .................... ok
t/51-xml-to-oracle_quoted.t ............. ok
t/52-oracle-options.t ................... ok
t/53-oracle-delay-constraints.t ......... ok
t/53-oracle-delay-constraints_quoted.t .. ok
t/54-oracle-alter-constraint.t .......... ok
t/54-oracle-alter-field.t ............... ok
t/54-oracle-sql-diff.t .................. ok
t/55-oracle-add-drop-field.t ............ ok
t/55-oracle-producer.t .................. ok
t/56-sqlite-producer.t .................. ok
t/57-class-dbi.t ........................ ok
t/60roundtrip.t ......................... ok
t/61translator_agnostic.t ............... ok
t/62roundtrip_datacheck.t ............... ok
t/63-spacial-pgsql.t .................... ok
t/64xml-to-mysql.t ...................... ok
t/66-postgres-dbi-parser.t .............. skipped: Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test, or install Test::PostgreSQL
t/70sqlt-diff_script.t .................. ok
t/70sqlt-diff_script_old.t .............. ok
t/71-generator-sql_server.t ............. ok
t/72-sqlite-add-drop-fields.t ........... ok
t/73-sqlite-respects-quote.t ............ ok
t/74-filename-arrayref.t ................ ok
t/75-sqlserver-producer.t ............... ok
t/mysql-sqlite-translate.t .............. ok
t/postgresql-rename-table-and-field.t ... skipped: Missing dependency: DBD::Pg
t/sqlite-rename-field.t ................. ok
All tests successful.
Test Summary Report
-------------------
t/60roundtrip.t (Wstat: 0 Tests: 100 Failed: 0)
TODO passed: 92, 94, 98, 100
Files=75, Tests=1986, 79 wallclock secs ( 0.57 usr 0.29 sys + 61.69 cusr 15.00 csys = 77.55 CPU)
Result: PASS
------------------------------
PREREQUISITES
------------------------------
Prerequisite modules loaded:
requires:
Module Need Have
----------------------- -------- --------
Carp::Clan 0 6.08
DBI 1.54 1.645
Digest::SHA 0 6.04
File::ShareDir 1.0 1.118
List::Util 1.33 1.66
Moo 1.000003 2.005005
Package::Variant 1.001001 1.003002
Parse::RecDescent 1.967009 1.967015
perl 5.008001 5.040000
Scalar::Util 0 1.66
Sub::Quote 0 2.006008
Try::Tiny 0.04 0.32
build_requires:
Module Need Have
----------------------- -------- --------
ExtUtils::MakeMaker 0 7.70
JSON::MaybeXS 1.003003 1.004008
Test::Differences 0 0.71
Test::Exception 0.42 0.43
Test::More 0.88 1.302207
Text::ParseWords 0 3.31
XML::Writer 0.500 0.900
YAML 0.66 1.31
configure_requires:
Module Need Have
----------------------- -------- --------
ExtUtils::MakeMaker 6.54 7.70
File::ShareDir::Install 0 0.14
opt_requires:
Module Need Have
----------------------- -------- --------
! GD 0 n/a
! Graph::Directed 0 n/a
! GraphViz 0 n/a
! Spreadsheet::ParseExcel 0.41 n/a
Template 2.20 3.102
! Text::RecordParser 0.02 n/a
XML::LibXML 1.69 2.0210
------------------------------
ENVIRONMENT AND OTHER CONTEXT
------------------------------
Environment variables:
AUTOMATED_TESTING = 1
PATH = /home/njh/perl5/perlbrew/bin:/home/njh/perl5/perlbrew/perls/perl-5.40.0/bin:/home/njh/perl5/perlbrew/bin:/home/njh/src/njh/smoker/bin:/usr/local/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/X11R6/bin:/usr/local/bin:/usr/local/sbin
PERL5LIB = /home/njh/.cpan/build/XML-Writer-0.900-0/blib/arch:/home/njh/.cpan/build/XML-Writer-0.900-0/blib/lib:/home/njh/.cpan/build/Package-Variant-1.003002-0/blib/arch:/home/njh/.cpan/build/Package-Variant-1.003002-0/blib/lib:/home/njh/.cpan/build/DBIx-Class-IntrospectableM2M-0.001002-0/blib/arch:/home/njh/.cpan/build/DBIx-Class-IntrospectableM2M-0.001002-0/blib/lib:/home/njh/.cpan/build/DBIx-Class-0.082843-0/blib/arch:/home/njh/.cpan/build/DBIx-Class-0.082843-0/blib/lib:/home/njh/.cpan/build/SQL-Abstract-Classic-1.91-0/blib/arch:/home/njh/.cpan/build/SQL-Abstract-Classic-1.91-0/blib/lib:/home/njh/.cpan/build/SQL-Abstract-2.000001-0/blib/arch:/home/njh/.cpan/build/SQL-Abstract-2.000001-0/blib/lib:/home/njh/.cpan/build/Hash-Merge-0.302-0/blib/arch:/home/njh/.cpan/build/Hash-Merge-0.302-0/blib/lib:/home/njh/.cpan/build/Clone-Choose-0.010-0/blib/arch:/home/njh/.cpan/build/Clone-Choose-0.010-0/blib/lib:/home/njh/.cpan/build/Context-Preserve-0.03-0/blib/arch:/home/njh/.cpan/build/Context-Preserve-0.03-0/blib/lib:/home/njh/.cpan/build/Class-C3-Componentised-1.001002-0/blib/arch:/home/njh/.cpan/build/Class-C3-Componentised-1.001002-0/blib/lib:/home/njh/.cpan/build/Class-C3-0.35-0/blib/arch:/home/njh/.cpan/build/Class-C3-0.35-0/blib/lib:/home/njh/.cpan/build/Algorithm-C3-0.11-0/blib/arch:/home/njh/.cpan/build/Algorithm-C3-0.11-0/blib/lib:/home/njh/.cpan/build/Class-Accessor-Grouped-0.10014-0/blib/arch:/home/njh/.cpan/build/Class-Accessor-Grouped-0.10014-0/blib/lib:/home/njh/.cpan/build/Config-INI-RefVars-0.20-0/blib/arch:/home/njh/.cpan/build/Config-INI-RefVars-0.20-0/blib/lib
PERL5OPT =
PERL5_CPANPLUS_IS_RUNNING = 13853
PERL5_CPAN_IS_RUNNING = 13853
PERL5_CPAN_IS_RUNNING_IN_RECURSION = 15065,13853
PERLBREW_LIB =
PERLBREW_MANPATH = /home/njh/perl5/perlbrew/perls/perl-5.40.0/man
PERLBREW_PATH = /home/njh/perl5/perlbrew/bin:/home/njh/perl5/perlbrew/perls/perl-5.40.0/bin
PERLBREW_PERL = perl-5.40.0
PERLBREW_ROOT = /home/njh/perl5/perlbrew
PERLBREW_SHELLRC_VERSION = 1.01
PERLBREW_VERSION = 1.01
PERL_LOCAL_LIB_ROOT =
PERL_MM_USE_DEFAULT = 1
PERL_USE_UNSAFE_INC = 1
SHELL = /usr/local/bin/bash
TMPDIR = /tmp/testwrapper.71405
Perl special variables (and OS-specific diagnostics, for MSWin32):
$^X = /home/njh/perl5/perlbrew/perls/perl-5.40.0/bin/perl
$UID/$EUID = 1000 / 1000
$GID = 1000 1000 0
$EGID = 1000 1000 0
Perl module toolchain versions installed:
Module Have
------------------- --------
CPAN 2.37
CPAN::Meta 2.150010
Cwd 3.90
ExtUtils::CBuilder 0.280240
ExtUtils::Command 7.70
ExtUtils::Install 2.22
ExtUtils::MakeMaker 7.70
ExtUtils::Manifest 1.75
ExtUtils::ParseXS 3.51
File::Spec 3.90
JSON 4.10
JSON::PP 4.16
Module::Build 0.4234
Module::Signature n/a
Parse::CPAN::Meta 2.150010
Test2 1.302207
Test::Harness 3.50
Test::More 1.302207
YAML 1.31
YAML::Syck 1.34
version 0.9933
--
Summary of my perl5 (revision 5 version 40 subversion 0) configuration:
Platform:
osname=openbsd
osvers=7.5
archname=OpenBSD.amd64-openbsd
uname='openbsd vultr2.bandsman.co.uk 7.5 generic#79 amd64 '
config_args='-de -Dprefix=/home/njh/perl5/perlbrew/perls/perl-5.40.0 -Aeval:scriptdir=/home/njh/perl5/perlbrew/perls/perl-5.40.0/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 ='-DNO_LOCALE_NUMERIC -DNO_LOCALE_COLLATE -DNO_LOCALE_MONETARY -DNO_LOCALE_TIME -DNO_LOCALE_MESSAGES -DLIBC_HANDLES_MISMATCHED_CTYPE -fno-strict-aliasing -pipe -fstack-protector-strong -I/usr/local/include'
optimize='-O2'
cppflags='-DNO_LOCALE_NUMERIC -DNO_LOCALE_COLLATE -DNO_LOCALE_MONETARY -DNO_LOCALE_TIME -DNO_LOCALE_MESSAGES -DLIBC_HANDLES_MISMATCHED_CTYPE -fno-strict-aliasing -pipe -fstack-protector-strong -I/usr/local/include'
ccversion=''
gccversion='OpenBSD Clang 16.0.6'
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 ='-Wl,-E -fstack-protector-strong -L/usr/local/lib'
libpth=/usr/lib/clang/16/lib /usr/lib /usr/local/lib
libs=-lpthread -lm -lutil -lc
perllibs=-lpthread -lm -lutil -lc
libc=/usr/lib/libc.so.99.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 -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_SAFE_PUTENV
USE_64_BIT_ALL
USE_64_BIT_INT
USE_LARGE_FILES
USE_LOCALE
USE_LOCALE_CTYPE
USE_PERLIO
USE_PERL_ATOF
Built under openbsd
Compiled at Jun 17 2024 09:52:22
%ENV:
PERL5LIB="/home/njh/.cpan/build/XML-Writer-0.900-0/blib/arch:/home/njh/.cpan/build/XML-Writer-0.900-0/blib/lib:/home/njh/.cpan/build/Package-Variant-1.003002-0/blib/arch:/home/njh/.cpan/build/Package-Variant-1.003002-0/blib/lib:/home/njh/.cpan/build/DBIx-Class-IntrospectableM2M-0.001002-0/blib/arch:/home/njh/.cpan/build/DBIx-Class-IntrospectableM2M-0.001002-0/blib/lib:/home/njh/.cpan/build/DBIx-Class-0.082843-0/blib/arch:/home/njh/.cpan/build/DBIx-Class-0.082843-0/blib/lib:/home/njh/.cpan/build/SQL-Abstract-Classic-1.91-0/blib/arch:/home/njh/.cpan/build/SQL-Abstract-Classic-1.91-0/blib/lib:/home/njh/.cpan/build/SQL-Abstract-2.000001-0/blib/arch:/home/njh/.cpan/build/SQL-Abstract-2.000001-0/blib/lib:/home/njh/.cpan/build/Hash-Merge-0.302-0/blib/arch:/home/njh/.cpan/build/Hash-Merge-0.302-0/blib/lib:/home/njh/.cpan/build/Clone-Choose-0.010-0/blib/arch:/home/njh/.cpan/build/Clone-Choose-0.010-0/blib/lib:/home/njh/.cpan/build/Context-Preserve-0.03-0/blib/arch:/home/njh/.cpan/build/Context-Preserve-0.03-0/blib/lib:/home/njh/.cpan/build/Class-C3-Componentised-1.001002-0/blib/arch:/home/njh/.cpan/build/Class-C3-Componentised-1.001002-0/blib/lib:/home/njh/.cpan/build/Class-C3-0.35-0/blib/arch:/home/njh/.cpan/build/Class-C3-0.35-0/blib/lib:/home/njh/.cpan/build/Algorithm-C3-0.11-0/blib/arch:/home/njh/.cpan/build/Algorithm-C3-0.11-0/blib/lib:/home/njh/.cpan/build/Class-Accessor-Grouped-0.10014-0/blib/arch:/home/njh/.cpan/build/Class-Accessor-Grouped-0.10014-0/blib/lib:/home/njh/.cpan/build/Config-INI-RefVars-0.20-0/blib/arch:/home/njh/.cpan/build/Config-INI-RefVars-0.20-0/blib/lib"
PERL5OPT=""
PERL5_CPANPLUS_IS_RUNNING="13853"
PERL5_CPAN_IS_RUNNING="13853"
PERL5_CPAN_IS_RUNNING_IN_RECURSION="15065,13853"
PERLBREW_LIB=""
PERLBREW_MANPATH="/home/njh/perl5/perlbrew/perls/perl-5.40.0/man"
PERLBREW_PATH="/home/njh/perl5/perlbrew/bin:/home/njh/perl5/perlbrew/perls/perl-5.40.0/bin"
PERLBREW_PERL="perl-5.40.0"
PERLBREW_ROOT="/home/njh/perl5/perlbrew"
PERLBREW_SHELLRC_VERSION="1.01"
PERLBREW_VERSION="1.01"
PERL_LOCAL_LIB_ROOT=""
PERL_MM_USE_DEFAULT="1"
PERL_USE_UNSAFE_INC="1"
@INC:
/home/njh/.cpan/build/XML-Writer-0.900-0/blib/arch
/home/njh/.cpan/build/XML-Writer-0.900-0/blib/lib
/home/njh/.cpan/build/Package-Variant-1.003002-0/blib/arch
/home/njh/.cpan/build/Package-Variant-1.003002-0/blib/lib
/home/njh/.cpan/build/DBIx-Class-IntrospectableM2M-0.001002-0/blib/arch
/home/njh/.cpan/build/DBIx-Class-IntrospectableM2M-0.001002-0/blib/lib
/home/njh/.cpan/build/DBIx-Class-0.082843-0/blib/arch
/home/njh/.cpan/build/DBIx-Class-0.082843-0/blib/lib
/home/njh/.cpan/build/SQL-Abstract-Classic-1.91-0/blib/arch
/home/njh/.cpan/build/SQL-Abstract-Classic-1.91-0/blib/lib
/home/njh/.cpan/build/SQL-Abstract-2.000001-0/blib/arch
/home/njh/.cpan/build/SQL-Abstract-2.000001-0/blib/lib
/home/njh/.cpan/build/Hash-Merge-0.302-0/blib/arch
/home/njh/.cpan/build/Hash-Merge-0.302-0/blib/lib
/home/njh/.cpan/build/Clone-Choose-0.010-0/blib/arch
/home/njh/.cpan/build/Clone-Choose-0.010-0/blib/lib
/home/njh/.cpan/build/Context-Preserve-0.03-0/blib/arch
/home/njh/.cpan/build/Context-Preserve-0.03-0/blib/lib
/home/njh/.cpan/build/Class-C3-Componentised-1.001002-0/blib/arch
/home/njh/.cpan/build/Class-C3-Componentised-1.001002-0/blib/lib
/home/njh/.cpan/build/Class-C3-0.35-0/blib/arch
/home/njh/.cpan/build/Class-C3-0.35-0/blib/lib
/home/njh/.cpan/build/Algorithm-C3-0.11-0/blib/arch
/home/njh/.cpan/build/Algorithm-C3-0.11-0/blib/lib
/home/njh/.cpan/build/Class-Accessor-Grouped-0.10014-0/blib/arch
/home/njh/.cpan/build/Class-Accessor-Grouped-0.10014-0/blib/lib
/home/njh/.cpan/build/Config-INI-RefVars-0.20-0/blib/arch
/home/njh/.cpan/build/Config-INI-RefVars-0.20-0/blib/lib
/home/njh/perl5/perlbrew/perls/perl-5.40.0/lib/site_perl/5.40.0/OpenBSD.amd64-openbsd
/home/njh/perl5/perlbrew/perls/perl-5.40.0/lib/site_perl/5.40.0
/home/njh/perl5/perlbrew/perls/perl-5.40.0/lib/5.40.0/OpenBSD.amd64-openbsd
/home/njh/perl5/perlbrew/perls/perl-5.40.0/lib/5.40.0
.