Start 2009-11-25T07:37:40 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 Tue, 24 Nov 2009 23:27:16 GMT Running make for H/HM/HMBRAND/DBD-CSV-0.26.tgz Fetching with LWP: http://cpan.nas.activestate.com/authors/id/H/HM/HMBRAND/DBD-CSV-0.26.tgz Fetching with LWP: http://cpan.nas.activestate.com/authors/id/H/HM/HMBRAND/CHECKSUMS Checksum for C:\cpanfly-5.8\var\cpan\sources\authors\id\H\HM\HMBRAND\DBD-CSV-0.26.tgz ok Will not use Archive::Tar, need 1.00 DBD-CSV-0.26/ DBD-CSV-0.26/META.yml DBD-CSV-0.26/ChangeLog DBD-CSV-0.26/examples/ DBD-CSV-0.26/examples/passwd.pl DBD-CSV-0.26/README DBD-CSV-0.26/t/ DBD-CSV-0.26/t/43_blobs.t DBD-CSV-0.26/t/73_csv-case.t DBD-CSV-0.26/t/80_rt.t DBD-CSV-0.26/t/72_csv-schema.t DBD-CSV-0.26/t/40_numrows.t DBD-CSV-0.26/t/00_minimumversion.t DBD-CSV-0.26/t/41_nulls.t DBD-CSV-0.26/t/20_createdrop.t DBD-CSV-0.26/t/00_pod.t DBD-CSV-0.26/t/51_commit.t DBD-CSV-0.26/t/lib.pl DBD-CSV-0.26/t/00_meta.t DBD-CSV-0.26/t/00_pod_cov.t DBD-CSV-0.26/t/30_insertfetch.t DBD-CSV-0.26/t/42_bindparam.t DBD-CSV-0.26/t/11_dsnlist.t DBD-CSV-0.26/t/70_csv.t DBD-CSV-0.26/t/10_base.t DBD-CSV-0.26/t/71_csv-ext.t DBD-CSV-0.26/t/60_misc.t DBD-CSV-0.26/t/50_chopblanks.t DBD-CSV-0.26/t/44_listfields.t DBD-CSV-0.26/Makefile.PL DBD-CSV-0.26/MANIFEST DBD-CSV-0.26/MANIFEST.SKIP DBD-CSV-0.26/lib/ DBD-CSV-0.26/lib/Bundle/ DBD-CSV-0.26/lib/Bundle/DBD/ DBD-CSV-0.26/lib/Bundle/DBD/CSV.pm DBD-CSV-0.26/lib/DBD/ DBD-CSV-0.26/lib/DBD/CSV.pm CPAN.pm: Going to build H/HM/HMBRAND/DBD-CSV-0.26.tgz >>> C:\Perl-5.8\bin\perl.exe Makefile.PL Warning: prerequisite SQL::Statement 1.22 not found. We have 0.1021. Checking if your kit is complete... Looks good Writing Makefile for DBD::CSV ---- Unsatisfied dependencies detected during ---- ---- HMBRAND/DBD-CSV-0.26.tgz ---- SQL::Statement [requires] Running make test Delayed until after prerequisites Running test for module 'SQL::Statement' Running make for R/RE/REHSACK/SQL-Statement-1.23.tar.gz Checksum for C:\cpanfly-5.8\var\cpan\sources\authors\id\R\RE\REHSACK\SQL-Statement-1.23.tar.gz ok Will not use Archive::Tar, need 1.00 SQL-Statement-1.23/ SQL-Statement-1.23/t/ SQL-Statement-1.23/lib/ SQL-Statement-1.23/Changes SQL-Statement-1.23/MANIFEST SQL-Statement-1.23/META.yml SQL-Statement-1.23/MANIFEST.SKIP SQL-Statement-1.23/Todo SQL-Statement-1.23/Makefile.PL SQL-Statement-1.23/README SQL-Statement-1.23/lib/SQL/ SQL-Statement-1.23/lib/SQL/Dialects/ SQL-Statement-1.23/lib/SQL/Statement/ SQL-Statement-1.23/lib/SQL/Statement.pm SQL-Statement-1.23/lib/SQL/Parser.pm SQL-Statement-1.23/lib/SQL/Parser.pm.rej SQL-Statement-1.23/lib/SQL/Eval.pm SQL-Statement-1.23/lib/SQL/Statement/TermFactory.pm SQL-Statement-1.23/lib/SQL/Statement/Structure.pod SQL-Statement-1.23/lib/SQL/Statement/GetInfo.pm SQL-Statement-1.23/lib/SQL/Statement/Term.pm SQL-Statement-1.23/lib/SQL/Statement/Syntax.pod SQL-Statement-1.23/lib/SQL/Statement/RAM.pm SQL-Statement-1.23/lib/SQL/Statement/Placeholder.pm SQL-Statement-1.23/lib/SQL/Statement/Function.pm SQL-Statement-1.23/lib/SQL/Statement/Util.pm SQL-Statement-1.23/lib/SQL/Statement/Embed.pod SQL-Statement-1.23/lib/SQL/Statement/Operation.pm SQL-Statement-1.23/lib/SQL/Statement/Functions.pm SQL-Statement-1.23/lib/SQL/Dialects/ANSI.pm SQL-Statement-1.23/lib/SQL/Dialects/AnyData.pm SQL-Statement-1.23/lib/SQL/Dialects/CSV.pm SQL-Statement-1.23/t/06group.t SQL-Statement-1.23/t/14allcols.t SQL-Statement-1.23/t/19idents.t SQL-Statement-1.23/t/11functions.t SQL-Statement-1.23/t/20pod.t SQL-Statement-1.23/t/SQLtest.pm SQL-Statement-1.23/t/13call.t SQL-Statement-1.23/t/04names.t SQL-Statement-1.23/t/21pod_coverage.t SQL-Statement-1.23/t/17quoting.t SQL-Statement-1.23/t/00error.t SQL-Statement-1.23/t/03executeDBD.t SQL-Statement-1.23/t/01prepare.t SQL-Statement-1.23/t/09ops.t SQL-Statement-1.23/t/08join.t SQL-Statement-1.23/t/02executeDirect.t SQL-Statement-1.23/t/12eval.t SQL-Statement-1.23/t/07case.t SQL-Statement-1.23/t/18bigjoin.t SQL-Statement-1.23/t/10limit.t SQL-Statement-1.23/t/05create.t SQL-Statement-1.23/t/16morejoins.t SQL-Statement-1.23/t/15naturaljoins.t CPAN.pm: Going to build R/RE/REHSACK/SQL-Statement-1.23.tar.gz >>> C:\Perl-5.8\bin\perl.exe Makefile.PL WARNING! You seem to have an older version of SQL::Statement already installed (0.1021 <= 1.20). This new version introduces a number of features that will impact operation of SQL::Statement and of DBD drivers for CSV, AnyData, and Excel. Changes include (1.003): * There are *many* new SQL features including table joins * BLOBS, Empty strings, and NULLs behave differently * Some applications may run a bit slower than previously Changes include (1.22): * behavior for unquoted identifiers modified to lower case them * IN and BETWEEN operators are supported native See the Changes for details. 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/TermFactory.pm blib\lib\SQL\Statement\TermFactory.pm 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/Term.pm blib\lib\SQL\Statement\Term.pm cp lib/SQL/Parser.pm.rej blib\lib\SQL\Parser.pm.rej 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/RAM.pm blib\lib\SQL\Statement\RAM.pm cp lib/SQL/Statement/Embed.pod blib\lib\SQL\Statement\Embed.pod cp lib/SQL/Statement/Placeholder.pm blib\lib\SQL\Statement\Placeholder.pm 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/Operation.pm blib\lib\SQL\Statement\Operation.pm cp lib/SQL/Eval.pm blib\lib\SQL\Eval.pm cp lib/SQL/Statement/Functions.pm blib\lib\SQL\Statement\Functions.pm cp lib/SQL/Statement/Function.pm blib\lib\SQL\Statement\Function.pm REHSACK/SQL-Statement-1.23.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.23 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.23 1..113 ok 1 - parse 'DROP TABLE foo' ok 2 - parse 'DROP TABLE foo CASCADE' ok 3 - parse 'DROP TABLE foo RESTRICT' ok 4 - parse 'DELETE FROM foo' ok 5 - parse 'DELETE FROM foo WHERE id < 7' ok 6 - parse 'UPDATE foo SET bar = 7' ok 7 - parse 'UPDATE foo SET bar = 7 WHERE id > 7' ok 8 - parse 'INSERT INTO foo VALUES ( 'baz', 7, NULL )' ok 9 - parse 'INSERT INTO foo (col1,col2,col7) VALUES ( 'baz', 7, NULL )' ok 10 - parse 'CREATE TABLE foo ( id INT )' ok 11 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT)' ok 12 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' ok 13 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' ok 14 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT)' ok 15 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' ok 16 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' ok 17 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40) )' ok 18 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE, phrase VARCHAR(40) UNIQUE )' ok 19 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) UNIQUE )' ok 20 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) NOT NULL )' ok 21 - parse 'CREATE TABLE foo ( id INTEGER NOT NULL, phrase VARCHAR(40) NOT NULL )' ok 22 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE NOT NULL, phrase VARCHAR(40) )' ok 23 - parse 'CREATE TABLE foo ( phrase CHARACTER VARYING(255) )' ok 24 - parse 'CREATE TABLE foo ( phrase NUMERIC(4,6) )' ok 25 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", "phrase" ), CONSTRAINT "foo_fkey" FOREIGN KEY ( "id" ) REFERENCES "bar" ( "bar_id" ))' ok 26 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), PRIMARY KEY ( "id" ), FOREIGN KEY ("id", "phrase") REFERENCES "bar" ("id2", "phrase2"))' ok 27 - parse 'CREATE TABLE foo ( id INTEGER, phrase CHAR(255), phrase2 VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", phrase, "phrase2" ), CONSTRAINT "foo_fkey" FOREIGN KEY ("id", "phrase", "phrase2") REFERENCES "bar" ("id2", "phrase2", "phase10"))' ok 28 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL INNER JOIN zUpper' ok 29 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL LEFT JOIN zUpper' ok 30 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL RIGHT JOIN zUpper' ok 31 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL FULL JOIN zUpper' ok 32 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper ON Lnum = Unum' ok 33 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper ON Lnum = Unum' ok 34 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' ok 35 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper ON Lnum = Unum' ok 36 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper USING(num)' ok 37 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper USING(num)' ok 38 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper USING(num)' ok 39 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper USING(num)' ok 40 - parse 'SELECT Lnum,Llet,Ulet FROM zLower,zUpper WHERE Lnum = Unum' ok 41 - parse 'SELECT * FROM zLower NATURAL INNER JOIN zUpper' ok 42 - parse 'SELECT * FROM zLower NATURAL LEFT JOIN zUpper' ok 43 - parse 'SELECT * FROM zLower NATURAL RIGHT JOIN zUpper' ok 44 - parse 'SELECT * FROM zLower NATURAL FULL JOIN zUpper' ok 45 - parse 'SELECT * FROM zLower INNER JOIN zUpper ON Lnum = Unum' ok 46 - parse 'SELECT * FROM zLower LEFT JOIN zUpper ON Lnum = Unum' ok 47 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' ok 48 - parse 'SELECT * FROM zLower FULL JOIN zUpper ON Lnum = Unum' ok 49 - parse 'SELECT * FROM zLower INNER JOIN zUpper USING(num)' ok 50 - parse 'SELECT * FROM zLower LEFT JOIN zUpper USING(num)' ok 51 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper USING(num)' ok 52 - parse 'SELECT * FROM zLower FULL JOIN zUpper USING(num)' ok 53 - parse 'SELECT * FROM zLower,zUpper WHERE Lnum = Unum' ok 54 - parse 'SELECT id, phrase FROM foo' ok 55 - parse 'SELECT * FROM foo' ok 56 - parse 'SELECT DISTINCT * FROM foo' ok 57 - parse 'SELECT ALL * FROM foo' ok 58 - parse 'SELECT A.*,B.* FROM A,B WHERE A.id=B.id' ok 59 - parse 'SELECT MAX(foo) FROM bar' ok 60 - parse 'SELECT MIN(foo) FROM bar' ok 61 - parse 'SELECT AVG(foo) FROM bar' ok 62 - parse 'SELECT SUM(foo) FROM bar' ok 63 - parse 'SELECT COUNT(foo) FROM foo' ok 64 - parse 'SELECT COUNT(*) FROM foo' ok 65 - parse 'SELECT SUM(DISTINCT foo) FROM bar' ok 66 - parse 'SELECT SUM(ALL foo) FROM bar' ok 67 - parse 'SELECT * FROM foo ORDER BY bar' ok 68 - parse 'SELECT * FROM foo ORDER BY bar, baz' ok 69 - parse 'SELECT * FROM foo ORDER BY bar DESC' ok 70 - parse 'SELECT * FROM foo ORDER BY bar ASC' ok 71 - parse 'SELECT * FROM foo LIMIT 5' ok 72 - parse 'SELECT * FROM foo LIMIT 0, 5' ok 73 - parse 'SELECT * FROM foo LIMIT 5, 10' ok 74 - parse 'SELECT * FROM foo WHERE UPPER(phrase) = 'bar'' ok 75 - parse 'SELECT * FROM foo WHERE LOWER(phrase) = 'bar'' ok 76 - parse 'SELECT * FROM foo WHERE TRIM( str ) = 'bar'S' ok 77 - parse 'SELECT * FROM foo WHERE TRIM( LEADING FROM str ) = 'bar'' ok 78 - parse 'SELECT * FROM foo WHERE TRIM( TRAILING FROM str ) = 'bar'' ok 79 - parse 'SELECT * FROM foo WHERE TRIM( BOTH FROM str ) = 'bar'' ok 80 - parse 'SELECT * FROM foo WHERE TRIM( LEADING ';' FROM str ) = 'bar'' ok 81 - parse 'SELECT * FROM foo WHERE TRIM( UPPER(phrase) ) = 'bar'' ok 82 - parse 'SELECT * FROM foo WHERE TRIM( LOWER(phrase) ) = 'bar'' ok 83 - parse 'SELECT * FROM foo WHERE blat= SUBSTRING(bar FROM 3 FOR 6)' ok 84 - parse 'SELECT * FROM foo WHERE blat= SUBSTRING(bar FROM 3)' ok 85 - parse 'UPDATE foo SET bar='baz', bop=7, bump=bar+8, blat=SUBSTRING(bar FROM 3 FOR 6)' ok 86 - parse 'SELECT * FROM test as T1' ok 87 - parse 'SELECT * FROM test T1' ok 88 - parse 'SELECT T1.id, T2.num FROM test as T1 JOIN test2 as T2 USING(id)' ok 89 - parse 'SELECT id FROM test as T1 WHERE T1.num < 7' ok 90 - parse 'SELECT id FROM test as T1 ORDER BY T1.num' ok 91 - parse 'SELECT a.x,b.y FROM foo AS a, bar b WHERE a.baz = b.bop ORDER BY a.blat' ok 92 - parse 'SELECT * FROM foo WHERE 1 = 0 AND baz < (6*foo+11-r)' ok 93 - parse 'SELECT ID, phRase FROM tEst AS tE WHERE te.id < 3 ORDER BY TE.phrasE' ok 94 - parse 'SELECT * FROM ztable WHERE NOT data IN ('one','two')' ok 95 - parse 'SELECT * from ztable WHERE (aaa > 'AAA')' ok 96 - parse 'SELECT * from ztable WHERE sev = 50 OR sev = 60' ok 97 - parse 'SELECT * from ztable WHERE (sev = 50 OR sev = 60)' ok 98 - parse 'SELECT * from ztable WHERE sev IN (50,60)' ok 99 - parse 'SELECT * from ztable WHERE rc > 200 AND ( sev IN(50,60) )' ok 100 - parse 'SELECT * FROM ztable WHERE data NOT IN ('one','two')' ok 101 - parse 'SELECT * from ztable WHERE (aaa > 'AAA') AND (zzz < 'ZZZ')' ok 102 - parse 'SELECT * from ztable WHERE (sev IN(50,60))' ok 103 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' ok 104 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR NOT blat = bar' ok 105 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR blat IS NOT NULL' ok 106 - parse 'SELECT * FROM bar WHERE foo IN ('aa','ab','ba','bb')' ok 107 - parse 'SELECT * FROM bar WHERE foo IN (3.14,2.72,1.41,9.81)' ok 108 - parse 'SELECT * FROM bar WHERE foo NOT IN ('aa','ab','ba','bb')' ok 109 - parse 'SELECT * FROM bar WHERE foo NOT IN (3.14,2.72,1.41,9.81)' ok 110 - parse 'SELECT * FROM bar WHERE foo BETWEEN ('aa','bb')' ok 111 - parse 'SELECT * FROM bar WHERE foo BETWEEN (1.41,9.81)' ok 112 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN ('aa','bb')' ok 113 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN (1.41,9.81)' ok t/02executeDirect.t .. SQL::Statement v.1.23 1..57 ok 1 - $parser->new ok 2 - $stmt->new ok 3 - $stmt->command ok 4 - $stmt->params ok 5 - $stmt->tables ok 6 - $stmt->where()->op ok 7 - $stmt->where()->left ok 8 - $stmt->where()->left->left ok 9 - $stmt->where()->left->right ok 10 - $stmt->limit ok 11 - $stmt->offset ok 12 - $stmt->row_values() ok 13 - $stmt->row_values(0) ok 14 - $stmt->row_values(0,1) ok 15 - structure ok 16 - command ok 17 - distinct ok 18 - $stmt->execute " CREATE TABLE a (b INT, c CHAR)" (CREATE) ok 19 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT) ok 20 - $stmt->execute " INSERT INTO a VALUES(2,'efg')" (INSERT) ok 21 - $stmt->execute " INSERT INTO a VALUES(3,'hij')" (INSERT) ok 22 - $stmt->execute " INSERT INTO a VALUES(4,'klm')" (INSERT) ok 23 - $stmt->execute " INSERT INTO a VALUES(5,'nmo')" (INSERT) ok 24 - $stmt->execute " INSERT INTO a VALUES(6,'pqr')" (INSERT) ok 25 - $stmt->execute " INSERT INTO a VALUES(7,'stu')" (INSERT) ok 26 - $stmt->execute " INSERT INTO a VALUES(8,'vwx')" (INSERT) ok 27 - $stmt->execute " INSERT INTO a VALUES(9,'yz')" (INSERT) ok 28 - $stmt->execute " SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC" (SELECT) ok 29 - $stmt->where_hash ok 30 - $stmt->columns ok 31 - $stmt->column_names ok 32 - $stmt->order ok 33 - $stmt->fetch ok 34 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 35 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz') ok 36 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT) ok 37 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7) ok 38 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT) ok 39 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo') ok 40 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 41 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz') ok 42 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT) ok 43 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7) ok 44 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT) ok 45 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo') ok 46 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT) ok 47 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7) ok 48 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT) ok 49 - SELECT b,c FROM a WHERE b BETWEEN (5,7) ok 50 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT) ok 51 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo') ok 52 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT) ok 53 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7) ok 54 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT) ok 55 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz') ok 56 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT) ok 57 - SELECT b,c FROM a WHERE b IN (2,3,5,7) ok Scalar value @fret[$i-1] better written as $fret[$i-1] at C:/cpanfly-5.8/var/megalib/XBase.pm line 498. Scalar value @fret[$i-1] better written as $fret[$i-1] at C:/cpanfly-5.8/var/megalib/XBase.pm line 500. Scalar value @fret[$i-1] better written as $fret[$i-1] at C:/cpanfly-5.8/var/megalib/XBase.pm line 503. Useless use of hash element in void context at C:/cpanfly-5.8/var/megalib/XBase.pm line 537. Useless use of private variable in void context at C:/cpanfly-5.8/var/megalib/XBase.pm line 537. Can't locate object method "create" via package "XBase" at C:/cpanfly-5.8/var/megalib/DBD/XBase.pm line 310. # Looks like you planned 26 tests but ran 22. # Looks like your test exited with 2 just after 22. t/03executeDBD.t ..... SQL::Statement v.1.23 1..26 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 - multiline insert ok 7 - verify table contents ok 8 - DROP TABLE ok 9 - CREATE ok 10 - INSERT ok 11 - INSERT ok 12 - INSERT ok 13 - UPDATE ok 14 - DELETE ok 15 - SELECT ok 16 - COUNT * ok 17 - COMPUTED COLUMNS IN SELECT LIST ok 18 - CREATE FUNCTION from script ok 19 - CREATE FUNCTION from module ok 20 - LOAD FUNCTIONS ok 21 - IMPORT($AoA) ok 22 - IMPORT($internal_sth) Dubious, test returned 2 (wstat 512, 0x200) Failed 4/26 subtests t/04names.t .......... 1..5 SQL::Statement v.1.23 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 Scalar value @fret[$i-1] better written as $fret[$i-1] at C:/cpanfly-5.8/var/megalib/XBase.pm line 498. Scalar value @fret[$i-1] better written as $fret[$i-1] at C:/cpanfly-5.8/var/megalib/XBase.pm line 500. Scalar value @fret[$i-1] better written as $fret[$i-1] at C:/cpanfly-5.8/var/megalib/XBase.pm line 503. Useless use of hash element in void context at C:/cpanfly-5.8/var/megalib/XBase.pm line 537. Useless use of private variable in void context at C:/cpanfly-5.8/var/megalib/XBase.pm line 537. Can't locate object method "create" via package "XBase" at C:/cpanfly-5.8/var/megalib/DBD/XBase.pm line 310. # Looks like you planned 5 tests but ran 3. # Looks like your test exited with 2 just after 3. t/05create.t ......... 1..5 ok 1 - CREATE TABLE AS IMPORT($AoA) ok 2 - CREATE TABLE AS IMPORT($AoH) ok 3 - CREATE TABLE AS IMPORT($internal_sth) Dubious, test returned 2 (wstat 512, 0x200) Failed 2/5 subtests # SQL::Statement v.1.23 t/06group.t .......... 1..10 ok 1 - AGGREGATE FUNCTIONS WITHOUT GROUP BY ok 2 - GROUP BY one column ok 3 - GROUP BY several columns ok 4 - COUNT(distinct column) WITH GROUP BY ok 5 - COUNT(*) with GROUP BY ok 6 - COUNT(DISTINCT *) fails ok 7 - GROUP BY required ok 8 - Names in aggregated Table ok 9 - Number of rows in aggregated Table ok 10 - SUM(COUNTED) ok t/07case.t ........... 1..12 SQL::Statement v.1.23 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.23 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.23 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.23 ok 1 - limit with order by ok 2 - limit without order by ok t/11functions.t ...... 1..23 SQL::Statement v.1.23 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..13 SQL::Statement v.1.23 ok 1 - eval row() ok 2 - eval column() ok 3 - eval params($val) ok 4 - eval params() ok 5 - eval column($tbl,$col) ok 6 - ram seek(bad whence) ok 7 - ram seek(bad index) ok 8 - ram seek(pos=2) ok 9 - $function->type ok 10 - $function->name ok 11 - $column->type ok 12 - function validate - no sub ok 13 - function validate ok t/13call.t ........... 1..2 SQL::Statement v.1.23 ok 1 - call function ok 2 - call function ok t/14allcols.t ........ 1..1 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 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 # TODO Known fail. Test to remember that there is sth. waiting to be fixed. ok 43 - Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") - values ok # TODO Known fail. Test to remember that there is sth. waiting to be fixed. not ok 44 - Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") - values ok # TODO Known fail. Test to remember that there is sth. waiting to be fixed. # Failed (TODO) test 'Left Joins (using ON t1.num = t2.num AND t2.wert = "xxx") - values ok' # at t/16morejoins.t line 294. # 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 # TODO Known fail. Test to remember that there is sth. waiting to be fixed. ok 47 - Left Joins (using ON t1.num = t2.num WHERE (t2.wert = "xxx" OR t2.wert IS NULL)) - values ok # TODO Known fail. Test to remember that there is sth. waiting to be fixed. not ok 48 - Left Joins (using ON t1.num = t2.num WHERE (t2.wert = "xxx" OR t2.wert IS NULL)) - values ok # TODO Known fail. Test to remember that there is sth. waiting to be fixed. # Failed (TODO) 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 324. # got: '' # expected: ''3','c',,' ok t/17quoting.t ........ 1..44 ok 1 - use SQL::Statement; ok 2 - use SQL::Parser; ok 3 - CREATE TABLE "TBL WITH SPACES" (id INT, "COLUMN WITH SPACES" CHAR, "SET" INT) ok 4 - INSERT INTO "TBL WITH SPACES" VALUES (1, 'foo', 1) ok 5 - INSERT INTO "TBL WITH SPACES" VALUES (2, 'bar', 0) ok 6 - Parsing SELECT "TBL WITH SPACES"."COLUMN WITH SPACES" ...: ok 7 - SELECTED 1 row ok 8 - got 'foo' ok 9 - Parsing SELECT "COLUMN WITH SPACES" ...: ok 10 - SELECTED 1 row ok 11 - got 'foo' ok 12 - Parsing SELECT "COLUMN WITH SPACES" AS CWS ...: ok 13 - SELECTED 1 row ok 14 - got 'foo' ok 15 - CREATE TABLE T1 (id INT, "COLUMN WITH SPACES" CHAR, "SET" INT) ok 16 - # INSERT INTO T1 VALUES (1, 'foo', 1) ok 17 - # INSERT INTO T1 VALUES (2, 'bar', 0) # ok 18 - Parsing SELECT T1."COLUMN WITH SPACES" ...: ok 19 - SELECTED 1 row ok 20 - got 'foo' ok 21 - Parsing SELECT "COLUMN WITH SPACES" ...: ok 22 - SELECTED 1 row ok 23 - got 'foo' ok 24 - Parsing SELECT "COLUMN WITH SPACES" AS CWS ...: ok 25 - SELECTED 1 row ok 26 - got 'foo' ok 27 - CREATE TABLE "TBL WITH SPACES" (id INT, CWS CHAR, "SET" INT) ok 28 - # INSERT INTO "TBL WITH SPACES" VALUES (1, 'foo', 1) ok 29 - # INSERT INTO "TBL WITH SPACES" VALUES (2, 'bar', 0) # ok 30 - Parsing SELECT "TBL WITH SPACES".CWS ...: ok 31 - SELECTED 1 row ok 32 - got 'foo' ok 33 - Parsing SELECT CWS ...: ok 34 - SELECTED 1 row ok 35 - got 'foo' ok 36 - CREATE TABLE T1 (id INT, CWS CHAR, "SET" INT) ok 37 - # INSERT INTO T1 VALUES (1, 'foo', 1) ok 38 - # INSERT INTO T1 VALUES (2, 'bar', 0) # ok 39 - Parsing SELECT CWS ... WHERE "SET"=0: ok 40 - SELECTED 1 row ok 41 - got 'bar' ok 42 - Parsing SELECT "SET" ...: ok 43 - SELECTED 1 row ok 44 - got '0' for "SET" ok t/18bigjoin.t ........ 1..89 ok 1 - use SQL::Statement; ok 2 - use SQL::Parser; ok 3 - CREATE TEMP TABLE APPL (id INT, applname CHAR, appluniq CHAR, version CHAR, appl_type CHAR) ok 4 - CREATE TEMP TABLE PREC (id INT, appl_id INT, node_id INT, precedence INT) ok 5 - CREATE TEMP TABLE NODE (id INT, nodename CHAR, os CHAR, version CHAR) ok 6 - CREATE TEMP TABLE LANDSCAPE (id INT, landscapename CHAR) ok 7 - CREATE TEMP TABLE CONTACT (id INT, surname CHAR, familyname CHAR, phone CHAR, userid CHAR, mailaddr CHAR) ok 8 - CREATE TEMP TABLE NM_LANDSCAPE (id INT, ls_id INT, obj_id INT, obj_type INT) ok 9 - CREATE TEMP TABLE APPL_CONTACT (id INT, contact_id INT, appl_id INT, contact_type CHAR) ok 10 - INSERT INTO APPL VALUES ( 1, 'ZQF', 'ZFQLIN', '10.2.0.4', 'Oracle DB') ok 11 - INSERT INTO APPL VALUES ( 2, 'YRA', 'YRA-UX', '10.2.0.2', 'Oracle DB') ok 12 - INSERT INTO APPL VALUES ( 3, 'PRN1', 'PRN1-4.B2', '1.1.22', 'CUPS' ) ok 13 - INSERT INTO APPL VALUES ( 4, 'PRN2', 'PRN2-4.B2', '1.1.22', 'CUPS' ) ok 14 - INSERT INTO APPL VALUES ( 5, 'PRN1', 'PRN1-4.B1', '1.1.22', 'CUPS' ) ok 15 - INSERT INTO APPL VALUES ( 7, 'PRN2', 'PRN2-4.B1', '1.1.22', 'CUPS' ) ok 16 - INSERT INTO APPL VALUES ( 8, 'sql-stmt', 'SQL::Statement', '1.21', 'Project Web-Site') ok 17 - INSERT INTO APPL VALUES ( 9, 'cpan.org', 'http://www.cpan.org/', '1.0', 'Web-Site') ok 18 - INSERT INTO APPL VALUES (10, 'httpd', 'cpan-apache', '2.2.13', 'Web-Server') ok 19 - INSERT INTO APPL VALUES (11, 'cpan-mods', 'cpan-mods', '8.4.1', 'PostgreSQL DB') ok 20 - INSERT INTO APPL VALUES (12, 'cpan-authors', 'cpan-authors', '8.4.1', 'PostgreSQL DB') ok 21 - INSERT INTO NODE VALUES ( 1, 'ernie', 'RHEL', '5.2') ok 22 - INSERT INTO NODE VALUES ( 2, 'bert', 'RHEL', '5.2') ok 23 - INSERT INTO NODE VALUES ( 3, 'statler', 'FreeBSD', '7.2') ok 24 - INSERT INTO NODE VALUES ( 4, 'waldorf', 'FreeBSD', '7.2') ok 25 - INSERT INTO NODE VALUES ( 5, 'piggy', 'NetBSD', '5.0.2') ok 26 - INSERT INTO NODE VALUES ( 6, 'kermit', 'NetBSD', '5.0.2') ok 27 - INSERT INTO NODE VALUES ( 7, 'samson', 'NetBSD', '5.0.2') ok 28 - INSERT INTO NODE VALUES ( 8, 'tiffy', 'NetBSD', '5.0.2') ok 29 - INSERT INTO NODE VALUES ( 9, 'rowlf', 'Debian Lenny', '5.0') ok 30 - INSERT INTO NODE VALUES (10, 'fozzy', 'Debian Lenny', '5.0') ok 31 - INSERT INTO PREC VALUES ( 1, 1, 1, 1) ok 32 - INSERT INTO PREC VALUES ( 2, 1, 2, 2) ok 33 - INSERT INTO PREC VALUES ( 3, 2, 2, 1) ok 34 - INSERT INTO PREC VALUES ( 4, 2, 1, 2) ok 35 - INSERT INTO PREC VALUES ( 5, 3, 5, 1) ok 36 - INSERT INTO PREC VALUES ( 6, 3, 7, 2) ok 37 - INSERT INTO PREC VALUES ( 7, 4, 6, 1) ok 38 - INSERT INTO PREC VALUES ( 8, 4, 8, 2) ok 39 - INSERT INTO PREC VALUES ( 9, 5, 7, 1) ok 40 - INSERT INTO PREC VALUES (10, 5, 5, 2) ok 41 - INSERT INTO PREC VALUES (11, 6, 8, 1) ok 42 - INSERT INTO PREC VALUES (12, 7, 6, 2) ok 43 - INSERT INTO PREC VALUES (13, 10, 9, 1) ok 44 - INSERT INTO PREC VALUES (14, 10, 10, 1) ok 45 - INSERT INTO PREC VALUES (15, 8, 9, 1) ok 46 - INSERT INTO PREC VALUES (16, 8, 10, 1) ok 47 - INSERT INTO PREC VALUES (17, 9, 9, 1) ok 48 - INSERT INTO PREC VALUES (17, 9, 10, 1) ok 49 - INSERT INTO PREC VALUES (18, 11, 3, 1) ok 50 - INSERT INTO PREC VALUES (19, 11, 4, 2) ok 51 - INSERT INTO PREC VALUES (20, 12, 4, 1) ok 52 - INSERT INTO PREC VALUES (21, 12, 3, 2) ok 53 - INSERT INTO LANDSCAPE VALUES (1, 'Logistic') ok 54 - INSERT INTO LANDSCAPE VALUES (2, 'Infrastructure') ok 55 - INSERT INTO LANDSCAPE VALUES (3, 'CPAN') ok 56 - INSERT INTO CONTACT VALUES ( 1, 'Hans Peter', 'Mueller', '12345', 'HPMUE', 'hp-mueller@here.com') ok 57 - INSERT INTO CONTACT VALUES ( 2, 'Knut', 'Inge', '54321', 'KINGE', 'k-inge@here.com') ok 58 - INSERT INTO CONTACT VALUES ( 3, 'Lola', 'Nguyen', '+1-123-45678-90', 'LNYUG', 'lola.ngyuen@customer.com') ok 59 - INSERT INTO CONTACT VALUES ( 4, 'Helge', 'Brunft', '+41-123-45678-09', 'HBRUN', 'helge.brunft@external-dc.at') ok 60 - INSERT INTO NM_LANDSCAPE VALUES ( 1, 1, 1, 2) ok 61 - INSERT INTO NM_LANDSCAPE VALUES ( 2, 1, 2, 2) ok 62 - INSERT INTO NM_LANDSCAPE VALUES ( 3, 3, 3, 2) ok 63 - INSERT INTO NM_LANDSCAPE VALUES ( 4, 3, 4, 2) ok 64 - INSERT INTO NM_LANDSCAPE VALUES ( 5, 2, 5, 2) ok 65 - INSERT INTO NM_LANDSCAPE VALUES ( 6, 2, 6, 2) ok 66 - INSERT INTO NM_LANDSCAPE VALUES ( 7, 2, 7, 2) ok 67 - INSERT INTO NM_LANDSCAPE VALUES ( 8, 2, 8, 2) ok 68 - INSERT INTO NM_LANDSCAPE VALUES ( 9, 3, 9, 2) ok 69 - INSERT INTO NM_LANDSCAPE VALUES (10, 3,10, 2) ok 70 - INSERT INTO NM_LANDSCAPE VALUES (11, 1, 1, 1) ok 71 - INSERT INTO NM_LANDSCAPE VALUES (12, 2, 2, 1) ok 72 - INSERT INTO NM_LANDSCAPE VALUES (13, 2, 2, 3) ok 73 - INSERT INTO NM_LANDSCAPE VALUES (14, 3, 1, 3) ok 74 - INSERT INTO APPL_CONTACT VALUES (1, 3, 1, 'OWNER') ok 75 - INSERT INTO APPL_CONTACT VALUES (2, 3, 2, 'OWNER') ok 76 - INSERT INTO APPL_CONTACT VALUES (3, 4, 3, 'ADMIN') ok 77 - INSERT INTO APPL_CONTACT VALUES (4, 4, 4, 'ADMIN') ok 78 - INSERT INTO APPL_CONTACT VALUES (5, 4, 5, 'ADMIN') ok 79 - INSERT INTO APPL_CONTACT VALUES (6, 4, 6, 'ADMIN') ok 80 - $stmt->execute "SELECT applname, appluniq, version, surname, familyname, phone, nodename FROM APPL, PREC, NODE, CONTACT, APPL_CONTACT WHERE appl_type='CUPS' AND APPL.id=PREC.appl_id AND PREC.node_id=NODE.id AND APPL_CONTACT.appl_id=APPL.id AND APPL_CONTACT.contact_id=CONTACT.id AND PREC.PRECEDENCE=1" (SELECT) ok 81 - SELECT applname, appluniq, version, surname, familyname, phone, nodename FROM APPL, PREC, NODE, CONTACT, APPL_CONTACT WHERE appl_type='CUPS' AND APPL.id=PREC.appl_id AND PREC.node_id=NODE.id AND APPL_CONTACT.appl_id=APPL.id AND APPL_CONTACT.contact_id=CONTACT.id AND PREC.PRECEDENCE=1 ok 82 - $stmt->execute "SELECT CONCAT('[% NOW %]') AS "timestamp", applname, appluniq, version, nodename FROM APPL, PREC, NODE WHERE appl_type LIKE '%DB' AND APPL.id=PREC.appl_id AND PREC.node_id=NODE.id" (SELECT) ok 83 - SELECT CONCAT('[% NOW %]') AS "timestamp", applname, appluniq, version, nodename FROM APPL, PREC, NODE WHERE appl_type LIKE '%DB' AND APPL.id=PREC.appl_id AND PREC.node_id=NODE.id ok 84 - $stmt->execute "SELECT DISTINCT applname, appluniq, version, surname, familyname, phone, nodename FROM APPL, PREC, NODE, CONTACT, APPL_CONTACT WHERE appl_type='CUPS' AND APPL.id=PREC.appl_id AND PREC.node_id=NODE.id AND APPL_CONTACT.appl_id=APPL.id AND APPL_CONTACT.contact_id=CONTACT.id ORDER BY applname" (SELECT) ok 85 - SELECT DISTINCT applname, appluniq, version, surname, familyname, phone, nodename FROM APPL, PREC, NODE, CONTACT, APPL_CONTACT WHERE appl_type='CUPS' AND APPL.id=PREC.appl_id AND PREC.node_id=NODE.id AND APPL_CONTACT.appl_id=APPL.id AND APPL_CONTACT.contact_id=CONTACT.id ORDER BY applname ok 86 - $stmt->execute "SELECT applname, appluniq, version, landscapename, nodename FROM APPL, PREC, NODE, LANDSCAPE, NM_LANDSCAPE WHERE appl_type LIKE '%DB' AND APPL.id=PREC.appl_id AND PREC.node_id=NODE.id AND NM_LANDSCAPE.obj_id=APPL.id AND NM_LANDSCAPE.obj_type=1 AND NM_LANDSCAPE.ls_id=LANDSCAPE.id" (SELECT) ok 87 - SELECT applname, appluniq, version, landscapename, nodename FROM APPL, PREC, NODE, LANDSCAPE, NM_LANDSCAPE WHERE appl_type LIKE '%DB' AND APPL.id=PREC.appl_id AND PREC.node_id=NODE.id AND NM_LANDSCAPE.obj_id=APPL.id AND NM_LANDSCAPE.obj_type=1 AND NM_LANDSCAPE.ls_id=LANDSCAPE.id ok 88 - $stmt->execute "SELECT applname, appluniq, version, nodename FROM APPL, PREC, NODE WHERE appl_type LIKE '%DB' AND APPL.id=PREC.appl_id AND PREC.node_id=NODE.id" (SELECT) ok 89 - SELECT applname, appluniq, version, nodename FROM APPL, PREC, NODE WHERE appl_type LIKE '%DB' AND APPL.id=PREC.appl_id AND PREC.node_id=NODE.id ok # SQL::Statement version 1.23 t/19idents.t ......... 1..11 ok 1 - use SQL::Statement; ok 2 - use SQL::Parser; ok 3 - Parsing SELECT "foo" FROM "SomeTable" ok 4 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] ok 5 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] ok 6 - Parsing SELECT "text" FROM "Table" ok 7 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] ok 8 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] ok 9 - Parsing SELECT foo FROM SomeTable ok 10 - Lowercased unquoted column name ok 11 - Lowercased unquoted table name ok t/20pod.t ............ 1..18 ok 1 - blib\lib\SQL\Eval.pm ok 2 - blib\lib\SQL\Parser.pm ok 3 - blib\lib\SQL\Statement.pm ok 4 - blib\lib\SQL\Dialects\ANSI.pm ok 5 - blib\lib\SQL\Dialects\AnyData.pm ok 6 - blib\lib\SQL\Dialects\CSV.pm ok 7 - blib\lib\SQL\Statement\Embed.pod ok 8 - blib\lib\SQL\Statement\Function.pm ok 9 - blib\lib\SQL\Statement\Functions.pm ok 10 - blib\lib\SQL\Statement\GetInfo.pm ok 11 - blib\lib\SQL\Statement\Operation.pm ok 12 - blib\lib\SQL\Statement\Placeholder.pm ok 13 - blib\lib\SQL\Statement\RAM.pm ok 14 - blib\lib\SQL\Statement\Structure.pod ok 15 - blib\lib\SQL\Statement\Syntax.pod ok 16 - blib\lib\SQL\Statement\Term.pm ok 17 - blib\lib\SQL\Statement\TermFactory.pm ok 18 - blib\lib\SQL\Statement\Util.pm ok t/21pod_coverage.t ... 1..15 ok 1 - Pod coverage on SQL::Eval ok 2 - Pod coverage on SQL::Parser ok 3 - Pod coverage on SQL::Statement ok 4 - Pod coverage on SQL::Dialects::ANSI ok 5 - Pod coverage on SQL::Dialects::AnyData ok 6 - Pod coverage on SQL::Dialects::CSV ok 7 - Pod coverage on SQL::Statement::Function ok 8 - Pod coverage on SQL::Statement::Functions ok 9 - Pod coverage on SQL::Statement::GetInfo ok 10 - Pod coverage on SQL::Statement::Operation ok 11 - Pod coverage on SQL::Statement::Placeholder ok 12 - Pod coverage on SQL::Statement::RAM ok 13 - Pod coverage on SQL::Statement::Term ok 14 - Pod coverage on SQL::Statement::TermFactory ok 15 - Pod coverage on SQL::Statement::Util ok Test Summary Report ------------------- t/03executeDBD.t (Wstat: 512 Tests: 22 Failed: 0) Non-zero exit status: 2 Parse errors: Bad plan. You planned 26 tests but ran 22. t/05create.t (Wstat: 512 Tests: 3 Failed: 0) Non-zero exit status: 2 Parse errors: Bad plan. You planned 5 tests but ran 3. t/16morejoins.t (Wstat: 0 Tests: 48 Failed: 0) TODO passed: 42-43, 46-47 Files=22, Tests=528, 9 wallclock secs ( 0.05 usr + 0.19 sys = 0.23 CPU) Result: FAIL Failed 2/22 test programs. 0/528 subtests failed. NMAKE : fatal error U1077: 'C:\Perl-5.8\bin\perl.exe' : return code '0xff' Stop. REHSACK/SQL-Statement-1.23.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.23.tar.gz Running make for H/HM/HMBRAND/DBD-CSV-0.26.tgz Has already been unwrapped into directory C:\cpanfly-5.8\var\cpan\build\DBD-CSV-0.26-WUJ3eh CPAN.pm: Going to build H/HM/HMBRAND/DBD-CSV-0.26.tgz Warning: Prerequisite 'SQL::Statement => 1.22' for 'HMBRAND/DBD-CSV-0.26.tgz' failed when processing 'REHSACK/SQL-Statement-1.23.tar.gz' with 'make_test => NO'. Continuing, but chances to succeed are limited. >>> nmake Microsoft (R) Program Maintenance Utility Version 7.00.8882 Copyright (C) Microsoft Corp 1988-2000. All rights reserved. cp lib/Bundle/DBD/CSV.pm blib\lib\Bundle\DBD\CSV.pm cp lib/DBD/CSV.pm blib\lib\DBD\CSV.pm HMBRAND/DBD-CSV-0.26.tgz 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/00_meta.t ............ 1..2 ok 1 - META.yml contains valid YAML ok 2 - META.yml meets the designated specification ok # Failed test 't/80_rt.t' # at C:/cpanfly-5.8/var/megalib/Test/MinimumVersion.pm line 150. # t/80_rt.t requires 5.006 due to syntax # version markers for 5.006: # - _three_argument_open # Looks like you failed 1 test of 25. t/00_minimumversion.t .. 1..25 ok 1 - lib/Bundle/DBD/CSV.pm ok 2 - lib/DBD/CSV.pm ok 3 - t/00_meta.t ok 4 - t/00_minimumversion.t ok 5 - t/00_pod.t ok 6 - t/00_pod_cov.t ok 7 - t/10_base.t ok 8 - t/11_dsnlist.t ok 9 - t/20_createdrop.t ok 10 - t/30_insertfetch.t ok 11 - t/40_numrows.t ok 12 - t/41_nulls.t ok 13 - t/42_bindparam.t ok 14 - t/43_blobs.t ok 15 - t/44_listfields.t ok 16 - t/50_chopblanks.t ok 17 - t/51_commit.t ok 18 - t/60_misc.t ok 19 - t/70_csv.t ok 20 - t/71_csv-ext.t ok 21 - t/72_csv-schema.t ok 22 - t/73_csv-case.t not ok 23 - t/80_rt.t ok 24 - t/lib.pl ok 25 - Makefile.PL Dubious, test returned 1 (wstat 256, 0x100) Failed 1/25 subtests t/00_pod.t ............. 1..2 ok 1 - blib\lib\DBD\CSV.pm ok 2 - blib\lib\Bundle\DBD\CSV.pm ok t/00_pod_cov.t ......... 1..1 ok 1 - DBD::CSV is covered ok t/10_base.t ............ 1..8 ok 1 - use DBI; ok 2 - use SQL::Statement; ok 3 - SQL::Statement::Version 0.1021 ok 4 - DBI->internal ok 5 - Driver class ok 6 - Install driver ok 7 - Driver class installed ok 8 - Driver version 0.26 ok t/11_dsnlist.t ......... 1..15 ok 1 - use DBI; ok 2 - Driver is CSV # ok 3 - Connect ok 4 - ping ok 5 - data_sources ok 6 - more than one ok 7 - disconnect ok 8 - use . as f_dir ok 9 - disconnect ok 10 - use example as f_dir ok 11 - disconnect ok 12 - use lib as f_dir ok 13 - disconnect ok 14 - use t as f_dir ok 15 - disconnect ok t/20_createdrop.t ...... 1..9 ok 1 - use DBI; ok 2 - connect ok 3 - find new test table ok 4 - table definition ok 5 - create table ok 6 - file exists ok 7 - drop table ok 8 - disconnect ok 9 - file removed ok t/30_insertfetch.t ..... 1..25 ok 1 - use DBI; ok 2 - connect ok 3 - find new test table ok 4 - table definition ok 5 - create table ok 6 - file exists ok 7 - insert ok 8 - file grew ok 9 - prepare ok 10 - handle type ok 11 - execute ok 12 - fetch ok 13 - returned a list ok 14 - no error ok 15 - content ok 16 - finish ok 17 - delete ok 18 - prepare ok 19 - handle type ok 20 - execute ok 21 - fetch ok 22 - error ok 23 - finish ok 24 - drop ok 25 - disconnect ok t/40_numrows.t ......... 1..25 ok 1 - use DBI; ok 2 - connect ok 3 - find new test table ok 4 - table definition ok 5 - create table ok 6 - insert ok 7 - prepare ok 8 - execute ok 9 - numrows ok 10 - true rows ok 11 - finish ok 12 - insert ok 13 - prepare ok 14 - execute ok 15 - rows ok 16 - true rows ok 17 - finish ok 18 - insert ok 19 - prepare ok 20 - execute ok 21 - rows ok 22 - true rows ok 23 - finish ok 24 - drop ok 25 - disconnect ok # Failed test 'fetch' # at t/41_nulls.t line 28. # Failed test 'default content' # at t/41_nulls.t line 30. # Structures begin differing at: # $got = undef # $expected = ARRAY(0x1c7c010) # Looks like you failed 2 tests of 29. t/41_nulls.t ........... 1..29 ok 1 - use DBI; ok 2 - connect ok 3 - find new test table ok 4 - table definition ok 5 - create table ok 6 - insert ok 7 - prepare ok 8 - execute not ok 9 - fetch not ok 10 - default content ok 11 - finish ok 12 - connect csv_null ok 13 - prepare ok 14 - execute ok 15 - fetch ok 16 - NULL content ok 17 - finish ok 18 - drop table ok 19 - disconnect ok 20 - connect csv_null ok 21 - create table ok 22 - insert just 2 ok 23 - prepare ok 24 - execute ok 25 - fetch ok 26 - content ok 27 - finish ok 28 - drop table ok 29 - disconnect Dubious, test returned 2 (wstat 512, 0x200) Failed 2/29 subtests t/42_bindparam.t ....... 1..48 ok 1 - use DBI; ok 2 - connect ok 3 - Allow NULL ok 4 - find new test table ok 5 - table definition ok 6 - create table ok 7 - prepare ok 8 - execute insert 1 ok 9 - execute insert 2 ok 10 - execute insert 3 ok 11 - bind 4 int ok 12 - bind str ok 13 - execute ok 14 - bind 5 int ok 15 - bind NULL ok 16 - execute ok 17 - finish ok 18 - disconnect ok 19 - connect ok 20 - prepare ok 21 - execute ok 22 - bind_columns ok 23 - execute ok 24 - fetch ok 25 - id 1 ok 26 - name 1 ok 27 - fetch ok 28 - id 2 ok 29 - name 2 ok 30 - fetch ok 31 - id 3 ok 32 - name 3 ok 33 - fetch ok 34 - id 4 ok 35 - name 4 ok 36 - fetch ok 37 - id 5 ok 38 - name 5 ok 39 - finish ok 40 - prepare update ok 41 - update ok 42 - finish ok 43 - prepare update ok 44 - update ok 45 - update ok 46 - finish ok 47 - drop table ok 48 - disconnect ok t/43_blobs.t ........... 1..15 ok 1 - use DBI; ok 2 - connect ok 3 - find new test table ok 4 - table definition ok 5 - create table ok 6 - create blob ok 7 - quote blob ok 8 - insert ok 9 - prepare ok 10 - execute ok 11 - fetch ok 12 - content ok 13 - finish ok 14 - drop table ok 15 - disconnect ok # Failed test 'PRECISION 1' # at t/44_listfields.t line 40. # got: undef # expected: '0' # Failed test 'PRECISION 2' # at t/44_listfields.t line 41. # got: undef # expected: '64' # Failed test 'NULLABLE 1' # at t/44_listfields.t line 42. # got: undef # expected: '0' # Failed test 'NULLABLE 2' # at t/44_listfields.t line 43. # got: undef # expected: '1' # Looks like you failed 4 tests of 19. t/44_listfields.t ...... ok 1 - use DBI; ok 2 - connect ok 3 - find new test table ok 4 - table definition ok 5 - create table ok 6 - prepare ok 7 - execute ok 8 - NUM_OF_FIELDS ok 9 - NUM_OF_PARAMS ok 10 - NAME_lc ok 11 - NAME_uc ok 12 - NAME_lc_hash not ok 13 - PRECISION 1 not ok 14 - PRECISION 2 not ok 15 - NULLABLE 1 not ok 16 - NULLABLE 2 ok 17 - finish ok 18 - drop table ok 19 - disconnect 1..19 Dubious, test returned 4 (wstat 1024, 0x400) Failed 4/19 subtests t/50_chopblanks.t ...... 1..38 ok 1 - use DBI; ok 2 - connect ok 3 - find new test table ok 4 - table definition ok 5 - create table ok 6 - prepare ins ok 7 - prepare sel ok 8 - insert 1 ok 9 - ChopBlanks 0 ok 10 - execute ok 11 - fetch ok 12 - content ok 13 - ChopBlanks 1 ok 14 - execute ok 15 - fetch ok 16 - content ok 17 - insert 2 ok 18 - ChopBlanks 0 ok 19 - execute ok 20 - fetch ok 21 - content ok 22 - ChopBlanks 1 ok 23 - execute ok 24 - fetch ok 25 - content ok 26 - insert 3 ok 27 - ChopBlanks 0 ok 28 - execute ok 29 - fetch ok 30 - content ok 31 - ChopBlanks 1 ok 32 - execute ok 33 - fetch ok 34 - content ok 35 - finish sti ok 36 - finish sth ok 37 - drop table ok 38 - disconnect ok DBD::CSV::db prepare failed: Parse error near (*) FROM testaa at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 272. [for Statement "SELECT count (*) FROM testaa"] at t/51_commit.t line 22. # Failed test '1 row' # at t/51_commit.t line 44. # got: undef # expected: '1' DBD::CSV::db prepare failed: Parse error near (*) FROM testaa at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 272. [for Statement "SELECT count (*) FROM testaa"] at t/51_commit.t line 22. # Failed test 'still 1 row' # at t/51_commit.t line 49. # got: undef # expected: '1' # Looks like you failed 2 tests of 24. t/51_commit.t .......... 1..24 ok 1 - use DBI; ok 2 - connect ok 3 - find new test table ok 4 - table definition ok 5 - create table ok 6 - AutoCommit on ok 7 - disable ok 8 - AutoCommit still on ok 9 - insert 1 not ok 10 - 1 row ok 11 - disconnect ok 12 - connect not ok 13 - still 1 row ok 14 - insert 2 ok 15 - AutoCommit on ok 16 - commit ok 17 - warning ok 18 - insert 3 ok 19 - AutoCommit on ok 20 - rollback ok 21 - warning ok 22 - err ok 23 - drop table ok 24 - disconnect Dubious, test returned 2 (wstat 512, 0x200) Failed 2/24 subtests t/60_misc.t ............ 1..40 ok 1 - use DBI; ok 2 - connect ok 3 - find new test table ok 4 - table definition ok 5 - create table ok 6 - quote ok 7 - prepare ok 8 - fetch w/o execute ok 9 - one error ok 10 - error message ok 11 - execute ok 12 - fetch no rows ok 13 - finish ok 14 - prepare ins ok 15 - insert 1 ok 16 - insert 2 ok 17 - insert 3 ok 18 - insert 4 ok 19 - insert 5 ok 20 - insert 6 ok 21 - insert 7 ok 22 - insert 8 ok 23 - insert 9 ok 24 - finish ok 25 - prepare sel ok 26 - execute 1 ok 27 - execute 2 ok 28 - fetchrow_array ok 29 - content ok 30 - fetchrow_arrayref ok 31 - content ok 32 - fetchrow_hashref ok 33 - content ok 34 - fetchall_hashref ok 35 - content ok 36 - execute ok 37 - fetchall_arrayref ok 38 - content ok 39 - drop table ok 40 - disconnect ok t/70_csv.t ............. 1..67 ok 1 - use DBI; ok 2 - connect ok 3 - default dir ok 4 - set f_dir ok 5 - find new test table ok 6 - does not exist ok 7 - find new test table ok 8 - does not exist ok 9 - find new test table ok 10 - does not exist ok 11 - different 1 2 ok 12 - different 1 3 ok 13 - different 2 3 ok 14 - table definition ok 15 - create table 1 ok 16 - does exists ok 17 - drop table ok 18 - does not exist ok 19 - disconnect ok 20 - connect ok 21 - create table ok 22 - does exists ok 23 - insert 1 ok 24 - insert 2 ok 25 - prepare ok 26 - execute ok 27 - fetch 1 ok 28 - content ok 29 - fetch 2 ok 30 - content ok 31 - finish ok 32 - drop table ok 33 - does not exist ok 34 - disconnect ok 35 - connect ok 36 - set table/file ok 37 - create table ok 38 - does exists ok 39 - drop table ok 40 - disconnect ok 41 - connect with attr ok 42 - dbd_verbose set ok 43 - f_ext set ok 44 - sep_char set ok 45 - blank_is_undef set ok 46 - create table ok 47 - does exists ok 48 - prepare ok 49 - not enough values ok 50 - error message ok 51 - prepare ok 52 - too many values ok 53 - error message ok 54 - insert 0 ok 55 - insert 1 ok 56 - insert 2 ok 57 - insert 3 ok 58 - insert 4 ok 59 - insert 5 ok 60 - insert 6 ok 61 - insert 7 ok 62 - insert 8 ok 63 - insert 9 ok 64 - drop table ok 65 - does not exist ok 66 - does not exist ok 67 - disconnect ok DBD::CSV::db do failed: Parse error near .csv (id INTEGER NOT NULL, name CHAR (64) NOT NULL) at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 272. [for Statement "CREATE TABLE testaa.csv (id INTEGER NOT NULL, name CHAR (64) NOT NULL)"] at t/71_csv-ext.t line 39. # Failed test 'create table .csv' # at t/71_csv-ext.t line 39. # Failed test 'does exists' # at t/71_csv-ext.t line 40. DBD::CSV::db do failed: Parse error near .foo (id INTEGER NOT NULL, name CHAR (64) NOT NULL) at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 272. [for Statement "CREATE TABLE testaa.foo (id INTEGER NOT NULL, name CHAR (64) NOT NULL)"] at t/71_csv-ext.t line 39. # Failed test 'create table .foo' # at t/71_csv-ext.t line 39. # Failed test 'does exists' # at t/71_csv-ext.t line 40. DBD::CSV::db do failed: Parse error near .txt (id INTEGER NOT NULL, name CHAR (64) NOT NULL) at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 272. [for Statement "CREATE TABLE testaa.txt (id INTEGER NOT NULL, name CHAR (64) NOT NULL)"] at t/71_csv-ext.t line 39. # Failed test 'create table .txt' # at t/71_csv-ext.t line 39. # Failed test 'does exists' # at t/71_csv-ext.t line 40. # Failed test 'for all ext' # at t/71_csv-ext.t line 44. # Structures begin differing at: # $got->[1] = Does not exist # $expected->[1] = 'testaa.csv' # Failed test 'for all ext' # at t/71_csv-ext.t line 55. # Structures begin differing at: # $got->[1] = Does not exist # $expected->[1] = 'testaa.foo' # Failed test 'tables' # at t/71_csv-ext.t line 64. # Failed test 'just one' # at t/71_csv-ext.t line 65. # Structures begin differing at: # $got->[0] = Does not exist # $expected->[0] = 'testaa' # Looks like you planned 35 tests but ran 32. # Looks like you failed 10 tests of 32 run. t/71_csv-ext.t ......... 1..35 ok 1 - use DBI; ok 2 - connect ok 3 - find new test table ok 4 - does not exist ok 5 - table definition ok 6 - create table ok 7 - does exists ok 8 - table definition not ok 9 - create table .csv not ok 10 - does exists ok 11 - table definition not ok 12 - create table .foo not ok 13 - does exists ok 14 - table definition not ok 15 - create table .txt not ok 16 - does exists ok 17 - tables not ok 18 - for all ext ok 19 - disconnect ok 20 - connect (f_ext => .csv) ok 21 - tables not ok 22 - for all ext ok 23 - disconnect ok 24 - connect (f_ext => .csv/r) not ok 25 - tables not ok 26 - just one ok 27 - disconnect ok 28 - connect ok 29 - tables ok 30 - drop table testaa ok 31 - disconnect ok 32 - no files left Dubious, test returned 10 (wstat 2560, 0xa00) Failed 13/35 subtests t/72_csv-schema.t ...... 1..12 ok 1 - use DBI; ok 2 - connect ok 3 - find new test table ok 4 - table definition ok 5 - create table ok 6 - tables ok 7 - disconnect ok 8 - connect (f_schema => undef) ok 9 - tables ok 10 - drop table ok 11 - disconnect ok 12 - no files left ok DBD::CSV::db prepare failed: Parse error near "foo" at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 272. [for Statement "select * from "foo""] at t/73_csv-case.t line 43. # Failed test 'prepare "foo"' # at t/73_csv-case.t line 43. Can't call method "execute" on an undefined value at t/73_csv-case.t line 46. # Looks like you failed 1 test of 27. # Looks like your test exited with 2 just after 27. t/73_csv-case.t ........ ok 1 - use DBI; ok 2 - connect ok 3 - foo does not exist ok 4 - ignore missing tables ok 5 - table definition ok 6 - create table ok 7 - does exists ok 8 - select from foo ok 9 - execute ok 10 - select from foO ok 11 - execute ok 12 - select from fOo ok 13 - execute ok 14 - select from fOO ok 15 - execute ok 16 - select from Foo ok 17 - execute ok 18 - select from FoO ok 19 - execute ok 20 - select from FOo ok 21 - execute ok 22 - select from FOO ok 23 - execute ok 24 - disconnect ok 25 - connect ok 26 - ignore missing tables not ok 27 - prepare "foo" 1..27 Dubious, test returned 2 (wstat 512, 0x200) Failed 1/27 subtests DBD::CSV::st execute failed: Unknown column: rt18477.SEGNO at C:/cpanfly-5.8/var/megalib/SQL/Statement.pm line 53, line 1. [for Statement " select SEGNO, OWNER, TYPE, NAMESPACE, EXPERIMENT, STREAM, UPDATED, SIZE from rt18477 where NAMESPACE = ? and EXPERIMENT LIKE ? and STREAM LIKE ? "] at t/80_rt.t line 42. # Failed test 'execute' # at t/80_rt.t line 42. DBD::CSV::st fetch failed: Attempt to fetch row without a preceeding execute () call or from a non-SELECT statement [for Statement " select SEGNO, OWNER, TYPE, NAMESPACE, EXPERIMENT, STREAM, UPDATED, SIZE from rt18477 where NAMESPACE = ? and EXPERIMENT LIKE ? and STREAM LIKE ? "] at t/80_rt.t line 43. # Failed test 'fetch' # at t/80_rt.t line 43. # Failed test 'content' # at t/80_rt.t line 44. # Structures begin differing at: # $got = undef # $expected = ARRAY(0x1c7b4dc) DBD::CSV::db do failed: Parse error near PRIMARY KEY (test)) at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 272. [for Statement "CREATE TABLE rt20550(test INT, PRIMARY KEY (test))"] at t/80_rt.t line 55. # Failed test 'prepare' # at t/80_rt.t line 55. DBD::CSV::db do failed: Cannot open output\rt20550: No such file or directory at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 565 [for Statement "drop table rt20550"] at t/80_rt.t line 56. # Failed test 'drop table' # at t/80_rt.t line 56. DBD::CSV::db selectrow_hashref failed: Parse error near JOIN rt43010_1 USING (id) at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 272. [for Statement "SELECT * FROM rt43010_0 JOIN rt43010_1 USING (id)"] at t/80_rt.t line 113. # Failed test 'join 1 2' # at t/80_rt.t line 113. # Failed test 'content' # at t/80_rt.t line 119. # Structures begin differing at: # $got = undef # $expected = HASH(0x1c74b5c) DBD::CSV::db do failed: Parse error near , id integer ) at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 272. [for Statement " create table RT46627 ( name varchar, id integer )"] at t/80_rt.t line 166. # Failed test 'create' # at t/80_rt.t line 166. DBD::CSV::st execute failed: Cannot open output\RT46627.csv: No such file or directory at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 565 [for Statement " insert into RT46627 values (?, ?)"] at t/80_rt.t line 174. # Failed test 'insert 1' # at t/80_rt.t line 174. DBD::CSV::st execute failed: Cannot open output\RT46627.csv: No such file or directory at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 565 [for Statement " insert into RT46627 values (?, ?)"] at t/80_rt.t line 175. # Failed test 'insert 2' # at t/80_rt.t line 175. DBD::CSV::db do failed: Parse error near ) values (?, ?) at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 272. [for Statement " insert into RT46627 ( name, id, ) values (?, ?)"] at t/80_rt.t line 177. # Failed test 'insert 3' # at t/80_rt.t line 177. DBD::CSV::st execute failed: Cannot open output\RT46627.csv: No such file or directory at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 565 [for Statement " update RT46627 set name = ? where id = ?"] at t/80_rt.t line 189. # Failed test 'update' # at t/80_rt.t line 189. DBD::CSV::st execute failed: Cannot open output\RT46627.csv: No such file or directory at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 565 [for Statement " update RT46627 set name = ? where id = ?"] at t/80_rt.t line 190. # Failed test 'update' # at t/80_rt.t line 190. binmode() on closed filehandle $fh at t/80_rt.t line 194. readline() on closed filehandle $fh at t/80_rt.t line 195. # Failed test 'Field names' # at t/80_rt.t line 195. # got: undef # expected: 'name,id # ' readline() on closed filehandle $fh at t/80_rt.t line 196. # Failed test 'Record 1' # at t/80_rt.t line 196. # got: undef # expected: 'Tim,1 # ' readline() on closed filehandle $fh at t/80_rt.t line 197. # Failed test 'Record 2' # at t/80_rt.t line 197. # got: undef # expected: 'Tux,2 # ' readline() on closed filehandle $fh at t/80_rt.t line 198. # Failed test 'Record 3' # at t/80_rt.t line 198. # got: undef # expected: ',3 # ' readline() on closed filehandle $fh at t/80_rt.t line 199. DBD::CSV::db do failed: Cannot open output\RT46627.csv: No such file or directory at C:/cpanfly-5.8/var/megalib/DBD/File.pm line 565 [for Statement "drop table RT46627"] at t/80_rt.t line 202. # Failed test 'drop' # at t/80_rt.t line 202. # Looks like you failed 18 tests of 82. t/80_rt.t .............. ok 1 - RT-18477 - use of prepare/execute with placeholders fails ok 2 - connect ok 3 - prepare ok 4 - execute ok 5 - prepare not ok 6 - execute not ok 7 - fetch not ok 8 - content ok 9 - finish ok 10 - drop table ok 11 - disconnect ok 12 - RT-20550 - Using "Primary key" leads to error ok 13 - connect not ok 14 - prepare not ok 15 - drop table ok 16 - disconnect ok 17 - RT-33764 - $! is not an indicator of failure ok 18 - connect ok 19 - prepare ok 20 - execute ok 21 - error message ok 22 - fetch ok 23 - error message ok 24 - finish ok 25 - drop table ok 26 - disconnect ok 27 - RT-43010 - treatment of nulls scrambles joins ok 28 - connect ok 29 - table def ok 30 - create table ok 31 - table def ok 32 - create table ok 33 - insert 1 ok 34 - insert 2 not ok 35 - join 1 2 not ok 36 - content ok 37 - drop table ok 38 - drop table ok 39 - disconnect ok 40 - RT-44583 - DBD::CSV cannot read CSV files with dots on the first line ok 41 - connect ok 42 - prepare ok 43 - execute ok 44 - field names ok 45 - prepare ok 46 - execute ok 47 - fetch ok 48 - content ok 49 - finish ok 50 - connect ok 51 - prepare ok 52 - field names ok 53 - finish ok 54 - drop table ok 55 - disconnect ok 56 - RT-46627 - DBD::File is damaged now ok 57 - connect not ok 58 - create ok 59 - prepare ins not ok 60 - insert 1 not ok 61 - insert 2 ok 62 - finish not ok 63 - insert 3 ok 64 - prepare upd not ok 65 - update not ok 66 - update ok 67 - finish not ok 68 - Field names not ok 69 - Record 1 not ok 70 - Record 2 not ok 71 - Record 3 ok 72 - EOF not ok 73 - drop ok 74 - disconnect ok 75 - RT-51090 - Report a bug in DBD-CSV ok 76 - connect ok 77 - prepare ok 78 - set types (4 -1 2) ok 79 - execute ok 80 - get types (1 0 2) ok 81 - drop ok 82 - disconnect 1..82 Dubious, test returned 18 (wstat 4608, 0x1200) Failed 18/82 subtests Test Summary Report ------------------- t/00_minimumversion.t (Wstat: 256 Tests: 25 Failed: 1) Failed test: 23 Non-zero exit status: 1 t/41_nulls.t (Wstat: 512 Tests: 29 Failed: 2) Failed tests: 9-10 Non-zero exit status: 2 t/44_listfields.t (Wstat: 1024 Tests: 19 Failed: 4) Failed tests: 13-16 Non-zero exit status: 4 t/51_commit.t (Wstat: 512 Tests: 24 Failed: 2) Failed tests: 10, 13 Non-zero exit status: 2 t/71_csv-ext.t (Wstat: 2560 Tests: 32 Failed: 10) Failed tests: 9-10, 12-13, 15-16, 18, 22, 25-26 Non-zero exit status: 10 Parse errors: Bad plan. You planned 35 tests but ran 32. t/73_csv-case.t (Wstat: 512 Tests: 27 Failed: 1) Failed test: 27 Non-zero exit status: 2 t/80_rt.t (Wstat: 4608 Tests: 82 Failed: 18) Failed tests: 6-8, 14-15, 35-36, 58, 60-61, 63, 65-66 68-71, 73 Non-zero exit status: 18 Files=21, Tests=545, 9 wallclock secs ( 0.01 usr + 0.28 sys = 0.30 CPU) Result: FAIL Failed 7/21 test programs. 38/545 subtests failed. NMAKE : fatal error U1077: 'C:\Perl-5.8\bin\perl.exe' : return code '0x12' Stop. HMBRAND/DBD-CSV-0.26.tgz nmake test TEST_VERBOSE=1 -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports HMBRAND/DBD-CSV-0.26.tgz Finished 2009-11-25T07:38:06