Start 2010-07-18T04:05:37
ActivePerl-818 CPAN-1.9402
Going to read '/home/fly818/var/cpan/Metadata'
Database was generated on Sat, 17 Jul 2010 21:26:57 GMT
Running make for R/RE/REHSACK/DBD-AnyData-0.110.tar.gz
Checksum for /net/nas/data/cpan/authors/id/R/RE/REHSACK/DBD-AnyData-0.110.tar.gz ok
Will not use Archive::Tar, need 1.00
DBD-AnyData-0.110
DBD-AnyData-0.110/META.yml
DBD-AnyData-0.110/Changes
DBD-AnyData-0.110/MANIFEST
DBD-AnyData-0.110/MANIFEST.SKIP
DBD-AnyData-0.110/Build.PL
DBD-AnyData-0.110/Makefile.PL
DBD-AnyData-0.110/README
DBD-AnyData-0.110/lib
DBD-AnyData-0.110/lib/DBD
DBD-AnyData-0.110/lib/DBD/AnyData.pm
DBD-AnyData-0.110/t
DBD-AnyData-0.110/t/00-load.t
DBD-AnyData-0.110/t/manifest.t
DBD-AnyData-0.110/t/pod.t
DBD-AnyData-0.110/t/01-basic.t
CPAN.pm: Going to build R/RE/REHSACK/DBD-AnyData-0.110.tar.gz
>>> /home/fly818/ap818/bin/perl-static Makefile.PL
Checking if your kit is complete...
Looks good
Writing Makefile for DBD::AnyData
---- Unsatisfied dependencies detected during ----
---- REHSACK/DBD-AnyData-0.110.tar.gz ----
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.28.tar.gz
Checksum for /net/nas/data/cpan/authors/id/R/RE/REHSACK/SQL-Statement-1.28.tar.gz ok
Will not use Archive::Tar, need 1.00
SQL-Statement-1.28
SQL-Statement-1.28/lib
SQL-Statement-1.28/lib/SQL
SQL-Statement-1.28/lib/SQL/Dialects
SQL-Statement-1.28/lib/SQL/Dialects/ANSI.pm
SQL-Statement-1.28/lib/SQL/Dialects/Role.pm
SQL-Statement-1.28/lib/SQL/Dialects/AnyData.pm
SQL-Statement-1.28/lib/SQL/Dialects/CSV.pm
SQL-Statement-1.28/lib/SQL/Statement
SQL-Statement-1.28/lib/SQL/Statement/TermFactory.pm
SQL-Statement-1.28/lib/SQL/Statement/Structure.pod
SQL-Statement-1.28/lib/SQL/Statement/GetInfo.pm
SQL-Statement-1.28/lib/SQL/Statement/Term.pm
SQL-Statement-1.28/lib/SQL/Statement/Syntax.pod
SQL-Statement-1.28/lib/SQL/Statement/RAM.pm
SQL-Statement-1.28/lib/SQL/Statement/Placeholder.pm
SQL-Statement-1.28/lib/SQL/Statement/Roadmap.pod
SQL-Statement-1.28/lib/SQL/Statement/Function.pm
SQL-Statement-1.28/lib/SQL/Statement/Util.pm
SQL-Statement-1.28/lib/SQL/Statement/Embed.pod
SQL-Statement-1.28/lib/SQL/Statement/Operation.pm
SQL-Statement-1.28/lib/SQL/Statement/Functions.pm
SQL-Statement-1.28/lib/SQL/Statement.pm
SQL-Statement-1.28/lib/SQL/Parser.pm
SQL-Statement-1.28/lib/SQL/Eval.pm
SQL-Statement-1.28/t
SQL-Statement-1.28/t/14allcols.t
SQL-Statement-1.28/t/19idents.t
SQL-Statement-1.28/t/11functions.t
SQL-Statement-1.28/t/20pod.t
SQL-Statement-1.28/t/06aggregate.t
SQL-Statement-1.28/t/SQLtest.pm
SQL-Statement-1.28/t/13call.t
SQL-Statement-1.28/t/04names.t
SQL-Statement-1.28/t/21pod_coverage.t
SQL-Statement-1.28/t/17quoting.t
SQL-Statement-1.28/t/00error.t
SQL-Statement-1.28/t/03executeDBD.t
SQL-Statement-1.28/t/01prepare.t
SQL-Statement-1.28/t/09ops.t
SQL-Statement-1.28/t/08join.t
SQL-Statement-1.28/t/02executeDirect.t
SQL-Statement-1.28/t/12eval.t
SQL-Statement-1.28/t/23dialects.t
SQL-Statement-1.28/t/07case.t
SQL-Statement-1.28/t/18bigjoin.t
SQL-Statement-1.28/t/10limit.t
SQL-Statement-1.28/t/05create.t
SQL-Statement-1.28/t/16morejoins.t
SQL-Statement-1.28/t/15naturaljoins.t
SQL-Statement-1.28/t/22calc.t
SQL-Statement-1.28/Changes
SQL-Statement-1.28/MANIFEST
SQL-Statement-1.28/META.yml
SQL-Statement-1.28/.aspell.local.pws
SQL-Statement-1.28/MANIFEST.SKIP
SQL-Statement-1.28/Makefile.PL
SQL-Statement-1.28/README
CPAN.pm: Going to build R/RE/REHSACK/SQL-Statement-1.28.tar.gz
>>> /home/fly818/ap818/bin/perl-static Makefile.PL
***
This version of SQL::Statement conflicts with
the version of module DBD::AnyData (0.09) you have installed.
It's strongly recommended that you update it after
installing this version of SQL::Statement.
***
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/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/Dialects/Role.pm blib/lib/SQL/Dialects/Role.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/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/Statement/Roadmap.pod blib/lib/SQL/Statement/Roadmap.pod
cp lib/SQL/Eval.pm blib/lib/SQL/Eval.pm
cp lib/SQL/Statement/Function.pm blib/lib/SQL/Statement/Function.pm
cp lib/SQL/Statement/Functions.pm blib/lib/SQL/Statement/Functions.pm
Manifying blib/man3/SQL::Dialects::ANSI.3
Manifying blib/man3/SQL::Statement::TermFactory.3
Manifying blib/man3/SQL::Parser.3
Manifying blib/man3/SQL::Statement::Util.3
Manifying blib/man3/SQL::Statement::Structure.3
Manifying blib/man3/SQL::Statement::GetInfo.3
Manifying blib/man3/SQL::Statement::Term.3
Manifying blib/man3/SQL::Dialects::Role.3
Manifying blib/man3/SQL::Statement::Syntax.3
Manifying blib/man3/SQL::Dialects::AnyData.3
Manifying blib/man3/SQL::Statement::RAM.3
Manifying blib/man3/SQL::Statement::Embed.3
Manifying blib/man3/SQL::Statement::Placeholder.3
Manifying blib/man3/SQL::Statement.3
Manifying blib/man3/SQL::Dialects::CSV.3
Manifying blib/man3/SQL::Eval.3
Manifying blib/man3/SQL::Statement::Roadmap.3
Manifying blib/man3/SQL::Statement::Operation.3
Manifying blib/man3/SQL::Statement::Functions.3
Manifying blib/man3/SQL::Statement::Function.3
REHSACK/SQL-Statement-1.28.tar.gz
make -- OK
Running make test
>>> make test TEST_VERBOSE=1
PERL_DL_NONLAZY=1 /home/fly818/ap818/bin/perl-static "-MExtUtils::Command::MM" "-e" "test_harness(1, 'blib/lib', 'blib/arch')" t/*.t
t/00error.t ..........
1..6
SQL::Statement v.1.28
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.28
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.28
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 TEMP 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
t/03executeDBD.t .....
SQL::Statement v.1.28
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)
ok 23 - IMPORT($external_sth)
ok 24 - DROP TEMP TABLE
ok 25 - UPDATE with placeholders
ok 26 - UPDATE with placeholder updates correct
ok
t/04names.t ..........
1..5
SQL::Statement v.1.28
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.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)
ok 4 - CREATE TABLE AS IMPORT($external_sth)
ok 5 - CREATE TABLE AS SELECT
ok
# SQL::Statement v1.28
# DBI v1.612
# DBD::File v0.39
t/06aggregate.t ......
1..15
ok 1 - GROUP BY one column
ok 2 - GROUP BY several columns
ok 3 - AGGREGATE FUNCTIONS WITHOUT GROUP BY
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 - SUM(bar) of empty table
ok 9 - COUNT(bar) of empty table with GROUP BY
ok 10 - COUNT(*) of empty table
ok 11 - Names in aggregated Table
ok 12 - Number of rows in aggregated Table
ok 13 - SUM(COUNTED)
ok 14 - Aggregate functions
ok 15 - Nasty COUNT(*)
ok
t/07case.t ...........
1..12
SQL::Statement v.1.28
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.28
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.28
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.28
ok 1 - limit with order by
ok 2 - limit without order by
ok
t/11functions.t ......
1..23
SQL::Statement v.1.28
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.28
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.28
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 TEMP 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 TEMP 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 TEMP 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 TEMP 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 (18, 9, 10, 1)
ok 49 - INSERT INTO PREC VALUES (19, 11, 3, 1)
ok 50 - INSERT INTO PREC VALUES (20, 11, 4, 2)
ok 51 - INSERT INTO PREC VALUES (21, 12, 4, 1)
ok 52 - INSERT INTO PREC VALUES (22, 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 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" (SELECT)
ok 81 - 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
ok 82 - $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 83 - 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 84 - $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 85 - 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 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
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..20
ok 1 - POD test for blib/lib/SQL/Statement.pm
ok 2 - POD test for blib/lib/SQL/Parser.pm
ok 3 - POD test for blib/lib/SQL/Eval.pm
ok 4 - POD test for blib/lib/SQL/Statement/Embed.pod
ok 5 - POD test for blib/lib/SQL/Statement/Util.pm
ok 6 - POD test for blib/lib/SQL/Statement/TermFactory.pm
ok 7 - POD test for blib/lib/SQL/Statement/Syntax.pod
ok 8 - POD test for blib/lib/SQL/Statement/GetInfo.pm
ok 9 - POD test for blib/lib/SQL/Statement/RAM.pm
ok 10 - POD test for blib/lib/SQL/Statement/Roadmap.pod
ok 11 - POD test for blib/lib/SQL/Statement/Operation.pm
ok 12 - POD test for blib/lib/SQL/Statement/Functions.pm
ok 13 - POD test for blib/lib/SQL/Statement/Structure.pod
ok 14 - POD test for blib/lib/SQL/Statement/Term.pm
ok 15 - POD test for blib/lib/SQL/Statement/Placeholder.pm
ok 16 - POD test for blib/lib/SQL/Statement/Function.pm
ok 17 - POD test for blib/lib/SQL/Dialects/Role.pm
ok 18 - POD test for blib/lib/SQL/Dialects/ANSI.pm
ok 19 - POD test for blib/lib/SQL/Dialects/AnyData.pm
ok 20 - POD test for blib/lib/SQL/Dialects/CSV.pm
ok
t/21pod_coverage.t ...
1..16
ok 1 - Pod coverage on SQL::Statement
ok 2 - Pod coverage on SQL::Parser
ok 3 - Pod coverage on SQL::Eval
ok 4 - Pod coverage on SQL::Statement::Util
ok 5 - Pod coverage on SQL::Statement::TermFactory
ok 6 - Pod coverage on SQL::Statement::GetInfo
ok 7 - Pod coverage on SQL::Statement::RAM
ok 8 - Pod coverage on SQL::Statement::Operation
ok 9 - Pod coverage on SQL::Statement::Functions
ok 10 - Pod coverage on SQL::Statement::Term
ok 11 - Pod coverage on SQL::Statement::Placeholder
ok 12 - Pod coverage on SQL::Statement::Function
ok 13 - Pod coverage on SQL::Dialects::Role
ok 14 - Pod coverage on SQL::Dialects::ANSI
ok 15 - Pod coverage on SQL::Dialects::AnyData
ok 16 - Pod coverage on SQL::Dialects::CSV
ok
t/22calc.t ...........
1..40
ok 1 - use SQL::Statement;
ok 2 - use SQL::Parser;
ok 3 - CREATE TEMP TABLE log (id INT, host CHAR, signature CHAR, message CHAR, time_stamp TIMESTAMP)
ok 4 - INSERT INTO log VALUES (1, 'bert', '/netbsd', 'Copyright (c) 1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005,', 1279451145)
ok 5 - INSERT INTO log VALUES (2, 'bert', '/netbsd', '2006, 2007, 2008, 2009', 1279451145)
ok 6 - INSERT INTO log VALUES (3, 'bert', '/netbsd', 'The NetBSD Foundation, Inc. All rights reserved.', 1279451145)
ok 7 - INSERT INTO log VALUES (4, 'bert', '/netbsd', 'Copyright (c) 1982, 1986, 1989, 1991, 1993', 1279451145)
ok 8 - INSERT INTO log VALUES (5, 'bert', '/netbsd', 'The Regents of the University of California. All rights reserved.', 1279451145)
ok 9 - INSERT INTO log VALUES (6, 'bert', '/netbsd', '', 1279451145)
ok 10 - INSERT INTO log VALUES (7, 'bert', '/netbsd', 'NetBSD 5.99.21 (BERT) \#0: Mon Nov 30 08:16:07 CET 2009', 1279451145)
ok 11 - INSERT INTO log VALUES (8, 'ernie', 'rpc.statd', 'starting', 1279447545)
ok 12 - INSERT INTO log VALUES (9, 'ernie', 'savecore', 'no core dump', 1279443945)
ok 13 - INSERT INTO log VALUES (10, 'ernie', 'postfix/postfix-script', 'starting the Postfix mail system', 1279440345)
ok 14 - INSERT INTO log VALUES (11, 'ernie', 'rpcbind', 'connect from 127.0.0.1 to dump()', 1279436745)
ok 15 - INSERT INTO log VALUES (12, 'ernie', 'sshd', 'last message repeated 2 times', 1279433145)
ok 16 - INSERT INTO log VALUES (13, 'ernie', 'shutdown', 'poweroff by root:', 1279429545)
ok 17 - INSERT INTO log VALUES (14, 'ernie', 'shutdown', 'rebooted by root', 1279425945)
ok 18 - INSERT INTO log VALUES (15, 'ernie', 'sshd', 'Server listening on :: port 22.', 1279422345)
ok 19 - INSERT INTO log VALUES (16, 'ernie', 'sshd', 'Server listening on 0.0.0.0 port 22.', 1279418745)
ok 20 - INSERT INTO log VALUES (17, 'ernie', 'sshd', 'Received SIGHUP; restarting.', 1279415145)
ok 21 - $stmt->execute "SELECT MAX( CHAR_LENGTH(message) ) FROM log" (SELECT)
ok 22 - SELECT MAX( CHAR_LENGTH(message) ) FROM log
ok 23 - $stmt->execute "SELECT MAX(time_stamp - 3*3600) FROM log" (SELECT)
ok 24 - SELECT MAX(time_stamp - 3*3600) FROM log
ok 25 - $stmt->execute "SELECT 1+0 from log" (SELECT)
ok 26 - SELECT 1+0 from log
ok 27 - $stmt->execute "SELECT id,host,signature,message FROM log WHERE time_stamp BETWEEN ( 1279451145 - 5, 1279451145 + 5) ORDER BY id" (SELECT)
ok 28 - SELECT id,host,signature,message FROM log WHERE time_stamp BETWEEN ( 1279451145 - 5, 1279451145 + 5) ORDER BY id
ok 29 - $stmt->execute "SELECT id,host,signature,message FROM log WHERE time_stamp < (1279451145 - ( 4 * 60 )) ORDER BY id" (SELECT)
ok 30 - SELECT id,host,signature,message FROM log WHERE time_stamp < (1279451145 - ( 4 * 60 )) ORDER BY id
ok 31 - $stmt->execute "SELECT 1+1*2" (SELECT)
ok 32 - SELECT 1+1*2
ok 33 - $stmt->execute "SELECT id,host,signature,message FROM log WHERE (time_stamp > (1279451145 - 5)) AND (time_stamp < (1279451145 + 5)) ORDER BY id" (SELECT)
ok 34 - SELECT id,host,signature,message FROM log WHERE (time_stamp > (1279451145 - 5)) AND (time_stamp < (1279451145 + 5)) ORDER BY id
ok 35 - $stmt->execute "SELECT MAX(time_stamp) FROM log WHERE time_stamp IN ( 1279451145 - (2*3600), 1279451145 - (4*3600))" (SELECT)
ok 36 - SELECT MAX(time_stamp) FROM log WHERE time_stamp IN ( 1279451145 - (2*3600), 1279451145 - (4*3600))
ok 37 - $stmt->execute "SELECT 1" (SELECT)
ok 38 - SELECT 1
ok 39 - $stmt->execute "SELECT MAX(time_stamp) - 3*3600 FROM log" (n/a) # TODO Known limitation. Parser/Engine can not handle properly
not ok 40 - SELECT MAX(time_stamp) - 3*3600 FROM log # TODO Known limitation. Parser/Engine can not handle properly
# Failed (TODO) test 'SELECT MAX(time_stamp) - 3*3600 FROM log'
# at t/22calc.t line 128.
# got: ''
# expected: '1279440345'
ok
t/23dialects.t .......
1..2
ok 1
ok 2
ok
All tests successful.
Test Summary Report
-------------------
t/16morejoins.t (Wstat: 0 Tests: 48 Failed: 0)
TODO passed: 42-43, 46-47
t/22calc.t (Wstat: 0 Tests: 40 Failed: 0)
TODO passed: 39
Files=24, Tests=584, 4 wallclock secs ( 0.14 usr 0.01 sys + 4.31 cusr 0.10 csys = 4.56 CPU)
Result: PASS
REHSACK/SQL-Statement-1.28.tar.gz
make test TEST_VERBOSE=1 -- OK
Jens Rehsack <rehsack@cpan.org>
SQL parsing and processing engine
>>> (cd /home/fly818/var/cpan/build/SQL-Statement-1.28-lVao1D && tar cvf - SQL-Statement-1.28.ppd blib) | gzip -c >/home/fly818/var/REPO/R/RE/REHSACK/SQL-Statement-1.28.tar.gz
SQL-Statement-1.28.ppd
blib/
blib/lib/
blib/lib/SQL/
blib/lib/SQL/Statement/
blib/lib/SQL/Statement/Embed.pod
blib/lib/SQL/Statement/Util.pm
blib/lib/SQL/Statement/TermFactory.pm
blib/lib/SQL/Statement/Syntax.pod
blib/lib/SQL/Statement/GetInfo.pm
blib/lib/SQL/Statement/RAM.pm
blib/lib/SQL/Statement/Roadmap.pod
blib/lib/SQL/Statement/Operation.pm
blib/lib/SQL/Statement/Functions.pm
blib/lib/SQL/Statement/Structure.pod
blib/lib/SQL/Statement/Term.pm
blib/lib/SQL/Statement/Placeholder.pm
blib/lib/SQL/Statement/Function.pm
blib/lib/SQL/Statement.pm
blib/lib/SQL/Parser.pm
blib/lib/SQL/Dialects/
blib/lib/SQL/Dialects/Role.pm
blib/lib/SQL/Dialects/ANSI.pm
blib/lib/SQL/Dialects/AnyData.pm
blib/lib/SQL/Dialects/CSV.pm
blib/lib/SQL/Eval.pm
blib/man3/
blib/man3/SQL::Parser.3
blib/man3/SQL::Eval.3
blib/man3/SQL::Statement::Operation.3
blib/man3/SQL::Statement::RAM.3
blib/man3/SQL::Statement::Syntax.3
blib/man3/SQL::Statement::Function.3
blib/man3/SQL::Statement::TermFactory.3
blib/man3/SQL::Statement::Roadmap.3
blib/man3/SQL::Statement::Functions.3
blib/man3/SQL::Statement::Embed.3
blib/man3/SQL::Statement::GetInfo.3
blib/man3/SQL::Statement::Structure.3
blib/man3/SQL::Dialects::CSV.3
blib/man3/SQL::Dialects::ANSI.3
blib/man3/SQL::Statement.3
blib/man3/SQL::Dialects::AnyData.3
blib/man3/SQL::Dialects::Role.3
blib/man3/SQL::Statement::Placeholder.3
blib/man3/SQL::Statement::Term.3
blib/man3/SQL::Statement::Util.3
>>> mv /home/fly818/var/cpan/build/SQL-Statement-1.28-lVao1D/SQL-Statement-1.28.ppd /home/fly818/var/REPO/R/RE/REHSACK
Running make for R/RE/REHSACK/DBD-AnyData-0.110.tar.gz
Prepending /home/fly818/var/cpan/build/SQL-Statement-1.28-lVao1D/blib/arch /home/fly818/var/cpan/build/SQL-Statement-1.28-lVao1D/blib/lib to PERL5LIB for 'get'
Has already been unwrapped into directory /home/fly818/var/cpan/build/DBD-AnyData-0.110-00GPtv
Prepending /home/fly818/var/cpan/build/SQL-Statement-1.28-lVao1D/blib/arch /home/fly818/var/cpan/build/SQL-Statement-1.28-lVao1D/blib/lib to PERL5LIB for 'make'
CPAN.pm: Going to build R/RE/REHSACK/DBD-AnyData-0.110.tar.gz
>>> make
cp lib/DBD/AnyData.pm blib/lib/DBD/AnyData.pm
Manifying blib/man3/DBD::AnyData.3
REHSACK/DBD-AnyData-0.110.tar.gz
make -- OK
Prepending /home/fly818/var/cpan/build/SQL-Statement-1.28-lVao1D/blib/arch /home/fly818/var/cpan/build/SQL-Statement-1.28-lVao1D/blib/lib to PERL5LIB for 'test'
Running make test
>>> make test TEST_VERBOSE=1
PERL_DL_NONLAZY=1 /home/fly818/ap818/bin/perl-static "-MExtUtils::Command::MM" "-e" "test_harness(1, 'blib/lib', 'blib/arch')" t/*.t
# Testing DBD::AnyData 0.110, Perl 5.008008, /home/fly818/ap818/bin/perl-static
t/00-load.t ...
1..1
ok 1 - use DBD::AnyData;
ok
t/01-basic.t ..
ok 1 - use DBI;
ok 2 - use DBD::AnyData;
# DBD::AnyData
# CSV ...
ok 3 - connect
ok 4 - CREATE test_CSV
ok 5 - INSERT 1. row into test_CSV
ok 6 - INSERT 2. row into test_CSV
ok 7 - INSERT 3. row into test_CSV
ok 8 - UPDATE test_CSV
ok 9 - DELETE FROM test_CSV
ok 10 - Single select
ok 11 - Multiple select
ok 12 - Names
ok 13 - rows
ok 14 - ad_convert
# Pipe ...
ok 15 - connect
ok 16 - CREATE test_Pipe
ok 17 - INSERT 1. row into test_Pipe
ok 18 - INSERT 2. row into test_Pipe
ok 19 - INSERT 3. row into test_Pipe
ok 20 - UPDATE test_Pipe
ok 21 - DELETE FROM test_Pipe
ok 22 - Single select
ok 23 - Multiple select
ok 24 - Names
ok 25 - rows
ok 26 - ad_convert
# Tab ...
ok 27 - connect
ok 28 - CREATE test_Tab
ok 29 - INSERT 1. row into test_Tab
ok 30 - INSERT 2. row into test_Tab
ok 31 - INSERT 3. row into test_Tab
ok 32 - UPDATE test_Tab
ok 33 - DELETE FROM test_Tab
ok 34 - Single select
ok 35 - Multiple select
ok 36 - Names
ok 37 - rows
ok 38 - ad_convert
# Fixed ...
ok 39 - connect
ok 40 - CREATE test_Fixed
ok 41 - INSERT 1. row into test_Fixed
ok 42 - INSERT 2. row into test_Fixed
ok 43 - INSERT 3. row into test_Fixed
ok 44 - UPDATE test_Fixed
ok 45 - DELETE FROM test_Fixed
ok 46 - Single select
ok 47 - Multiple select
ok 48 - Names
ok 49 - rows
ok 50 - ad_convert
# Paragraph ...
ok 51 - connect
ok 52 - CREATE test_Paragraph
ok 53 - INSERT 1. row into test_Paragraph
ok 54 - INSERT 2. row into test_Paragraph
ok 55 - INSERT 3. row into test_Paragraph
ok 56 - UPDATE test_Paragraph
ok 57 - DELETE FROM test_Paragraph
ok 58 - Single select
ok 59 - Multiple select
ok 60 - Names
ok 61 - rows
ok 62 - ad_convert
# ARRAY ...
ok 63 - connect
ok 64 - CREATE test_ARRAY
ok 65 - INSERT 1. row into test_ARRAY
ok 66 - INSERT 2. row into test_ARRAY
ok 67 - INSERT 3. row into test_ARRAY
ok 68 - UPDATE test_ARRAY
ok 69 - DELETE FROM test_ARRAY
ok 70 - Single select
ok 71 - Multiple select
ok 72 - Names
ok 73 - rows
1..73
ok
t/manifest.t .. skipped: Author tests not required for installation
t/pod.t .......
1..1
ok 1 - POD test for blib/lib/DBD/AnyData.pm
ok
All tests successful.
Files=4, Tests=75, 1 wallclock secs ( 0.04 usr 0.00 sys + 0.36 cusr 0.03 csys = 0.43 CPU)
Result: PASS
REHSACK/DBD-AnyData-0.110.tar.gz
make test TEST_VERBOSE=1 -- OK
Jens Rehsack <rehsack@cpan.org>
DBI access to XML, CSV and other formats
>>> (cd /home/fly818/var/cpan/build/DBD-AnyData-0.110-00GPtv && tar cvf - DBD-AnyData-0.110.ppd blib) | gzip -c >/home/fly818/var/REPO/R/RE/REHSACK/DBD-AnyData-0.110.tar.gz
DBD-AnyData-0.110.ppd
blib/
blib/lib/
blib/lib/DBD/
blib/lib/DBD/AnyData.pm
blib/man3/
blib/man3/DBD::AnyData.3
>>> mv /home/fly818/var/cpan/build/DBD-AnyData-0.110-00GPtv/DBD-AnyData-0.110.ppd /home/fly818/var/REPO/R/RE/REHSACK
Finished 2010-07-18T04:05:48