Start 2009-09-14T20:08:12 ActivePerl-825 CPAN-1.9402 LIB=C:\PROGRA~1\MICROS~4\VC98\Lib\PSDK;C:\PROGRA~1\MICROS~2\Lib;C:\PROGRA~1\MICROS~4\VC98\Lib;C:\PROGRA~1\MICROS~4\VC98\MFC\Lib INCLUDE=C:\PROGRA~1\MICROS~2\Include;C:\PROGRA~1\MICROS~4\VC98\ATL\Include;C:\PROGRA~1\MICROS~4\VC98\Include;C:\PROGRA~1\MICROS~4\VC98\MFC\Include PATH=C:/CPANFL~1.8/var/libs/bin;C:\PROGRA~1\MICROS~2\Bin;C:\PROGRA~1\MICROS~2\Bin\WinNT;C:\PROGRA~1\MICROS~4\VC98\Bin;C:\PROGRA~1\MICROS~4\Common\MSDev98\Bin;C:\Perl-5.8\site\bin;C:\Perl-5.8\bin;C:\cygwin\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\system32\WINDOW~2\v1.0;C:\PROGRA~1\Perforce Going to read 'C:\cpanfly-5.8\var\cpan\Metadata' Database was generated on Mon, 14 Sep 2009 08:27:53 GMT Running make for R/RE/REHSACK/SQL-Statement-1.20.tar.gz Checksum for C:\cpanfly-5.8\var\cpan\sources\authors\id\R\RE\REHSACK\SQL-Statement-1.20.tar.gz ok Will not use Archive::Tar, need 1.00 SQL-Statement-1.20/ SQL-Statement-1.20/lib/ SQL-Statement-1.20/t/ SQL-Statement-1.20/META.yml SQL-Statement-1.20/MANIFEST.SKIP SQL-Statement-1.20/Makefile.PL SQL-Statement-1.20/README SQL-Statement-1.20/Changes SQL-Statement-1.20/MANIFEST SQL-Statement-1.20/t/14allcols.t SQL-Statement-1.20/t/11functions.t SQL-Statement-1.20/t/SQLtest.pm SQL-Statement-1.20/t/13call.t SQL-Statement-1.20/t/04names.t SQL-Statement-1.20/t/17quoting.t SQL-Statement-1.20/t/00error.t SQL-Statement-1.20/t/03executeDBD.t SQL-Statement-1.20/t/01prepare.t SQL-Statement-1.20/t/09ops.t SQL-Statement-1.20/t/08join.t SQL-Statement-1.20/t/02executeDirect.t SQL-Statement-1.20/t/12eval.t SQL-Statement-1.20/t/07case.t SQL-Statement-1.20/t/10limit.t SQL-Statement-1.20/t/05create.t SQL-Statement-1.20/t/16morejoins.t SQL-Statement-1.20/t/15naturaljoins.t SQL-Statement-1.20/t/06group.t SQL-Statement-1.20/lib/SQL/ SQL-Statement-1.20/lib/SQL/Dialects/ SQL-Statement-1.20/lib/SQL/Statement/ SQL-Statement-1.20/lib/SQL/Statement.pm SQL-Statement-1.20/lib/SQL/Parser.pm SQL-Statement-1.20/lib/SQL/Eval.pm SQL-Statement-1.20/lib/SQL/Statement/RAM.pm SQL-Statement-1.20/lib/SQL/Statement/GetInfo.pm SQL-Statement-1.20/lib/SQL/Statement/Syntax.pod SQL-Statement-1.20/lib/SQL/Statement/Structure.pod SQL-Statement-1.20/lib/SQL/Statement/Util.pm SQL-Statement-1.20/lib/SQL/Statement/Embed.pod SQL-Statement-1.20/lib/SQL/Statement/Functions.pm SQL-Statement-1.20/lib/SQL/Dialects/ANSI.pm SQL-Statement-1.20/lib/SQL/Dialects/AnyData.pm SQL-Statement-1.20/lib/SQL/Dialects/CSV.pm CPAN.pm: Going to build R/RE/REHSACK/SQL-Statement-1.20.tar.gz >>> C:\Perl-5.8\bin\perl.exe Makefile.PL Checking if your kit is complete... Looks good Writing Makefile for SQL::Statement >>> nmake Microsoft (R) Program Maintenance Utility Version 7.00.8882 Copyright (C) Microsoft Corp 1988-2000. All rights reserved. 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/Eval.pm blib\lib\SQL\Eval.pm cp lib/SQL/Statement/Syntax.pod blib\lib\SQL\Statement\Syntax.pod cp lib/SQL/Dialects/AnyData.pm blib\lib\SQL\Dialects\AnyData.pm cp lib/SQL/Statement/Functions.pm blib\lib\SQL\Statement\Functions.pm REHSACK/SQL-Statement-1.20.tar.gz nmake -- OK Running make test >>> nmake test TEST_VERBOSE=1 Microsoft (R) Program Maintenance Utility Version 7.00.8882 Copyright (C) Microsoft Corp 1988-2000. All rights reserved. C:\Perl-5.8\bin\perl.exe "-MExtUtils::Command::MM" "-e" "test_harness(1, 'blib\lib', 'blib\arch')" t/*.t t/00error.t .......... 1..6 SQL::Statement v.1.20 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.t ........ SQL::Statement v.1.20 1..102 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 101 ok 102 ok t/02executeDirect.t .. SQL::Statement v.1.20 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 DBD::File::st execute failed: You passed 1 parameters where 0 required [for Statement " CREATE TEMP TABLE phrase (id INT,phrase VARCHAR(30))"] at t/03executeDBD.t line 47. DBD::File::st execute failed: You passed 1 parameters where 0 required [for Statement " CREATE TEMP TABLE phrase (id INT,phrase VARCHAR(30))"] at t/03executeDBD.t line 47. # Looks like you planned 22 tests but ran 6. # Looks like your test exited with 255 just after 6. t/03executeDBD.t ..... SQL::Statement v.1.20 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 Dubious, test returned 255 (wstat 65280, 0xff00) Failed 16/22 subtests t/04names.t .......... 1..5 SQL::Statement v.1.20 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 DBD::File::db do failed: You passed 1 parameters where 0 required [for Statement "CREATE TEMP TABLE aoa AS IMPORT(?)"] at t/05create.t line 21. DBD::File::db do failed: You passed 1 parameters where 0 required [for Statement "CREATE TEMP TABLE aoa AS IMPORT(?)"] at t/05create.t line 21. # Looks like your test exited with 255 before it could output anything. t/05create.t ......... 1..5 SQL::Statement v.1.20 Dubious, test returned 255 (wstat 65280, 0xff00) Failed 5/5 subtests t/06group.t .......... 1..3 SQL::Statement v.1.20 ok 1 - AGGREGATE FUNCTIONS WITHOUT GROUP BY ok 2 - GROUP BY one column ok 3 - GROUP BY several columns ok t/07case.t ........... 1..12 SQL::Statement v.1.20 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.t ........... 1..14 SQL::Statement v.1.20 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.t ............ 1..18 SQL::Statement v.1.20 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.t .......... 1..2 SQL::Statement v.1.20 ok 1 - limit with order by ok 2 - limit without order by ok t/11functions.t ...... 1..23 SQL::Statement v.1.20 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.t ........... 1..15 SQL::Statement v.1.20 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.t ........... 1..2 SQL::Statement v.1.20 ok 1 - call function ok 2 - call function ok t/14allcols.t ........ 1..1 SQL::Statement v.1.20 ok 1 - ->{all_cols} structure does not grow beyond control ok t/15naturaljoins.t ... 1..2 ok 1 - Natural Join - columns ok ok 2 - Natural Join - values ok 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',,' # 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 2 tests of 48. t/16morejoins.t ...... 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 ok 40 - Full Joins (using ON condition) - values ok 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 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 Dubious, test returned 2 (wstat 512, 0x200) Failed 2/48 subtests t/17quoting.t ........ 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/03executeDBD.t (Wstat: 65280 Tests: 6 Failed: 0) Non-zero exit status: 255 Parse errors: Bad plan. You planned 22 tests but ran 6. t/05create.t (Wstat: 65280 Tests: 0 Failed: 0) Non-zero exit status: 255 Parse errors: Bad plan. You planned 5 tests but ran 0. t/16morejoins.t (Wstat: 512 Tests: 48 Failed: 2) Failed tests: 44, 48 Non-zero exit status: 2 Files=18, Tests=314, 3 wallclock secs ( 0.03 usr + 0.19 sys = 0.22 CPU) Result: FAIL Failed 3/18 test programs. 2/314 subtests failed. NMAKE : fatal error U1077: 'C:\Perl-5.8\bin\perl.exe' : return code '0xff' Stop. REHSACK/SQL-Statement-1.20.tar.gz nmake test TEST_VERBOSE=1 -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports REHSACK/SQL-Statement-1.20.tar.gz Finished 2009-09-14T20:08:19