Start 2009-01-19T06:25:43 Going to read /home/cpanfly/var/cpan/Metadata Database was generated on Mon, 19 Jan 2009 11:26:52 GMT Running make for R/RE/REHSACK/SQL-Statement-1.17.tar.gz Checksum for /net/nas/data/cpan/authors/id/R/RE/REHSACK/SQL-Statement-1.17.tar.gz ok SQL-Statement-1.17/ SQL-Statement-1.17/p/ SQL-Statement-1.17/t/ SQL-Statement-1.17/lib/ SQL-Statement-1.17/Makefile.PL SQL-Statement-1.17/README SQL-Statement-1.17/Changes SQL-Statement-1.17/MANIFEST SQL-Statement-1.17/META.yml SQL-Statement-1.17/MANIFEST.SKIP SQL-Statement-1.17/lib/SQL/ SQL-Statement-1.17/lib/SQL/Dialects/ SQL-Statement-1.17/lib/SQL/Statement/ SQL-Statement-1.17/lib/SQL/Statement.pm SQL-Statement-1.17/lib/SQL/Parser.pm SQL-Statement-1.17/lib/SQL/Eval.pm SQL-Statement-1.17/lib/SQL/Statement/RAM.pm SQL-Statement-1.17/lib/SQL/Statement/GetInfo.pm SQL-Statement-1.17/lib/SQL/Statement/Syntax.pod SQL-Statement-1.17/lib/SQL/Statement/Structure.pod SQL-Statement-1.17/lib/SQL/Statement/Util.pm SQL-Statement-1.17/lib/SQL/Statement/Embed.pod SQL-Statement-1.17/lib/SQL/Statement/Functions.pm SQL-Statement-1.17/lib/SQL/Dialects/ANSI.pm SQL-Statement-1.17/lib/SQL/Dialects/AnyData.pm SQL-Statement-1.17/lib/SQL/Dialects/CSV.pm SQL-Statement-1.17/t/17quoting.t SQL-Statement-1.17/t/14allcols.t SQL-Statement-1.17/t/11functions.t SQL-Statement-1.17/t/SQLtest.pm SQL-Statement-1.17/t/13call.t SQL-Statement-1.17/t/04names.t SQL-Statement-1.17/t/00error.t SQL-Statement-1.17/t/03executeDBD.t SQL-Statement-1.17/t/01prepare.t SQL-Statement-1.17/t/09ops.t SQL-Statement-1.17/t/08join.t SQL-Statement-1.17/t/02executeDirect.t SQL-Statement-1.17/t/12eval.t SQL-Statement-1.17/t/07case.t SQL-Statement-1.17/t/10limit.t SQL-Statement-1.17/t/05create.t SQL-Statement-1.17/t/15naturaljoins.t SQL-Statement-1.17/t/16morejoins.t SQL-Statement-1.17/t/06group.t SQL-Statement-1.17/t/06group.t.orig SQL-Statement-1.17/p/01profile_joins.pl CPAN.pm: Going to build R/RE/REHSACK/SQL-Statement-1.17.tar.gz >>> /home/cpanfly/ap1003/bin/perl-static Makefile.PL Checking if your kit is complete... Looks good Writing Makefile for SQL::Statement >>> make cp lib/SQL/Dialects/ANSI.pm blib/lib/SQL/Dialects/ANSI.pm cp lib/SQL/Parser.pm blib/lib/SQL/Parser.pm cp lib/SQL/Statement/RAM.pm blib/lib/SQL/Statement/RAM.pm cp lib/SQL/Statement/Embed.pod blib/lib/SQL/Statement/Embed.pod cp lib/SQL/Statement/Util.pm blib/lib/SQL/Statement/Util.pm cp lib/SQL/Statement/GetInfo.pm blib/lib/SQL/Statement/GetInfo.pm cp lib/SQL/Statement/Structure.pod blib/lib/SQL/Statement/Structure.pod cp lib/SQL/Statement.pm blib/lib/SQL/Statement.pm cp lib/SQL/Dialects/CSV.pm blib/lib/SQL/Dialects/CSV.pm cp lib/SQL/Statement/Syntax.pod blib/lib/SQL/Statement/Syntax.pod cp lib/SQL/Eval.pm blib/lib/SQL/Eval.pm cp lib/SQL/Dialects/AnyData.pm blib/lib/SQL/Dialects/AnyData.pm cp lib/SQL/Statement/Functions.pm blib/lib/SQL/Statement/Functions.pm Manifying blib/man3/SQL::Parser.3 Manifying blib/man3/SQL::Statement.3 Manifying blib/man3/SQL::Statement::Embed.3 Manifying blib/man3/SQL::Eval.3 Manifying blib/man3/SQL::Statement::Syntax.3 Manifying blib/man3/SQL::Statement::Structure.3 Manifying blib/man3/SQL::Statement::Functions.3 REHSACK/SQL-Statement-1.17.tar.gz make -- OK Running make test >>> make test TEST_VERBOSE=1 PERL_DL_NONLAZY=1 /home/cpanfly/ap1003/bin/perl-static "-MExtUtils::Command::MM" "-e" "test_harness(1, 'blib/lib', 'blib/arch')" t/*.t t/00error............ 1..6 SQL::Statement v.1.17 ok 1 - Parse RaiseError=0 (default) ok 2 - Parse RaiseError=1 ok 3 - $stmt->errstr with no error ok 4 - Execute RaiseError=0 (default) ok 5 - Execute RaiseError=1 ok 6 - $stmt->errstr with error ok t/01prepare.......... SQL::Statement v.1.17 1..100 ok 1 ok 2 ok 3 ok 4 ok 5 ok 6 ok 7 ok 8 ok 9 ok 10 ok 11 ok 12 ok 13 ok 14 ok 15 ok 16 ok 17 ok 18 ok 19 ok 20 ok 21 ok 22 ok 23 ok 24 ok 25 ok 26 ok 27 ok 28 ok 29 ok 30 ok 31 ok 32 ok 33 ok 34 ok 35 ok 36 ok 37 ok 38 ok 39 ok 40 ok 41 ok 42 ok 43 ok 44 ok 45 ok 46 ok 47 ok 48 ok 49 ok 50 ok 51 ok 52 ok 53 ok 54 ok 55 ok 56 ok 57 ok 58 ok 59 ok 60 ok 61 ok 62 ok 63 ok 64 ok 65 ok 66 ok 67 ok 68 ok 69 ok 70 ok 71 ok 72 ok 73 ok 74 ok 75 ok 76 ok 77 ok 78 ok 79 ok 80 ok 81 ok 82 ok 83 ok 84 ok 85 ok 86 ok 87 ok 88 ok 89 ok 90 ok 91 ok 92 ok 93 ok 94 ok 95 ok 96 ok 97 ok 98 ok 99 ok 100 ok t/02executeDirect.... SQL::Statement v.1.17 1..24 ok 1 - $parser->new ok 2 - $stmt->new ok 3 - $stmt->command ok 4 - $stmt->params ok 5 - $stmt->tables ok 6 - $stmt->columns ok 7 - $stmt->column_names ok 8 - $stmt->order ok 9 - $stmt->where->op ok 10 - $stmt->where->neg ok 11 - $stmt->where->arg1 ok 12 - $stmt->where->arg2 ok 13 - $stmt->limit ok 14 - $stmt->offset ok 15 - $stmt->row_values ok 16 - structure ok 17 - command ok 18 - distinct ok 19 - $stmt->execute CREATE ok 20 - $stmt->execute INSERT ok 21 - $stmt->execute INSERT ok 22 - $stmt->execute SELECT ok 23 - $stmt->where_hash ok 24 - $stmt->fetch ok t/03executeDBD....... SQL::Statement v.1.17 1..22 ok 1 - placeholder insert with named cols ok 2 - placeholder insert without named cols ok 3 - placeholder delete ok 4 - placeholder update ok 5 - placeholder update ok 6 - Placeholders ok 7 - CREATE ok 8 - INSERT ok 9 - INSERT ok 10 - INSERT ok 11 - UPDATE ok 12 - DELETE ok 13 - SELECT ok 14 - COUNT * ok 15 - COMPUTED COLUMNS IN SELECT LIST ok 16 - CREATE FUNCTION from script ok 17 - CREATE FUNCTION from module ok 18 - LOAD FUNCTIONS ok 19 - IMPORT($AoA) ok 20 - IMPORT($internal_sth) Prototype mismatch: sub XBase::Base::O_BINARY () vs none at (eval 26) line 1. Constant subroutine O_BINARY redefined at (eval 26) line 1. ok 21 - IMPORT($external_sth) ok 22 - DROP TEMP TABLE ok t/04names............ 1..5 SQL::Statement v.1.17 ok 1 - Column Names: select list = * ok 2 - Column Names: select list = named ok 3 - Column Names: select list = aliased ok 4 - Column Names: select list with function ok 5 - Column Names: select list with function = aliased ok t/05create........... 1..5 SQL::Statement v.1.17 ok 1 - CREATE TABLE AS IMPORT($AoA) ok 2 - CREATE TABLE AS IMPORT($AoH) ok 3 - CREATE TABLE AS IMPORT($internal_sth) Prototype mismatch: sub XBase::Base::O_BINARY () vs none at (eval 24) line 1. Constant subroutine O_BINARY redefined at (eval 24) line 1. ok 4 - CREATE TABLE AS IMPORT($external_sth) ok 5 - CREATE TABLE AS SELECT ok t/06group............ 1..3 SQL::Statement v.1.17 ok 1 - AGGREGATE FUNCTIONS WITHOUT GROUP BY ok 2 - GROUP BY one column ok 3 - GROUP BY several columns ok t/07case............. 1..12 SQL::Statement v.1.17 ok 1 - lower/lower ok 2 - lower/upper ok 3 - lower/mixed ok 4 - lower/asterisked ok 5 - upper/lower ok 6 - upper/upper ok 7 - upper/mixed ok 8 - upper/asterisked ok 9 - mixed/lower ok 10 - mixed/upper ok 11 - mixed/mixed ok 12 - mixed/asterisked ok t/08join............. 1..14 SQL::Statement v.1.17 ok 1 - NATURAL JOIN - with named columns in select list ok 2 - NATURAL JOIN - with select list = * ok 3 - NATURAL JOIN - with computed columns ok 4 - NATURAL JOIN - with no specifier on join column ok 5 - INNER JOIN - with no specifier on join column ok 6 - LEFT JOIN ok 7 - LEFT JOIN - enumerated columns ok 8 - LEFT JOIN - perversely intentionally mis-enumerated columns ok 9 - LEFT JOIN - lower case keywords ok 10 - RIGHT JOIN ok 11 - RIGHT JOIN - enumerated columns ok 12 - FULL JOIN ok 13 - IMPLICIT JOIN - two tables ok 14 - IMPLICIT JOIN - three tables ok t/09ops.............. 1..18 SQL::Statement v.1.17 ok 1 - unknwon type ok 2 - create type ok 3 - user-defined type ok 4 - known type ok 5 - drop type ok 6 - unknown type ok 7 - unknown keyword ok 8 - create keyword ok 9 - user-defined keyword ok 10 - known keyword ok 11 - drop keyword ok 12 - keyword as identifier ok 13 - unknown operator ok 14 - create operator ok 15 - user-defined operator ok 16 - known operator ok 17 - drop operator ok 18 - unkown operator ok t/10limit............ 1..2 SQL::Statement v.1.17 ok 1 - limit with order by ok 2 - limit without order by ok t/11functions........ 1..23 SQL::Statement v.1.17 ok 1 - min ok 2 - max ok 3 - sum ok 4 - count ok 5 - avg ok 6 - current_date/time/timestamp ok 7 - char_length ok 8 - position ok 9 - lower ok 10 - upper ok 11 - concat good ok 12 - concat bad ok 13 - coalesce ok 14 - nvl ok 15 - decode ok 16 - replace ok 17 - substitute ok 18 - substr ok 19 - trim ok 20 - soundex match ok 21 - soundex no match ok 22 - regex match ok 23 - regex no match ok t/12eval............. 1..15 SQL::Statement v.1.17 ok 1 - eval row($val) ok 2 - eval row() ok 3 - eval column($val) ok 4 - eval column() ok 5 - eval params($val) ok 6 - eval params() ok 7 - eval column($tbl,$col,$val) ok 8 - ram seek(bad whence) ok 9 - ram seek(bad index) ok 10 - ram seek(pos=2) ok 11 - $function->type ok 12 - $function->name ok 13 - $column->type ok 14 - function validate - no sub ok 15 - function validate ok t/13call............. 1..2 SQL::Statement v.1.17 ok 1 - call function ok 2 - call function ok t/14allcols.......... 1..1 SQL::Statement v.1.17 ok 1 - ->{all_cols} structure does not grow beyond control ok t/15naturaljoins..... 1..2 ok 1 - Natural Join - columns ok ok 2 - Natural Join - values ok ok t/16morejoins........ 1..48 ok 1 - Cross Joins - columns ok ok 2 - Cross Joins - values ok ok 3 - Cross Joins - values ok ok 4 - Cross Joins - values ok ok 5 - Cross Joins - values ok ok 6 - Cross Joins - values ok ok 7 - Cross Joins - values ok ok 8 - Cross Joins - values ok ok 9 - Cross Joins - values ok ok 10 - Cross Joins - values ok ok 11 - Inner Joins - columns ok ok 12 - Inner Joins - values ok ok 13 - Inner Joins - values ok ok 14 - Inner Joins (USING) - columns ok ok 15 - Inner Joins (USING) - values ok ok 16 - Inner Joins (USING) - values ok ok 17 - Inner Joins (NATURAL) - columns ok ok 18 - Inner Joins (NATURAL) - values ok ok 19 - Inner Joins (NATURAL) - values ok ok 20 - Left Joins (using ON condition) - columns ok ok 21 - Left Joins (using ON condition) - values ok ok 22 - Left Joins (using ON condition) - values ok ok 23 - Left Joins (using ON condition) - values ok ok 24 - Left Joins (USING (num) condition) - columns ok ok 25 - Left Joins (USING (num) condition) - values ok ok 26 - Left Joins (USING (num) condition) - values ok ok 27 - Left Joins (USING (num) condition) - values ok ok 28 - Right Joins (using ON condition) - columns ok ok 29 - Right Joins (using ON condition) - values ok ok 30 - Right Joins (using ON condition) - values ok ok 31 - Right Joins (using ON condition) - values ok ok 32 - Left Joins (reverse former Right Join) - columns ok ok 33 - Left Joins (reverse former Right Join) - values ok ok 34 - Left Joins (reverse former Right Join) - values ok ok 35 - Left Joins (reverse former Right Join) - values ok ok 36 - Full Joins (using ON condition) - columns ok ok 37 - Full Joins (using ON condition) - values ok ok 38 - Full Joins (using ON condition) - values ok ok 39 - Full Joins (using ON condition) - values ok not ok 40 - Full Joins (using ON condition) - values ok # Failed test 'Full Joins (using ON condition) - values ok' # at t/16morejoins.t line 265. # got: ''5',,'5','zzz'' # expected: ',,'5','zzz'' ok 41 - Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") - columns ok ok 42 - Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") - values ok ok 43 - Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") - values ok not ok 44 - Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") - values ok # Failed test 'Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") - values ok' # at t/16morejoins.t line 292. # got: ''3','c','3','yyy'' # expected: ''3','c',,' ok 45 - Left Joins (using ON t1.num = t2.num WHERE (t2.wert = "xxx" OR t2.wert IS NULL)) - columns ok ok 46 - Left Joins (using ON t1.num = t2.num WHERE (t2.wert = "xxx" OR t2.wert IS NULL)) - values ok ok 47 - Left Joins (using ON t1.num = t2.num WHERE (t2.wert = "xxx" OR t2.wert IS NULL)) - values ok not ok 48 - Left Joins (using ON t1.num = t2.num WHERE (t2.wert = "xxx" OR t2.wert IS NULL)) - values ok # Failed test 'Left Joins (using ON t1.num = t2.num WHERE (t2.wert = "xxx" OR t2.wert IS NULL)) - values ok' # at t/16morejoins.t line 319. # got: '' # expected: ''3','c',,' # Looks like you failed 3 tests of 48. Dubious, test returned 3 (wstat 768, 0x300) Failed 3/48 subtests t/17quoting.......... 1..31 ok 1 - use SQL::Statement; ok 2 - use SQL::Parser; ok 3 # SKIP Unsupported queries skipped ok 4 # SKIP Unsupported queries skipped ok 5 # SKIP Unsupported queries skipped ok 6 # SKIP Unsupported queries skipped ok 7 # SKIP Unsupported queries skipped ok 8 # SKIP Unsupported queries skipped ok 9 # SKIP Unsupported queries skipped ok 10 # SKIP Unsupported queries skipped ok 11 # SKIP Unsupported queries skipped ok 12 # SKIP Unsupported queries skipped ok 13 # SKIP Unsupported queries skipped ok 14 # SKIP Unsupported queries skipped ok 15 # SKIP Unsupported queries skipped ok 16 # SKIP Unsupported queries skipped ok 17 # SKIP Unsupported queries skipped ok 18 # SKIP Unsupported queries skipped ok 19 # SKIP Unsupported queries skipped ok 20 # SKIP Unsupported queries skipped ok 21 # SKIP Unsupported queries skipped ok 22 # SKIP Unsupported queries skipped ok 23 # SKIP Unsupported queries skipped ok 24 # SKIP Unsupported queries skipped ok 25 # SKIP Unsupported queries skipped ok 26 # SKIP Unsupported queries skipped ok 27 # SKIP Unsupported queries skipped ok 28 # SKIP Unsupported queries skipped ok 29 # SKIP Unsupported queries skipped ok 30 # SKIP Unsupported queries skipped ok 31 # SKIP Unsupported queries skipped ok Test Summary Report ------------------- t/16morejoins (Wstat: 768 Tests: 48 Failed: 3) Failed tests: 40, 44, 48 Non-zero exit status: 3 Files=18, Tests=333, 16 wallclock secs ( 0.02 usr 0.18 sys + 1.73 cusr 0.57 csys = 2.50 CPU) Result: FAIL Failed 1/18 test programs. 3/333 subtests failed. make: *** [test_dynamic] Error 255 REHSACK/SQL-Statement-1.17.tar.gz make test TEST_VERBOSE=1 -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports REHSACK/SQL-Statement-1.17.tar.gz Finished 2009-01-19T06:26:27