Back
From: metabase:user:315f03b2-2aae-11df-837a-5e0a49663a4f
Subject: FAIL SQL-Interp-1.21 v5.17.6 GNU/Linux
Date: 2012-11-19T20:09:39Z
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 Mark Stosberg,
This is a computer-generated report for SQL-Interp-1.21
on perl 5.17.6, created by CPAN-Reporter-1.2006.
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':
# Failed test at t/dbi.t line 114.
# got: 'SELECT * FROM mytable WHERE x= ? AND y= ? AND (a=? AND b=?) AND x IN (?, ?)'
# expected: 'SELECT * FROM mytable WHERE x= ? AND y= ? AND (b=? AND a=?) AND x IN (?, ?)'
# Looks like you failed 1 test of 21.
t/dbi.t ..........
Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/21 subtests
t/dist.t ......... ok
t/pod.t .......... ok
# Failed test 'INSERT hashref of sql_type + sql()'
# at t/lib.pl line 34.
# Structures begin differing at:
# $got->[0] = 'INSERT INTO mytable (one, three, two) VALUES(?, 3, ?)'
# $expected->[0] = 'INSERT INTO mytable (two, one, three) VALUES(?, ?, 3)'
$VAR1 = [
'INSERT INTO mytable (one, three, two) VALUES(?, 3, ?)',
[
1,
bless( {
'value' => \1
}, 'SQL::Interp::Variable' )
],
[
5,
bless( {
'type' => 1,
'value' => \5
}, 'SQL::Interp::Variable' )
]
];
$VAR2 = [
'INSERT INTO mytable (two, one, three) VALUES(?, ?, 3)',
[
1,
bless( {
'value' => \1
}, 'SQL::Interp::Variable' )
],
[
5,
$VAR1->[2][1]
]
];
$VAR3 = 'INSERT hashref of sql_type + sql()';
at t/lib.pl line 34.
main::my_deeply('ARRAY(0x99c9bcc)', 'ARRAY(0x99dd44c)', 'INSERT hashref of sql_type + sql()') called at t/sql_interp.t line 302
main::interp_test('ARRAY(0x99d3b80)', 'ARRAY(0x99dd44c)', 'INSERT hashref of sql_type + sql()') called at t/sql_interp.t line 126
# Failed test 'INSERT hashref of sql_type + sql() OO'
# at t/lib.pl line 34.
# Structures begin differing at:
# $got->[0] = 'INSERT INTO mytable (one, three, two) VALUES(?, 3, ?)'
# $expected->[0] = 'INSERT INTO mytable (two, one, three) VALUES(?, ?, 3)'
$VAR1 = [
'INSERT INTO mytable (one, three, two) VALUES(?, 3, ?)',
[
1,
bless( {
'value' => \1
}, 'SQL::Interp::Variable' )
],
[
5,
bless( {
'type' => 1,
'value' => \5
}, 'SQL::Interp::Variable' )
]
];
$VAR2 = [
'INSERT INTO mytable (two, one, three) VALUES(?, ?, 3)',
[
1,
bless( {
'value' => \1
}, 'SQL::Interp::Variable' )
],
[
5,
$VAR1->[2][1]
]
];
$VAR3 = 'INSERT hashref of sql_type + sql() OO';
at t/lib.pl line 34.
main::my_deeply('ARRAY(0x99c9b7c)', 'ARRAY(0x99dd44c)', 'INSERT hashref of sql_type + sql() OO') called at t/sql_interp.t line 303
main::interp_test('ARRAY(0x99d3b80)', 'ARRAY(0x99dd44c)', 'INSERT hashref of sql_type + sql()') called at t/sql_interp.t line 126
# Failed test 'WHERE hashref sql()'
# at t/lib.pl line 34.
# Structures begin differing at:
# $got->[0] = 'WHERE (x=? AND y=2)'
# $expected->[0] = 'WHERE (y=2 AND x=?)'
$VAR1 = [
'WHERE (x=? AND y=2)',
1
];
$VAR2 = [
'WHERE (y=2 AND x=?)',
1
];
$VAR3 = 'WHERE hashref sql()';
at t/lib.pl line 34.
main::my_deeply('ARRAY(0x99c9dc0)', 'ARRAY(0x99d3b80)', 'WHERE hashref sql()') called at t/sql_interp.t line 302
main::interp_test('ARRAY(0x99d0814)', 'ARRAY(0x99d3b80)', 'WHERE hashref sql()') called at t/sql_interp.t line 205
# Failed test 'WHERE hashref sql() OO'
# at t/lib.pl line 34.
# Structures begin differing at:
# $got->[0] = 'WHERE (x=? AND y=2)'
# $expected->[0] = 'WHERE (y=2 AND x=?)'
$VAR1 = [
'WHERE (x=? AND y=2)',
1
];
$VAR2 = [
'WHERE (y=2 AND x=?)',
1
];
$VAR3 = 'WHERE hashref sql() OO';
at t/lib.pl line 34.
main::my_deeply('ARRAY(0x99c42b4)', 'ARRAY(0x99d3b80)', 'WHERE hashref sql() OO') called at t/sql_interp.t line 303
main::interp_test('ARRAY(0x99d0814)', 'ARRAY(0x99d3b80)', 'WHERE hashref sql()') called at t/sql_interp.t line 205
# Failed test 'WHERE hashref of NULL'
# at t/lib.pl line 34.
# Structures begin differing at:
# $got->[0] = 'WHERE (x=? AND y IS NULL)'
# $expected->[0] = 'WHERE (y IS NULL AND x=?)'
$VAR1 = [
'WHERE (x=? AND y IS NULL)',
1
];
$VAR2 = [
'WHERE (y IS NULL AND x=?)',
1
];
$VAR3 = 'WHERE hashref of NULL';
at t/lib.pl line 34.
main::my_deeply('ARRAY(0x99c9de8)', 'ARRAY(0x99c0614)', 'WHERE hashref of NULL') called at t/sql_interp.t line 302
main::interp_test('ARRAY(0x99c441c)', 'ARRAY(0x99c0614)', 'WHERE hashref of NULL') called at t/sql_interp.t line 213
# Failed test 'WHERE hashref of NULL OO'
# at t/lib.pl line 34.
# Structures begin differing at:
# $got->[0] = 'WHERE (x=? AND y IS NULL)'
# $expected->[0] = 'WHERE (y IS NULL AND x=?)'
$VAR1 = [
'WHERE (x=? AND y IS NULL)',
1
];
$VAR2 = [
'WHERE (y IS NULL AND x=?)',
1
];
$VAR3 = 'WHERE hashref of NULL OO';
at t/lib.pl line 34.
main::my_deeply('ARRAY(0x99c42b4)', 'ARRAY(0x99c0614)', 'WHERE hashref of NULL OO') called at t/sql_interp.t line 303
main::interp_test('ARRAY(0x99c441c)', 'ARRAY(0x99c0614)', 'WHERE hashref of NULL') called at t/sql_interp.t line 213
# Failed test 'WHERE hashref of arrayref of sql_type typed'
# at t/lib.pl line 34.
# 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::Interp::Variable' )
],
[
3,
bless( {
'value' => \3
}, 'SQL::Interp::Variable' )
],
[
5,
bless( {
'type' => 1,
'value' => \5
}, 'SQL::Interp::Variable' )
]
];
$VAR2 = [
'WHERE (y IN (?, ?) AND x=?)',
[
5,
$VAR1->[3][1]
],
[
5,
bless( {
'value' => $VAR1->[3][1]{'value'}
}, 'SQL::Interp::Variable' )
],
[
3,
bless( {
'value' => \3
}, 'SQL::Interp::Variable' )
]
];
$VAR3 = 'WHERE hashref of arrayref of sql_type typed';
at t/lib.pl line 34.
main::my_deeply('ARRAY(0x99b7d44)', 'ARRAY(0x99c9e4c)', 'WHERE hashref of arrayref of sql_type typed') called at t/sql_interp.t line 302
main::interp_test('ARRAY(0x99c063c)', 'ARRAY(0x99c9e4c)', 'WHERE hashref of arrayref of sql_type typed') called at t/sql_interp.t line 238
# Failed test 'WHERE hashref of arrayref of sql_type typed OO'
# at t/lib.pl line 34.
# 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::Interp::Variable' )
],
[
3,
bless( {
'value' => \3
}, 'SQL::Interp::Variable' )
],
[
5,
bless( {
'type' => 1,
'value' => \5
}, 'SQL::Interp::Variable' )
]
];
$VAR2 = [
'WHERE (y IN (?, ?) AND x=?)',
[
5,
$VAR1->[3][1]
],
[
5,
bless( {
'value' => $VAR1->[3][1]{'value'}
}, 'SQL::Interp::Variable' )
],
[
3,
bless( {
'value' => \3
}, 'SQL::Interp::Variable' )
]
];
$VAR3 = 'WHERE hashref of arrayref of sql_type typed OO';
at t/lib.pl line 34.
main::my_deeply('ARRAY(0x99bc018)', 'ARRAY(0x99c9e4c)', 'WHERE hashref of arrayref of sql_type typed OO') called at t/sql_interp.t line 303
main::interp_test('ARRAY(0x99c063c)', 'ARRAY(0x99c9e4c)', 'WHERE hashref of arrayref of sql_type typed') called at t/sql_interp.t line 238
# Looks like you failed 8 tests of 134.
t/sql_interp.t ...
Dubious, test returned 8 (wstat 2048, 0x800)
Failed 8/134 subtests
t/strict_mode.t .. ok
Test Summary Report
-------------------
t/dbi.t (Wstat: 256 Tests: 21 Failed: 1)
Failed test: 21
Non-zero exit status: 1
t/sql_interp.t (Wstat: 2048 Tests: 134 Failed: 8)
Failed tests: 36-37, 74-77, 86-87
Non-zero exit status: 8
Files=5, Tests=161, 1 wallclock secs ( 0.15 usr 0.05 sys + 0.78 cusr 0.16 csys = 1.14 CPU)
Result: FAIL
Failed 2/5 test programs. 9/161 subtests failed.
------------------------------
PREREQUISITES
------------------------------
Prerequisite modules loaded:
requires:
Module Need Have
------------- ------ --------
DBI 1 1.622
perl v5.8.0 5.017006
Sub::Exporter 0 0.984
configure_requires:
Module Need Have
------------- ------ --------
Module::Build 0.38 0.4003
------------------------------
ENVIRONMENT AND OTHER CONTEXT
------------------------------
Environment variables:
AUTOMATED_TESTING = 1
LANG = en_US.UTF-8
PATH = /home/smoke/perl5/perlbrew/bin:/home/smoke/perl5/perlbrew/perls/perl-blead/bin:/usr/local/bin:/usr/bin:/bin:/usr/games
PATH_WITHOUT_PERLBREW = /usr/local/bin:/usr/bin:/bin:/usr/games
PERL5LIB =
PERL5OPT =
PERL5_CPANPLUS_IS_RUNNING = 12232
PERL5_CPAN_IS_RUNNING = 12232
PERL5_CPAN_IS_RUNNING_IN_RECURSION = 24839,12232
PERLBREW_HOME = /home/smoke/.perlbrew
PERLBREW_MANPATH = /home/smoke/perl5/perlbrew/perls/perl-blead/man
PERLBREW_PATH = /home/smoke/perl5/perlbrew/bin:/home/smoke/perl5/perlbrew/perls/perl-blead/bin
PERLBREW_PERL = perl-blead
PERLBREW_ROOT = /home/smoke/perl5/perlbrew
PERLBREW_VERSION = 0.58
PERL_CR_SMOKER_CURRENT = Task-Amon2-0.02
PERL_EXTUTILS_AUTOINSTALL = --defaultdeps
PERL_MM_USE_DEFAULT = 1
SHELL = /bin/bash
TERM = screen
Perl special variables (and OS-specific diagnostics, for MSWin32):
$^X = /home/smoke/perl5/perlbrew/perls/perl-blead/bin/perl5.17.6
$UID/$EUID = 1001 / 1001
$GID = 1001 1001
$EGID = 1001 1001
Perl module toolchain versions installed:
Module Have
------------------- --------
CPAN 1.99_51
CPAN::Meta 2.120921
Cwd 3.39_02
ExtUtils::CBuilder 0.280209
ExtUtils::Command 1.17
ExtUtils::Install 1.58
ExtUtils::MakeMaker 6.63_02
ExtUtils::Manifest 1.62
ExtUtils::ParseXS 3.18
File::Spec 3.39_02
JSON 2.53
JSON::PP 2.27200
Module::Build 0.4003
Module::Signature 0.69
Parse::CPAN::Meta 1.4404
Test::Harness 3.25_01
Test::More 0.98
YAML 0.84
YAML::Syck 1.21
version 0.9901
--
Summary of my perl5 (revision 5 version 17 subversion 6) configuration:
Snapshot of: 10ffaf90349dac17b6050fa36821c8d99f5dfb87
Platform:
osname=linux, osvers=2.6.32-5-xen-686, archname=i686-linux-thread-multi-64int
uname='linux prickle 2.6.32-5-xen-686 #1 smp tue jun 1 08:48:09 utc 2010 i686 gnulinux '
config_args='-de -Dprefix=/home/smoke/perl5/perlbrew/perls/perl-blead -Duse64bitint -Dusethreads -Dcc=gcc -Dusedevel'
hint=recommended, useposix=true, d_sigaction=define
useithreads=define, usemultiplicity=define
useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
use64bitint=define, use64bitall=undef, uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O2',
cppflags='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include'
ccversion='', gccversion='4.3.2', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=12345678
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -fstack-protector -L/usr/local/lib'
libpth=/usr/local/lib /lib/../lib /usr/lib/../lib /lib /usr/lib
libs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
libc=/lib/libc-2.11.2.so, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version='2.11.2'
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 MULTIPLICITY PERLIO_LAYERS
PERL_DONT_CREATE_GVSV PERL_IMPLICIT_CONTEXT
PERL_MALLOC_WRAP PERL_PRESERVE_IVUV PERL_USE_DEVEL
USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES
USE_LOCALE USE_LOCALE_COLLATE USE_LOCALE_CTYPE
USE_LOCALE_NUMERIC USE_PERLIO USE_PERL_ATOF
USE_REENTRANT_API
Built under linux
Compiled at Nov 17 2012 18:11:18
%ENV:
PERL5LIB=""
PERL5OPT=""
PERL5_CPANPLUS_IS_RUNNING="12232"
PERL5_CPAN_IS_RUNNING="12232"
PERL5_CPAN_IS_RUNNING_IN_RECURSION="24839,12232"
PERLBREW_HOME="/home/smoke/.perlbrew"
PERLBREW_MANPATH="/home/smoke/perl5/perlbrew/perls/perl-blead/man"
PERLBREW_PATH="/home/smoke/perl5/perlbrew/bin:/home/smoke/perl5/perlbrew/perls/perl-blead/bin"
PERLBREW_PERL="perl-blead"
PERLBREW_ROOT="/home/smoke/perl5/perlbrew"
PERLBREW_VERSION="0.58"
PERL_CR_SMOKER_CURRENT="Task-Amon2-0.02"
PERL_EXTUTILS_AUTOINSTALL="--defaultdeps"
PERL_MM_USE_DEFAULT="1"
@INC:
/home/smoke/perl5/perlbrew/perls/perl-blead/lib/site_perl/5.17.6/i686-linux-thread-multi-64int
/home/smoke/perl5/perlbrew/perls/perl-blead/lib/site_perl/5.17.6
/home/smoke/perl5/perlbrew/perls/perl-blead/lib/5.17.6/i686-linux-thread-multi-64int
/home/smoke/perl5/perlbrew/perls/perl-blead/lib/5.17.6
.