Back
From: metabase:user:3198cbe2-2aae-11df-837a-5e0a49663a4f
Subject: FAIL SQL-Interpolate-0.33 v5.18.1 GNU/Linux
Date: 2013-10-26T16:37:57Z
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.18.1, created by CPAN-Reporter-1.2010.
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, three, two) VALUES(?, 3, ?)'
# $expected->[0] = 'INSERT INTO mytable (one, two, three) VALUES(?, ?, 3)'
$VAR1 = [
'INSERT INTO mytable (one, three, two) VALUES(?, 3, ?)',
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
],
[
5,
bless( {
'value' => \5,
'type' => 1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR2 = [
'INSERT INTO mytable (one, two, three) VALUES(?, ?, 3)',
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
],
[
5,
$VAR1->[2][1]
]
];
$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 (one, two, three) VALUES(?, ?, 3)'
# $expected->[0] = 'INSERT INTO mytable (one, two, 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 (one, two, three) VALUES(?, ?, 3)',
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
],
[
5,
$VAR1->[2][1]
]
];
$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 (one, three, two) VALUES(?, 3, ?)'
# $expected->[0] = 'INSERT INTO mytable (one, two, three) VALUES(?, ?, 3)'
$VAR1 = [
'INSERT INTO mytable (one, three, two) VALUES(?, 3, ?)',
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
],
[
5,
bless( {
'value' => \5,
'type' => 1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR2 = [
'INSERT INTO mytable (one, two, three) VALUES(?, ?, 3)',
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
],
[
5,
$VAR1->[2][1]
]
];
$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 (one, two, three) VALUES(?, ?, 3)'
# $expected->[0] = 'INSERT INTO mytable (one, two, 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 (one, two, three) VALUES(?, ?, 3)',
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
],
[
5,
$VAR1->[2][1]
]
];
$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 closure2'
# 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 closure2';
# 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= ?, three=3, one=?'
# $expected->[0] = 'UPDATE mytable SET three=3, one=?, two= ?'
$VAR1 = [
'UPDATE mytable SET two= ?, three=3, 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()';
# 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() closure'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'UPDATE mytable SET one=?, two= ?, three=3'
# $expected->[0] = 'UPDATE mytable SET three=3, one=?, two= ?'
$VAR1 = [
'UPDATE mytable SET one=?, two= ?, three=3',
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
],
[
5,
bless( {
'value' => \5,
'type' => 1
}, 'SQL::Interpolate::Variable' )
]
];
$VAR2 = [
'UPDATE mytable SET three=3, one=?, two= ?',
[
1,
bless( {
'value' => \1
}, 'SQL::Interpolate::Variable' )
],
[
5,
$VAR1->[2][1]
]
];
$VAR3 = 'SET hashref of sql_var types, sql() closure';
# 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 two= ?, three=3, one=?'
# $expected->[0] = 'UPDATE mytable SET three=3, one=?, two= ?'
$VAR1 = [
'UPDATE mytable SET two= ?, three=3, 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() closure'
# 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() closure';
# 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 closure'
# 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 closure';
# Failed test 'WHERE hashref of \$x, sql_var typed closure2'
# 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 closure2';
# Failed test 'WHERE hashref of arrayref of sql_var typed closure'
# at t/lib.pl line 36.
# Structures begin differing at:
# $got->[0] = 'WHERE (y IN (?, ?) AND x=?)'
# $expected->[0] = 'WHERE (x=? AND y IN (?, ?))'
$VAR1 = [
'WHERE (y IN (?, ?) AND x=?)',
[
3,
bless( {
'value' => \3
}, 'SQL::Interpolate::Variable' )
],
[
5,
bless( {
'value' => \5,
'type' => 1
}, 'SQL::Interpolate::Variable' )
],
[
5,
bless( {
'value' => \5
}, 'SQL::Interpolate::Variable' )
]
];
$VAR2 = [
'WHERE (x=? AND y IN (?, ?))',
[
5,
bless( {
'value' => $VAR1->[2][1]{'value'}
}, 'SQL::Interpolate::Variable' )
],
[
3,
bless( {
'value' => \3
}, 'SQL::Interpolate::Variable' )
],
[
5,
$VAR1->[2][1]
]
];
$VAR3 = 'WHERE hashref of arrayref of sql_var typed closure';
# Failed test 'WHERE hashref of \$x, sql()'
# 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()';
# 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';
# Failed test 'v of identity_macro(h 2) closure2'
# 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) closure2';
# Looks like you failed 20 tests of 262.
t/sql_interp.t ....
Dubious, test returned 20 (wstat 5120, 0x1400)
Failed 20/262 subtests
Test Summary Report
-------------------
t/sql_interp.t (Wstat: 5120 Tests: 262 Failed: 20)
Failed tests: 66-69, 71, 73, 122-125, 136-137, 156-157
160, 162, 243-246
Non-zero exit status: 20
Files=9, Tests=353, 2 wallclock secs ( 0.10 usr 0.01 sys + 1.03 cusr 0.12 csys = 1.26 CPU)
Result: FAIL
Failed 1/9 test programs. 20/353 subtests failed.
------------------------------
PREREQUISITES
------------------------------
Prerequisite modules loaded:
No requirements found
------------------------------
ENVIRONMENT AND OTHER CONTEXT
------------------------------
Environment variables:
AUTOMATED_TESTING = 1
LANG = en_GB.UTF-8
PATH = /home/graham/perls/perl-5.18.1/bin:/usr/local/sbin:/usr/local/bin:/usr/bin:/usr/bin/vendor_perl:/usr/bin/core_perl
PERL5LIB =
PERL5OPT =
PERL5_CPANPLUS_IS_RUNNING = 27053
PERL5_CPAN_IS_RUNNING = 27053
PERL5_CPAN_IS_RUNNING_IN_RECURSION = 368,27053
PERL_CR_SMOKER_CURRENT = SQL-Interpolate-0.33
PERL_EXTUTILS_AUTOINSTALL = --defaultdeps
PERL_MM_USE_DEFAULT = 1
SHELL = /bin/bash
TERM = xterm
Perl special variables (and OS-specific diagnostics, for MSWin32):
$^X = /home/graham/perls/perl-5.18.1/bin/perl
$UID/$EUID = 1000 / 1000
$GID = 100 10 95 98 100
$EGID = 100 10 95 98 100
Perl module toolchain versions installed:
Module Have
------------------- --------
CPAN 2.00
CPAN::Meta 2.132830
Cwd 3.40
ExtUtils::CBuilder 0.280212
ExtUtils::Command 1.18
ExtUtils::Install 1.59
ExtUtils::MakeMaker 6.81_03
ExtUtils::Manifest 1.63
ExtUtils::ParseXS 3.22
File::Spec 3.40
JSON 2.61
JSON::PP 2.27203
Module::Build 0.4007
Module::Signature 0.73
Parse::CPAN::Meta 1.4409
Test::Harness 3.29
Test::More 0.99
YAML 0.84
YAML::Syck 1.27
version 0.9904
--
Summary of my perl5 (revision 5 version 18 subversion 1) configuration:
Platform:
osname=linux, osvers=3.11.4-1-arch, archname=x86_64-linux
uname='linux grosics 3.11.4-1-arch #1 smp preempt sat oct 5 21:22:51 cest 2013 x86_64 gnulinux '
config_args=''
hint=recommended, useposix=true, d_sigaction=define
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 -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O2',
cppflags='-fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include'
ccversion='', gccversion='4.8.1 20130725 (prerelease)', 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 /lib/../lib /usr/lib/../lib /lib /usr/lib /lib64 /usr/lib64
libs=-lnsl -lgdbm -ldb -ldl -lm -lcrypt -lutil -lc -lgdbm_compat
perllibs=-lnsl -ldl -lm -lcrypt -lutil -lc
libc=/lib/libc-2.18.so, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version='2.18'
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_PRESERVE_IVUV PERL_SAWAMPERSAND 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
Built under linux
Compiled at Oct 11 2013 10:49:28
%ENV:
PERL5LIB=""
PERL5OPT=""
PERL5_CPANPLUS_IS_RUNNING="27053"
PERL5_CPAN_IS_RUNNING="27053"
PERL5_CPAN_IS_RUNNING_IN_RECURSION="368,27053"
PERL_CR_SMOKER_CURRENT="SQL-Interpolate-0.33"
PERL_EXTUTILS_AUTOINSTALL="--defaultdeps"
PERL_MM_USE_DEFAULT="1"
@INC:
/home/graham/perls/perl-5.18.1/lib/site_perl/5.18.1/x86_64-linux
/home/graham/perls/perl-5.18.1/lib/site_perl/5.18.1
/home/graham/perls/perl-5.18.1/lib/5.18.1/x86_64-linux
/home/graham/perls/perl-5.18.1/lib/5.18.1
.