PATH=/usr/bin:/bin:/Users/fly1800/var/megalib/bin
Start 2013-07-14T10:01:54
ActivePerl-1800 CPAN-2.00
Reading '/Users/fly1800/var/cpan/Metadata'
  Database was generated on Sun, 14 Jul 2013 12:53:02 GMT
Running make for A/AD/ADRIANWIT/SQL-Entity-0.05.tar.gz
Checksum for /net/nas/data/cpan/authors/id/A/AD/ADRIANWIT/SQL-Entity-0.05.tar.gz ok
SQL-Entity-0.05/
SQL-Entity-0.05/META.yml
SQL-Entity-0.05/examples/
SQL-Entity-0.05/examples/entity.pl
SQL-Entity-0.05/t/
SQL-Entity-0.05/t/entity/
SQL-Entity-0.05/t/entity/column.t
SQL-Entity-0.05/t/entity/table.t
SQL-Entity-0.05/t/entity/index.t
SQL-Entity-0.05/t/entity/condition.t
SQL-Entity-0.05/t/entity/to_many.t
SQL-Entity-0.05/t/entity/lob.t
SQL-Entity-0.05/t/pod_coverage.t
SQL-Entity-0.05/t/pod.t
SQL-Entity-0.05/t/query.t
SQL-Entity-0.05/t/entity.t
SQL-Entity-0.05/lib/
SQL-Entity-0.05/lib/SQL/
SQL-Entity-0.05/lib/SQL/Query/
SQL-Entity-0.05/lib/SQL/Query/Limit/
SQL-Entity-0.05/lib/SQL/Query/Limit/PostgreSQL.pm
SQL-Entity-0.05/lib/SQL/Query/Limit/Oracle.pm
SQL-Entity-0.05/lib/SQL/Query/Limit/MySQL.pm
SQL-Entity-0.05/lib/SQL/Query.pm
SQL-Entity-0.05/lib/SQL/Entity.pm
SQL-Entity-0.05/lib/SQL/Entity/
SQL-Entity-0.05/lib/SQL/Entity/Column.pm
SQL-Entity-0.05/lib/SQL/Entity/Relationship.pm
SQL-Entity-0.05/lib/SQL/Entity/Column/
SQL-Entity-0.05/lib/SQL/Entity/Column/LOB.pm
SQL-Entity-0.05/lib/SQL/Entity/Index.pm
SQL-Entity-0.05/lib/SQL/Entity/Table.pm
SQL-Entity-0.05/lib/SQL/Entity/Condition.pm
SQL-Entity-0.05/lib/SQL/DMLGenerator.pm
SQL-Entity-0.05/README
SQL-Entity-0.05/Makefile.PL
SQL-Entity-0.05/Changes
SQL-Entity-0.05/MANIFEST

  CPAN.pm: Building A/AD/ADRIANWIT/SQL-Entity-0.05.tar.gz

>>> /Users/fly1800/ap1800-297214/bin/perl-dynamic Makefile.PL
Checking if your kit is complete...
Looks good
Writing Makefile for SQL::Entity
Writing MYMETA.yml and MYMETA.json
>>> make
cp lib/SQL/Query/Limit/MySQL.pm blib/lib/SQL/Query/Limit/MySQL.pm
cp lib/SQL/Query.pm blib/lib/SQL/Query.pm
cp lib/SQL/Entity/Condition.pm blib/lib/SQL/Entity/Condition.pm
cp lib/SQL/Entity/Column.pm blib/lib/SQL/Entity/Column.pm
cp lib/SQL/Entity/Table.pm blib/lib/SQL/Entity/Table.pm
cp lib/SQL/Query/Limit/PostgreSQL.pm blib/lib/SQL/Query/Limit/PostgreSQL.pm
cp lib/SQL/Entity/Column/LOB.pm blib/lib/SQL/Entity/Column/LOB.pm
cp lib/SQL/Entity/Relationship.pm blib/lib/SQL/Entity/Relationship.pm
cp lib/SQL/Entity/Index.pm blib/lib/SQL/Entity/Index.pm
cp lib/SQL/Entity.pm blib/lib/SQL/Entity.pm
cp lib/SQL/Query/Limit/Oracle.pm blib/lib/SQL/Query/Limit/Oracle.pm
cp lib/SQL/DMLGenerator.pm blib/lib/SQL/DMLGenerator.pm
Manifying blib/man3/SQL::Query::Limit::MySQL.3
Manifying blib/man3/SQL::Entity::Relationship.3
Manifying blib/man3/SQL::Entity::Index.3
Manifying blib/man3/SQL::Query.3
Manifying blib/man3/SQL::Query::Limit::Oracle.3
Manifying blib/man3/SQL::Entity::Table.3
Manifying blib/man3/SQL::DMLGenerator.3
Manifying blib/man3/SQL::Entity.3
Manifying blib/man3/SQL::Entity::Column::LOB.3
Manifying blib/man3/SQL::Entity::Column.3
Manifying blib/man3/SQL::Entity::Condition.3
Manifying blib/man3/SQL::Query::Limit::PostgreSQL.3
  ADRIANWIT/SQL-Entity-0.05.tar.gz
  make -- OK
