Report for SQL-Interpolate-0.32

Back
From: metabase:user:314402c4-2aae-11df-837a-5e0a49663a4f
Subject: FAIL SQL-Interpolate-0.32 v5.24.1 RC3 FreeBSD
Date: 2016-09-07T08:11: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.32
on perl 5.24.1, created by CPAN-Reporter-1.2018.

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:

none provided

------------------------------
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 (two, three, one) VALUES( ?, 3, ?)'
#     $expected->[0] = 'INSERT INTO mytable (two, three, one) VALUES(?, 3,  ?)'
$VAR1 = [
          'INSERT INTO mytable (two, three, one) VALUES( ?, 3, ?)',
          [
            5,
            bless( {
                     'value' => \5,
                     'type' => 1
                   }, 'SQL::Interpolate::Variable' )
          ],
          [
            1,
            bless( {
                     'value' => \1
                   }, 'SQL::Interpolate::Variable' )
          ]
        ];
$VAR2 = [
          'INSERT INTO mytable (two, three, one) VALUES(?, 3,  ?)',
          [
            5,
            $VAR1->[1][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, three, one) VALUES( ?, 3, ?)'
#     $expected->[0] = 'INSERT INTO mytable (two, three, one) VALUES(?, 3,  ?)'
$VAR1 = [
          'INSERT INTO mytable (two, three, one) VALUES( ?, 3, ?)',
          [
            5,
            bless( {
                     'value' => \5,
                     'type' => 1
                   }, 'SQL::Interpolate::Variable' )
          ],
          [
            1,
            bless( {
                     'value' => \1
                   }, 'SQL::Interpolate::Variable' )
          ]
        ];
$VAR2 = [
          'INSERT INTO mytable (two, three, one) 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 (two, three, one) VALUES( ?, 3, ?)'
#     $expected->[0] = 'INSERT INTO mytable (two, three, one) VALUES(?, 3,  ?)'
$VAR1 = [
          'INSERT INTO mytable (two, three, one) VALUES( ?, 3, ?)',
          [
            5,
            bless( {
                     'value' => \5,
                     'type' => 1
                   }, 'SQL::Interpolate::Variable' )
          ],
          [
            1,
            bless( {
                     'value' => \1
                   }, 'SQL::Interpolate::Variable' )
          ]
        ];
$VAR2 = [
          'INSERT INTO mytable (two, three, one) 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 (two, three, one) VALUES( ?, 3, ?)'
#     $expected->[0] = 'INSERT INTO mytable (two, three, one) VALUES(?, 3,  ?)'
$VAR1 = [
          'INSERT INTO mytable (two, three, one) VALUES( ?, 3, ?)',
          [
            5,
            bless( {
                     'value' => \5,
                     'type' => 1
                   }, 'SQL::Interpolate::Variable' )
          ],
          [
            1,
            bless( {
                     'value' => \1
                   }, 'SQL::Interpolate::Variable' )
          ]
        ];
$VAR2 = [
          'INSERT INTO mytable (two, three, one) VALUES(?, 3,  ?)',
          [
            5,
            $VAR1->[1][1]
          ],
          [
            1,
            bless( {
                     'value' => \1
                   }, 'SQL::Interpolate::Variable' )
          ]
        ];
$VAR3 = 'INSERT hashref of sql_var + sql() 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 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()';

#   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 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() 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 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 of \$x, sql_var typed'
#   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';

#   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 \$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 \$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 'WHERE hashref of \$x, sql() OO'
#   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() OO';

#   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 'WHERE hashref of \$x, sql() closure2'
#   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() closure2';
# Looks like you failed 16 tests of 167.
t/sql_interp.t .... 
Dubious, test returned 16 (wstat 4096, 0x1000)
Failed 16/167 subtests 

Test Summary Report
-------------------
t/sql_interp.t  (Wstat: 4096 Tests: 167 Failed: 16)
  Failed tests:  66-69, 122-125, 154-157, 162-165
  Non-zero exit status: 16
Files=9, Tests=256,  1 wallclock secs ( 0.02 usr  0.03 sys +  0.48 cusr  0.11 csys =  0.64 CPU)
Result: FAIL
Failed 1/9 test programs. 16/256 subtests failed.

------------------------------
PREREQUISITES
------------------------------

Prerequisite modules loaded:

    No requirements found

------------------------------
ENVIRONMENT AND OTHER CONTEXT
------------------------------

Environment variables:

    LC_ALL = de_DE.ISO8859-1
    PATH = /usr/local/bin:/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/cpansand/bin/freebsd10.1:/home/cpansand/bin/sh:/home/cpansand/bin:/usr/games:/home/cpansand/devel:/home/eserte/src/srezic-misc/scripts
    PERL5LIB = 
    PERL5OPT = 
    PERL5_CPANPLUS_IS_RUNNING = 64773
    PERL5_CPAN_IS_RUNNING = 64773
    PERL5_CPAN_IS_RUNNING_IN_RECURSION = 64703,64773
    PERLDOC = -MPod::Perldoc::ToTextOverstrike
    PERL_BATCH = yes
    PERL_CANARY_STABILITY_NOPROMPT = 1
    PERL_CPAN_REPORTER_CONFIG = /var/tmp/cpansmoker-1023/2016090709/cpanreporter_002_config.ini
    PERL_EXTUTILS_AUTOINSTALL = --defaultdeps
    SHELL = /usr/local/bin/zsh
    TERM = screen
    TMPDIR = /var/tmp/cpansmoker-1023/2016090709

Perl special variables (and OS-specific diagnostics, for MSWin32):

    $^X = /usr/perl5.24.1-RC3p/bin/perl
    $UID/$EUID = 1023 / 1023
    $GID = 1023 1023
    $EGID = 1023 1023

Perl module toolchain versions installed:

    Module              Have      
    ------------------- ----------
    CPAN                2.14      
    CPAN::Meta          2.150010  
    Cwd                 3.63_01   
    ExtUtils::CBuilder  0.280225  
    ExtUtils::Command   7.22      
    ExtUtils::Install   2.04      
    ExtUtils::MakeMaker 7.22      
    ExtUtils::Manifest  1.70      
    ExtUtils::ParseXS   3.31      
    File::Spec          3.63_01   
    JSON                2.90      
    JSON::PP            2.27300_01
    Module::Build       0.4220    
    Module::Signature   0.80      
    Parse::CPAN::Meta   2.150010  
    Test::Harness       3.36_01   
    Test::More          1.302052  
    YAML                1.18      
    YAML::Syck          1.29      
    version             0.9917    


--

Summary of my perl5 (revision 5 version 24 subversion 1) configuration:
   
  Platform:
    osname=freebsd, osvers=10.1-release, archname=amd64-freebsd
    uname='freebsd cvrsnica-freebsd-101.herceg.de 10.1-release freebsd 10.1-release #0 r274401: tue nov 11 21:02:49 utc 2014 root@releng1.nyi.freebsd.org:usrobjusrsrcsysgeneric amd64 '
    config_args='-ds -e -Dprefix=/usr/perl5.24.1-RC3p -Dcf_email=srezic@cpan.org -Doptimize=-O2 -pipe'
    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 ='-DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_FORTIFY_SOURCE=2',
    optimize='-O2 -pipe',
    cppflags='-DHAS_FPSETMASK -DHAS_FLOATINGPOINT_H -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include'
    ccversion='', gccversion='4.2.1 Compatible FreeBSD Clang 3.4.1 (tags/RELEASE_34/dot1-final 208032)', 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 ='-pthread -Wl,-E  -fstack-protector -L/usr/local/lib'
    libpth=/usr/lib /usr/local/lib /usr/include/clang/3.4.1 /usr/lib
    libs=-lpthread -lgdbm -lm -lcrypt -lutil -lc
    perllibs=-lpthread -lm -lcrypt -lutil -lc
    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'


Characteristics of this binary (from libperl): 
  Compile-time options: HAS_TIMES PERLIO_LAYERS PERL_COPY_ON_WRITE
                        PERL_DONT_CREATE_GVSV
                        PERL_HASH_FUNC_ONE_AT_A_TIME_HARD PERL_MALLOC_WRAP
                        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_LOCALE_TIME
                        USE_PERLIO USE_PERL_ATOF
  Locally applied patches:
	RC3
  Built under freebsd
  Compiled at Aug 19 2016 19:51:18
  %ENV:
    PERL5LIB=""
    PERL5OPT=""
    PERL5_CPANPLUS_IS_RUNNING="64773"
    PERL5_CPAN_IS_RUNNING="64773"
    PERL5_CPAN_IS_RUNNING_IN_RECURSION="64703,64773"
    PERLDOC="-MPod::Perldoc::ToTextOverstrike"
    PERL_BATCH="yes"
    PERL_CANARY_STABILITY_NOPROMPT="1"
    PERL_CPAN_REPORTER_CONFIG="/var/tmp/cpansmoker-1023/2016090709/cpanreporter_002_config.ini"
    PERL_EXTUTILS_AUTOINSTALL="--defaultdeps"
  @INC:
    /usr/perl5.24.1-RC3p/lib/site_perl/5.24.1/amd64-freebsd
    /usr/perl5.24.1-RC3p/lib/site_perl/5.24.1
    /usr/perl5.24.1-RC3p/lib/5.24.1/amd64-freebsd
    /usr/perl5.24.1-RC3p/lib/5.24.1
    .