Back
From: metabase:user:0d96120c-29e2-11e5-b049-ede3035d37de
Subject: FAIL SQL-Interpolate-0.33 v5.20.2 GNU/Linux
Date: 2015-07-25T04:00:15Z
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 David Manura,
This is a computer-generated report for SQL-Interpolate-0.33
on perl 5.20.2, created by CPAN-Reporter-1.2014.
Thank you for uploading your work to CPAN. However, there was a problem
testing your distribution.
If you think this report is invalid, please consult the CPAN Testers Wiki
for suggestions on how to avoid getting FAIL reports for missing library
or binary dependencies, unsupported operating systems, and so on:
http://wiki.cpantesters.org/wiki/CPANAuthorNotes
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 './Build test':
t/dbi.t ........... ok
t/dbi_filter.t .... ok
t/dbi_interp.t .... ok
t/dist.t .......... ok
t/filter.t ........ ok
t/macro.t ......... ok
t/pod-coverage.t .. ok
t/pod.t ........... ok
# Failed test 'INSERT hashref of sql_var + sql()'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'INSERT INTO mytable (one, two, three) VALUES(?, ?, 3)'
# $expected->[0] = 'INSERT INTO mytable (two, one, three) VALUES(?, ?, 3)'
$VAR1 = [
'INSERT INTO mytable (one, two, three) VALUES(?, ?, 3)',
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
],
[
5,
bless( {
'value' => \5,
'type' => 1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR2 = [
'INSERT INTO mytable (two, one, three) VALUES(?, ?, 3)',
[
5,
$VAR1->[2][1]
],
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR3 = 'INSERT hashref of sql_var + sql()';
# Failed test 'INSERT hashref of sql_var + sql() OO'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'INSERT INTO mytable (two, one, three) VALUES( ?, ?, 3)'
# $expected->[0] = 'INSERT INTO mytable (two, one, three) VALUES(?, ?, 3)'
$VAR1 = [
'INSERT INTO mytable (two, one, three) VALUES( ?, ?, 3)',
[
5,
bless( {
'value' => \5,
'type' => 1
}, 'SQL::Interpolate::Variable' )
],
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR2 = [
'INSERT INTO mytable (two, one, three) VALUES(?, ?, 3)',
[
5,
$VAR1->[1][1]
],
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR3 = 'INSERT hashref of sql_var + sql() OO';
# Failed test 'INSERT hashref of sql_var + sql() closure'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'INSERT INTO mytable (three, two, one) VALUES(3, ?, ?)'
# $expected->[0] = 'INSERT INTO mytable (two, one, three) VALUES(?, ?, 3)'
$VAR1 = [
'INSERT INTO mytable (three, two, one) VALUES(3, ?, ?)',
[
5,
bless( {
'value' => \5,
'type' => 1
}, 'SQL::Interpolate::Variable' )
],
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR2 = [
'INSERT INTO mytable (two, one, three) VALUES(?, ?, 3)',
[
5,
$VAR1->[1][1]
],
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR3 = 'INSERT hashref of sql_var + sql() closure';
# Failed test 'INSERT hashref of sql_var + sql() closure2'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'INSERT INTO mytable (three, two, one) VALUES(3, ?, ?)'
# $expected->[0] = 'INSERT INTO mytable (two, one, three) VALUES(?, ?, 3)'
$VAR1 = [
'INSERT INTO mytable (three, two, one) VALUES(3, ?, ?)',
[
5,
bless( {
'value' => \5,
'type' => 1
}, 'SQL::Interpolate::Variable' )
],
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR2 = [
'INSERT INTO mytable (two, one, three) VALUES(?, ?, 3)',
[
5,
$VAR1->[1][1]
],
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR3 = 'INSERT hashref of sql_var + sql() closure2';
# Failed test 'INSERT hashref with macro OO'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'INSERT INTO mytable (two, one) VALUES( ? * ?, ?)'
# $expected->[0] = 'INSERT INTO mytable (one, two) VALUES(?, ? * ?)'
$VAR1 = [
'INSERT INTO mytable (two, one) VALUES( ? * ?, ?)',
5,
5,
1
];
$VAR2 = [
'INSERT INTO mytable (one, two) VALUES(?, ? * ?)',
1,
5,
5
];
$VAR3 = 'INSERT hashref with macro OO';
# Failed test 'INSERT hashref with macro closure'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'INSERT INTO mytable (two, one) VALUES( ? * ?, ?)'
# $expected->[0] = 'INSERT INTO mytable (one, two) VALUES(?, ? * ?)'
$VAR1 = [
'INSERT INTO mytable (two, one) VALUES( ? * ?, ?)',
5,
5,
1
];
$VAR2 = [
'INSERT INTO mytable (one, two) VALUES(?, ? * ?)',
1,
5,
5
];
$VAR3 = 'INSERT hashref with macro closure';
# Failed test 'SET hashref of sql_var types, sql()'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'UPDATE mytable SET two= ?, one=?, three=3'
# $expected->[0] = 'UPDATE mytable SET three=3, one=?, two= ?'
$VAR1 = [
'UPDATE mytable SET two= ?, one=?, three=3',
[
5,
bless( {
'value' => \5,
'type' => 1
}, 'SQL::Interpolate::Variable' )
],
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR2 = [
'UPDATE mytable SET three=3, one=?, two= ?',
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
],
[
5,
$VAR1->[1][1]
]
];
$VAR3 = 'SET hashref of sql_var types, sql()';
# Failed test 'SET hashref of sql_var types, sql() OO'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'UPDATE mytable SET three=3, two= ?, one=?'
# $expected->[0] = 'UPDATE mytable SET three=3, one=?, two= ?'
$VAR1 = [
'UPDATE mytable SET three=3, two= ?, one=?',
[
5,
bless( {
'value' => \5,
'type' => 1
}, 'SQL::Interpolate::Variable' )
],
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR2 = [
'UPDATE mytable SET three=3, one=?, two= ?',
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
],
[
5,
$VAR1->[1][1]
]
];
$VAR3 = 'SET hashref of sql_var types, sql() OO';
# Failed test 'SET hashref of sql_var types, sql() closure2'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'UPDATE mytable SET three=3, two= ?, one=?'
# $expected->[0] = 'UPDATE mytable SET three=3, one=?, two= ?'
$VAR1 = [
'UPDATE mytable SET three=3, two= ?, one=?',
[
5,
bless( {
'value' => \5,
'type' => 1
}, 'SQL::Interpolate::Variable' )
],
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR2 = [
'UPDATE mytable SET three=3, one=?, two= ?',
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
],
[
5,
$VAR1->[1][1]
]
];
$VAR3 = 'SET hashref of sql_var types, sql() closure2';
# Failed test 'WHERE hashref sql() closure2'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'WHERE (y=2 AND x=?)'
# $expected->[0] = 'WHERE (x=? AND y=2)'
$VAR1 = [
'WHERE (y=2 AND x=?)',
1
];
$VAR2 = [
'WHERE (x=? AND y=2)',
1
];
$VAR3 = 'WHERE hashref sql() closure2';
# Failed test 'WHERE hashref of \$x, sql_var typed OO'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'WHERE (x=? AND y= ?) AND z= ?'
# $expected->[0] = 'WHERE (y= ? AND x=?) AND z= ?'
$VAR1 = [
'WHERE (x=? AND y= ?) AND z= ?',
[
5,
bless( {
'value' => \5
}, 'SQL::Interpolate::Variable' )
],
[
5,
bless( {
'value' => \5,
'type' => 1
}, 'SQL::Interpolate::Variable' )
],
[
5,
bless( {
'value' => \5
}, 'SQL::Interpolate::Variable' )
]
];
$VAR2 = [
'WHERE (y= ? AND x=?) AND z= ?',
[
5,
$VAR1->[2][1]
],
[
5,
bless( {
'value' => $VAR1->[2][1]{'value'}
}, 'SQL::Interpolate::Variable' )
],
[
5,
bless( {
'value' => $VAR1->[2][1]{'value'}
}, 'SQL::Interpolate::Variable' )
]
];
$VAR3 = 'WHERE hashref of \\$x, sql_var typed OO';
# Failed test 'WHERE hashref of arrayref of sql_var typed'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'WHERE (x=? AND y IN (?, ?))'
# $expected->[0] = 'WHERE (y IN (?, ?) AND x=?)'
$VAR1 = [
'WHERE (x=? AND y IN (?, ?))',
[
5,
bless( {
'value' => \5
}, 'SQL::Interpolate::Variable' )
],
[
3,
bless( {
'value' => \3
}, 'SQL::Interpolate::Variable' )
],
[
5,
bless( {
'value' => \5,
'type' => 1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR2 = [
'WHERE (y IN (?, ?) AND x=?)',
[
3,
bless( {
'value' => \3
}, 'SQL::Interpolate::Variable' )
],
[
5,
$VAR1->[3][1]
],
[
5,
bless( {
'value' => $VAR1->[3][1]{'value'}
}, 'SQL::Interpolate::Variable' )
]
];
$VAR3 = 'WHERE hashref of arrayref of sql_var typed';
# Failed test 'WHERE hashref of \$x, sql() closure'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'WHERE (x=? AND y=z)'
# $expected->[0] = 'WHERE (y=z AND x=?)'
$VAR1 = [
'WHERE (x=? AND y=z)',
5
];
$VAR2 = [
'WHERE (y=z AND x=?)',
5
];
$VAR3 = 'WHERE hashref of \\$x, sql() closure';
# Failed test 'v of identity_macro(h 2)'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'FROM (SELECT ? AS two, ? AS one) AS tbl0'
# $expected->[0] = 'FROM (SELECT ? AS one, ? AS two) AS tbl0'
$VAR1 = [
'FROM (SELECT ? AS two, ? AS one) AS tbl0',
2,
1
];
$VAR2 = [
'FROM (SELECT ? AS one, ? AS two) AS tbl0',
1,
2
];
$VAR3 = 'v of identity_macro(h 2)';
# Failed test 'v of identity_macro(h 2) OO'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'FROM (SELECT ? AS two, ? AS one) AS tbl0'
# $expected->[0] = 'FROM (SELECT ? AS one, ? AS two) AS tbl0'
$VAR1 = [
'FROM (SELECT ? AS two, ? AS one) AS tbl0',
2,
1
];
$VAR2 = [
'FROM (SELECT ? AS one, ? AS two) AS tbl0',
1,
2
];
$VAR3 = 'v of identity_macro(h 2) OO';
# Failed test 'v of identity_macro(h 2) closure'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'FROM (SELECT ? AS two, ? AS one) AS tbl0'
# $expected->[0] = 'FROM (SELECT ? AS one, ? AS two) AS tbl0'
$VAR1 = [
'FROM (SELECT ? AS two, ? AS one) AS tbl0',
2,
1
];
$VAR2 = [
'FROM (SELECT ? AS one, ? AS two) AS tbl0',
1,
2
];
$VAR3 = 'v of identity_macro(h 2) closure';
# Looks like you failed 16 tests of 262.
t/sql_interp.t ....
Dubious, test returned 16 (wstat 4096, 0x1000)
Failed 16/262 subtests
Test Summary Report
-------------------
t/sql_interp.t (Wstat: 4096 Tests: 262 Failed: 16)
Failed tests: 66-69, 71-72, 122-123, 125, 137, 155, 158
164, 243-245
Non-zero exit status: 16
Files=9, Tests=353, 1 wallclock secs ( 0.05 usr 0.01 sys + 0.41 cusr 0.04 csys = 0.51 CPU)
Result: FAIL
Failed 1/9 test programs. 16/353 subtests failed.
------------------------------
PREREQUISITES
------------------------------
Prerequisite modules loaded:
opt_requires:
Module Need Have
-------------- ---- ----
Filter::Simple 0 0.91
Text::Balanced 1.87 2.02
------------------------------
ENVIRONMENT AND OTHER CONTEXT
------------------------------
Environment variables:
AUTOMATED_TESTING = 1
LANG = en_US.UTF-8
NONINTERACTIVE_TESTING = 1
PATH = /home/perltest/sysperl/bin:/home/perltest/perl5/perlbrew/bin:/home/perltest/perl5/perlbrew/perls/perl-5.20.2/bin:/home/perltest/perltest/bin:/home/perltest/perl5/perlbrew/bin:/home/perltest/perl5/perlbrew/perls/perl-5.18.4-ld/bin:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/local/games:/home/perltest/perltest/bin
PERL5LIB = /home/perltest/sysperl/lib/perl5:
PERL5OPT =
PERL5_CPANPLUS_IS_RUNNING = 25004
PERL5_CPAN_IS_RUNNING = 25004
PERL5_CPAN_IS_RUNNING_IN_RECURSION = 1977,25004
PERLBREW_BASHRC_VERSION = 0.73
PERLBREW_HOME = /home/perltest/.perlbrew
PERLBREW_LIB =
PERLBREW_MANPATH = /home/perltest/perl5/perlbrew/perls/perl-5.20.2/man
PERLBREW_PATH = /home/perltest/perl5/perlbrew/bin:/home/perltest/perl5/perlbrew/perls/perl-5.20.2/bin
PERLBREW_PERL = perl-5.20.2
PERLBREW_ROOT = /home/perltest/perl5/perlbrew
PERLBREW_VERSION = 0.73
PERL_CR_SMOKER_CURRENT = SQL-Interpolate-0.33
PERL_EXTUTILS_AUTOINSTALL = --defaultdeps
PERL_LOCAL_LIB_ROOT = /home/perltest/sysperl:
PERL_MB_OPT = --install_base "//home/perltest/sysperl"
PERL_MM_OPT = INSTALL_BASE=/home/perltest/sysperl
PERL_MM_USE_DEFAULT = 1
SHELL = /bin/bash
TERM = screen
Perl special variables (and OS-specific diagnostics, for MSWin32):
$^X = /data/perl5/perlbrew/perls/perl-5.20.2/bin/perl
$UID/$EUID = 2000 / 2000
$GID = 2000 2000
$EGID = 2000 2000
Perl module toolchain versions installed:
Module Have
------------------- --------
CPAN 2.10
CPAN::Meta 2.150005
Cwd 3.48_01
ExtUtils::CBuilder 0.280217
ExtUtils::Command 1.18
ExtUtils::Install 1.67
ExtUtils::MakeMaker 7.04
ExtUtils::Manifest 1.70
ExtUtils::ParseXS 3.24
File::Spec 3.48_01
JSON 2.90
JSON::PP 2.27203
Module::Build 0.4214
Module::Signature 0.79
Parse::CPAN::Meta 1.4417
Test::Harness 3.30
Test::More 1.001014
YAML 1.15
YAML::Syck 1.29
version 0.9909
--
Summary of my perl5 (revision 5 version 20 subversion 2) configuration:
Platform:
osname=linux, osvers=3.19.0-18-generic, archname=x86_64-linux
uname='linux perltest 3.19.0-18-generic #18-ubuntu smp tue may 19 18:31:35 utc 2015 x86_64 x86_64 x86_64 gnulinux '
config_args='-de -Dprefix=/home/perltest/perl5/perlbrew/perls/perl-5.20.2 -Aeval:scriptdir=/home/perltest/perl5/perlbrew/perls/perl-5.20.2/bin'
hint=recommended, useposix=true, d_sigaction=define
useithreads=undef, usemultiplicity=undef
use64bitint=define, use64bitall=define, uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='cc', ccflags ='-fwrapv -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O2',
cppflags='-fwrapv -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include'
ccversion='', gccversion='4.9.2', 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 =' -fstack-protector -L/usr/local/lib'
libpth=/usr/local/lib /usr/lib/gcc/x86_64-linux-gnu/4.9/include-fixed /usr/include/x86_64-linux-gnu /usr/lib /lib/x86_64-linux-gnu /lib/../lib /usr/lib/x86_64-linux-gnu /usr/lib/../lib /lib
libs=-lnsl -ldl -lm -lcrypt -lutil -lc
perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc
libc=libc-2.21.so, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version='2.21'
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'
Characteristics of this binary (from libperl):
Compile-time options: HAS_TIMES PERLIO_LAYERS PERL_DONT_CREATE_GVSV
PERL_HASH_FUNC_ONE_AT_A_TIME_HARD PERL_MALLOC_WRAP
PERL_NEW_COPY_ON_WRITE PERL_PRESERVE_IVUV
USE_64_BIT_ALL USE_64_BIT_INT USE_LARGE_FILES
USE_LOCALE USE_LOCALE_COLLATE USE_LOCALE_CTYPE
USE_LOCALE_NUMERIC USE_PERLIO USE_PERL_ATOF
Locally applied patches:
Devel::PatchPerl 1.38
Built under linux
Compiled at Jul 14 2015 18:27:24
%ENV:
PERL5LIB="/home/perltest/sysperl/lib/perl5:"
PERL5OPT=""
PERL5_CPANPLUS_IS_RUNNING="25004"
PERL5_CPAN_IS_RUNNING="25004"
PERL5_CPAN_IS_RUNNING_IN_RECURSION="1977,25004"
PERLBREW_BASHRC_VERSION="0.73"
PERLBREW_HOME="/home/perltest/.perlbrew"
PERLBREW_LIB=""
PERLBREW_MANPATH="/home/perltest/perl5/perlbrew/perls/perl-5.20.2/man"
PERLBREW_PATH="/home/perltest/perl5/perlbrew/bin:/home/perltest/perl5/perlbrew/perls/perl-5.20.2/bin"
PERLBREW_PERL="perl-5.20.2"
PERLBREW_ROOT="/home/perltest/perl5/perlbrew"
PERLBREW_VERSION="0.73"
PERL_CR_SMOKER_CURRENT="SQL-Interpolate-0.33"
PERL_EXTUTILS_AUTOINSTALL="--defaultdeps"
PERL_LOCAL_LIB_ROOT="/home/perltest/sysperl:"
PERL_MB_OPT="--install_base "//home/perltest/sysperl""
PERL_MM_OPT="INSTALL_BASE=/home/perltest/sysperl"
PERL_MM_USE_DEFAULT="1"
@INC:
/home/perltest/sysperl/lib/perl5/x86_64-linux
/home/perltest/sysperl/lib/perl5
/home/perltest/perl5/perlbrew/perls/perl-5.20.2/lib/site_perl/5.20.2/x86_64-linux
/home/perltest/perl5/perlbrew/perls/perl-5.20.2/lib/site_perl/5.20.2
/home/perltest/perl5/perlbrew/perls/perl-5.20.2/lib/5.20.2/x86_64-linux
/home/perltest/perl5/perlbrew/perls/perl-5.20.2/lib/5.20.2
.