Running make test
>>> make test TEST_VERBOSE=1
PERL_DL_NONLAZY=1 /Users/fly1800/ap1800-297214/bin/perl-dynamic "-MExtUtils::Command::MM" "-e" "test_harness(1, 'blib/lib', 'blib/arch')" t/*.t t/entity/*.t

#   Failed test 'should strigify Entity'
#   at t/entity.t line 47.
#          got: 'SELECT emp.rowid AS the_rowid,
#   emp.empno,
#   emp.deptno,
#   emp.ename
# FROM emp'
#     expected: 'SELECT emp.rowid AS the_rowid,
#   emp.deptno,
#   emp.ename,
#   emp.empno
# FROM emp'

#   Failed test 'should strigify Entity'
#   at t/entity.t line 73.
#          got: 'SELECT emp.rowid AS the_rowid,
#   (SELECT d.dname
# FROM dept d
# WHERE d.deptno = emp.deptno) AS dname,
#   emp.empno,
#   emp.deptno,
#   emp.ename
# FROM emp'
#     expected: 'SELECT emp.rowid AS the_rowid,
#   (SELECT d.dname
# FROM dept d
# WHERE d.deptno = emp.deptno) AS dname,
#   emp.deptno,
#   emp.ename,
#   emp.empno
# FROM emp'

#   Failed test 'should have query with where (case insensitive) clause'
#   at t/entity.t line 90.
#          got: 'SELECT emp.rowid AS the_rowid,
#   d.dname,
#   emp.empno,
#   emp.deptno,
#   emp.ename
# FROM emp
# JOIN dept d ON (d.deptno = emp.deptno)
# WHERE emp.empno > ? AND d.dname NOT LIKE ?'
#     expected: 'SELECT emp.rowid AS the_rowid,
#   d.dname,
#   emp.deptno,
#   emp.ename,
#   emp.empno
# FROM emp
# JOIN dept d ON (d.deptno = emp.deptno)
# WHERE emp.empno > ? AND d.dname NOT LIKE ?'

#   Failed test 'should have query from transformed'
#   at t/entity.t line 220.
#          got: 'SELECT d.deptno AS the_rowid,
#   d.deptno,
#   d.dname
# FROM ( SELECT * FROM dept ) d'
#     expected: 'SELECT d.deptno AS the_rowid,
#   d.dname,
#   d.deptno
# FROM ( SELECT * FROM dept ) d'
# Looks like you failed 4 tests of 30.
t/entity.t ............ 
1..30
ok 1 - use SQL::Entity::Relationship;
ok 2 - use SQL::Entity;
ok 3 - use SQL::Entity::Table;
ok 4 - The object isa SQL::Entity
ok 5 - The object isa SQL::Entity
not ok 6 - should strigify Entity
ok 7 - The object isa SQL::Entity
ok 8 - The object isa SQL::Entity
not ok 9 - should strigify Entity
ok 10 - should have bind variables
not ok 11 - should have query with where (case insensitive) clause
ok 12 - should have count Entity
ok 13 - should have insert sql
ok 14 - should have bind variables
ok 15 - should have insert sql
ok 16 - should have bind variables
ok 17 - should have update sql
ok 18 - should have bind variables
ok 19 - should have delete sql
ok 20 - should have bind variables
ok 21 - should have update sql
ok 22 - should have bind variables
ok 23 - should have delete sql
ok 24 - should have bind variables
ok 25 - should have unique_condition_values for unique column
ok 26 - should have unique_condition_values for pk column
ok 27 - should have unique_condition_values for the_rowid
ok 28 - should have unique_condition_values for rowid
ok 29 - should catch unique_condition_values validation error
not ok 30 - should have query from transformed
Dubious, test returned 4 (wstat 1024, 0x400)
Failed 4/30 subtests 
t/entity/column.t ..... 
1..6
ok 1 - use SQL::Entity::Column;
ok 2 - The object isa SQL::Entity::Column
ok 3 - should strigify column
ok 4 - The object isa SQL::Entity::Column
ok 5 - should not be updatable
ok 6 - should stingyfy column
ok
t/entity/condition.t .. 
1..16
ok 1 - use SQL::Entity::Condition;
ok 2 - simple AND condition
ok 3 - simple AND condition
ok 4 - simple OR condition
ok 5 - The object isa SQL::Entity::Condition
ok 6 - simple condition
ok 7 - composite AND condition
ok 8 - composite AND and OR condition
ok 9 - composite OR condition
ok 10 - composite OR and AND condition
ok 11 - should have condition from data structure
ok 12 - should have condition from data structure
ok 13 - should have condition from data structure
ok 14 - should have condition from data structure
ok 15 -  should have in condition
ok 16 - should have bind variables
ok

#   Failed test 'should have order by clause'
#   at t/entity/index.t line 34.
#          got: 'SELECT emp.rowid AS the_rowid,
#   emp.ename,
#   emp.empno,
#   emp.deptno
# FROM emp ORDER BY ename'
#     expected: 'SELECT emp.rowid AS the_rowid,
#   emp.deptno,
#   emp.ename,
#   emp.empno
# FROM emp ORDER BY ename'

#   Failed test 'should have hint'
#   at t/entity/index.t line 46.
#          got: 'SELECT emp.*
# FROM (
# SELECT /*+ INDEX_ASC(emp idx_emp_ename) */ ROWNUM AS the_rownum,
#   emp.rowid AS the_rowid,
#   emp.deptno,
#   emp.empno,
#   emp.ename
# FROM emp
# WHERE ROWNUM < ?) emp
# WHERE the_rownum >= ?'
#     expected: 'SELECT emp.*
# FROM (
# SELECT /*+ INDEX_ASC(emp idx_emp_ename) */ ROWNUM AS the_rownum,
#   emp.rowid AS the_rowid,
#   emp.deptno,
#   emp.ename,
#   emp.empno
# FROM emp
# WHERE ROWNUM < ?) emp
# WHERE the_rownum >= ?'

#   Failed test 'should have order by - missing hint'
#   at t/entity/index.t line 60.
#          got: 'SELECT emp.*
# FROM (
# SELECT ROWNUM AS the_rownum,
#   emp.rowid AS the_rowid,
#   emp.deptno,
#   emp.empno,
#   emp.ename
# FROM emp
# WHERE ROWNUM < ? ORDER BY empno) emp
# WHERE the_rownum >= ?'
#     expected: 'SELECT emp.*
# FROM (
# SELECT ROWNUM AS the_rownum,
#   emp.rowid AS the_rowid,
#   emp.deptno,
#   emp.ename,
#   emp.empno
# FROM emp
# WHERE ROWNUM < ? ORDER BY empno) emp
# WHERE the_rownum >= ?'
# Looks like you failed 3 tests of 9.
t/entity/index.t ...... 
1..9
ok 1 - use SQL::Entity::Column;
ok 2 - use SQL::Entity::Condition;
ok 3 - use SQL::Entity;
ok 4 - use SQL::Query;
ok 5 - use SQL::Entity::Index;
not ok 6 - should have order by clause
ok 7 - The object isa SQL::Query
not ok 8 - should have hint
not ok 9 - should have order by - missing hint
Dubious, test returned 3 (wstat 768, 0x300)
Failed 3/9 subtests 
t/entity/lob.t ........ 
1..5
ok 1 - use SQL::Entity::Column::LOB;
ok 2 - The object isa SQL::Entity::Column::LOB
ok 3 - should strigify lob column
ok 4 - The object isa SQL::Entity::Column::LOB
ok 5 - should have lob
ok
t/entity/table.t ...... 
1..7
ok 1 - use SQL::Entity::Column;
ok 2 - use SQL::Entity::Table;
ok 3 - The object isa SQL::Entity::Table
ok 4 - should stringify table Entity
ok 5 - should have count Entity
ok 6 - should retrieve insertable_columns
ok 7 - should retrieve updatable_columns
ok

#   Failed test 'should strigify'
#   at t/entity/to_many.t line 69.
#          got: 'SELECT emp.rowid AS the_rowid,
#   emp.ename,
#   emp.empno,
#   emp.deptno
# FROM emp
# WHERE EXISTS (SELECT 1 FROM dept d WHERE d.deptno = emp.deptno AND d.deptno = ?)'
#     expected: 'SELECT emp.rowid AS the_rowid,
#   emp.deptno,
#   emp.ename,
#   emp.empno
# FROM emp
# WHERE EXISTS (SELECT 1 FROM dept d WHERE d.deptno = emp.deptno AND d.deptno = ?)'
# Looks like you failed 1 test of 8.
t/entity/to_many.t .... 
1..8
ok 1 - use SQL::Entity::Relationship;
ok 2 - The object isa SQL::Entity::Relationship
ok 3 - should have reflective to one relation
ok 4 - should have columns
ok 5 - should have target entity
not ok 6 - should strigify
ok 7 - should catch unknown foreign key column error
ok 8 - should catch unknown primary key column error
Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/8 subtests 
t/pod.t ............... 
1..12
ok 1 - should have value lib/SQL/Entity.pm POD file
ok 2 - should have value lib/SQL/Entity/Column.pm POD file
ok 3 - should have value lib/SQL/Entity/Column/LOB.pm POD file
ok 4 - should have value lib/SQL/Entity/Condition.pm POD file
ok 5 - should have value lib/SQL/Entity/Index.pm POD file
ok 6 - should have value lib/SQL/Entity/Relationship.pm POD file
ok 7 - should have value lib/SQL/Entity/Table.pm POD file
ok 8 - should have value lib/SQL/Query.pm POD file
ok 9 - should have value lib/SQL/Query/Limit/MySQL.pm POD file
ok 10 - should have value lib/SQL/Query/Limit/Oracle.pm POD file
ok 11 - should have value lib/SQL/Query/Limit/PostgreSQL.pm POD file
ok 12 - should have value lib/SQL/DMLGenerator.pm POD file
ok
t/pod_coverage.t ...... 
1..12
ok 1 - should have value SQL::Entity POD file
ok 2 - should have value SQL::Entity::Column POD file
ok 3 - should have value SQL::Entity::Column::LOB POD file
ok 4 - should have value SQL::Entity::Condition POD file
ok 5 - should have value SQL::Entity::Index POD file
ok 6 - should have value SQL::Entity::Relationship POD file
ok 7 - should have value SQL::Entity::Table POD file
ok 8 - should have value SQL::Query POD file
ok 9 - should have value SQL::Query::Limit::MySQL POD file
ok 10 - should have value SQL::Query::Limit::Oracle POD file
ok 11 - should have value SQL::Query::Limit::PostgreSQL POD file
ok 12 - should have value SQL::DMLGenerator POD file
ok

#   Failed test 'should have Oracle navigation sql'
#   at t/query.t line 29.
#          got: 'SELECT emp.*
# FROM (
# SELECT ROWNUM AS the_rownum,
#   emp.rowid AS the_rowid,
#   emp.deptno,
#   emp.empno,
#   emp.ename
# FROM emp
# WHERE ROWNUM < ?) emp
# WHERE the_rownum >= ?'
#     expected: 'SELECT emp.*
# FROM (
# SELECT ROWNUM AS the_rownum,
#   emp.rowid AS the_rowid,
#   emp.deptno,
#   emp.ename,
#   emp.empno
# FROM emp
# WHERE ROWNUM < ?) emp
# WHERE the_rownum >= ?'

#   Failed test 'should have PostgreSQL navigation sql'
#   at t/query.t line 58.
#          got: 'SELECT emp.*,nextval('rownum') AS the_rownum
# FROM (
# SELECT emp.oid AS the_rowid,
#   emp.ename,
#   emp.empno,
#   emp.deptno
# FROM emp) emp
# LIMIT ? OFFSET ?'
#     expected: 'SELECT emp.*,nextval('rownum') AS the_rownum
# FROM (
# SELECT emp.oid AS the_rowid,
#   emp.deptno,
#   emp.ename,
#   emp.empno
# FROM emp) emp
# LIMIT ? OFFSET ?'

#   Failed test 'should have MYSQL navigation sql'
#   at t/query.t line 83.
#          got: 'SELECT emp.*,@rownum = @rownum + 1 AS the_rownum
# FROM (
# SELECT emp.oid AS the_rowid,
#   emp.ename,
#   emp.empno,
#   emp.deptno
# FROM emp) emp
# LIMIT ? OFFSET ?'
#     expected: 'SELECT emp.*,@rownum = @rownum + 1 AS the_rownum
# FROM (
# SELECT emp.oid AS the_rowid,
#   emp.deptno,
#   emp.ename,
#   emp.empno
# FROM emp) emp
# LIMIT ? OFFSET ?'

#   Failed test 'should parse sql template parameters'
#   at t/query.t line 113.
#          got: 'SELECT emp.*
# FROM (
# SELECT ROWNUM AS the_rownum,
#   emp.rowid AS the_rowid,
#   (CASE WHEN ename like 'my param1' THEN 1 ELSE NULL END) AS match,
#   emp.ename,
#   emp.empno,
#   emp.deptno
# FROM emp
# WHERE ROWNUM < ?) emp
# WHERE the_rownum >= ?'
#     expected: 'SELECT emp.*
# FROM (
# SELECT ROWNUM AS the_rownum,
#   emp.rowid AS the_rowid,
#   (CASE WHEN ename like 'my param1' THEN 1 ELSE NULL END) AS match,
#   emp.deptno,
#   emp.ename,
#   emp.empno
# FROM emp
# WHERE ROWNUM < ?) emp
# WHERE the_rownum >= ?'
# Looks like you failed 4 tests of 11.
t/query.t ............. 
1..11
ok 1 - use SQL::Query;
ok 2 - use SQL::Entity;
ok 3 - use SQL::Entity::Column;
ok 4 - The object isa SQL::Query
not ok 5 - should have Oracle navigation sql
ok 6 - should have bind variables
ok 7 - The object isa SQL::Query
not ok 8 - should have PostgreSQL navigation sql
ok 9 - The object isa SQL::Query
not ok 10 - should have MYSQL navigation sql
not ok 11 - should parse sql template parameters
Dubious, test returned 4 (wstat 1024, 0x400)
Failed 4/11 subtests 

Test Summary Report
-------------------
t/entity.t          (Wstat: 1024 Tests: 30 Failed: 4)
  Failed tests:  6, 9, 11, 30
  Non-zero exit status: 4
t/entity/index.t    (Wstat: 768 Tests: 9 Failed: 3)
  Failed tests:  6, 8-9
  Non-zero exit status: 3
t/entity/to_many.t  (Wstat: 256 Tests: 8 Failed: 1)
  Failed test:  6
  Non-zero exit status: 1
t/query.t           (Wstat: 1024 Tests: 11 Failed: 4)
  Failed tests:  5, 8, 10-11
  Non-zero exit status: 4
Files=10, Tests=116,  2 wallclock secs ( 0.07 usr  0.03 sys +  0.72 cusr  0.10 csys =  0.92 CPU)
Result: FAIL
Failed 4/10 test programs. 12/116 subtests failed.
make: *** [test_dynamic] Error 4
  ADRIANWIT/SQL-Entity-0.05.tar.gz
  make test TEST_VERBOSE=1 -- NOT OK
//hint// to see the cpan-testers results for installing this module, try:
  reports ADRIANWIT/SQL-Entity-0.05.tar.gz
Finished 2013-07-14T10:02:07