PATH=/usr/bin:/bin Start 2011-03-04T06:37:59 ActivePerl-1003 CPAN-1.9402 Going to read '/Users/fly1003/var/cpan/Metadata' Database was generated on Thu, 03 Mar 2011 22:27:29 GMT Running make for N/NO/NOUDARD/DBIx-Class-Result-Validation-0.05.tar.gz Fetching with LWP: http://cpan.nas.activestate.com/authors/id/N/NO/NOUDARD/DBIx-Class-Result-Validation-0.05.tar.gz Checksum for /Users/fly1003/var/cpan/sources/authors/id/N/NO/NOUDARD/DBIx-Class-Result-Validation-0.05.tar.gz ok Will not use Archive::Tar, need 1.00 DBIx-Class-Result-Validation-0.05 DBIx-Class-Result-Validation-0.05/MANIFEST DBIx-Class-Result-Validation-0.05/Changes DBIx-Class-Result-Validation-0.05/META.yml DBIx-Class-Result-Validation-0.05/ignore.txt DBIx-Class-Result-Validation-0.05/README DBIx-Class-Result-Validation-0.05/Build.PL DBIx-Class-Result-Validation-0.05/t DBIx-Class-Result-Validation-0.05/t/pod-coverage.t DBIx-Class-Result-Validation-0.05/t/pod.t DBIx-Class-Result-Validation-0.05/t/02-insert_and_update.t DBIx-Class-Result-Validation-0.05/t/00-load.t DBIx-Class-Result-Validation-0.05/t/manifest.t DBIx-Class-Result-Validation-0.05/t/01-validate.t DBIx-Class-Result-Validation-0.05/t/boilerplate.t DBIx-Class-Result-Validation-0.05/t/app DBIx-Class-Result-Validation-0.05/t/app/Main.pm DBIx-Class-Result-Validation-0.05/t/app/Main DBIx-Class-Result-Validation-0.05/t/app/Main/Result DBIx-Class-Result-Validation-0.05/t/app/Main/Result/Object.pm DBIx-Class-Result-Validation-0.05/t/lib DBIx-Class-Result-Validation-0.05/t/lib/Utils.pm DBIx-Class-Result-Validation-0.05/lib DBIx-Class-Result-Validation-0.05/lib/DBIx DBIx-Class-Result-Validation-0.05/lib/DBIx/Class DBIx-Class-Result-Validation-0.05/lib/DBIx/Class/Result DBIx-Class-Result-Validation-0.05/lib/DBIx/Class/Result/Validation.pm /usr/bin/tar: Read 2560 bytes from - CPAN.pm: Going to build N/NO/NOUDARD/DBIx-Class-Result-Validation-0.05.tar.gz >>> /Users/fly1003/bin/perl Build.PL Checking prerequisites... requires: ! DBIx::Class (0.08115) is installed, but we need version >= 0.08127 ! SQL::Translator (0.10) is installed, but we need version >= 0.11007 ERRORS/WARNINGS FOUND IN PREREQUISITES. You may wish to install the versions of the modules indicated above before proceeding with this installation Creating new 'MYMETA.yml' with configuration results Creating new 'Build' script for 'DBIx-Class-Result-Validation' version '0.05' ---- Unsatisfied dependencies detected during ---- ---- NOUDARD/DBIx-Class-Result-Validation-0.05.tar.gz ---- SQL::Translator [requires] DBIx::Class [requires] Running Build test Delayed until after prerequisites Running test for module 'SQL::Translator' Running make for J/JR/JROBINSON/SQL-Translator-0.11007.tar.gz Checksum for /Users/fly1003/var/cpan/sources/authors/id/J/JR/JROBINSON/SQL-Translator-0.11007.tar.gz ok Will not use Archive::Tar, need 1.00 SQL-Translator-0.11007/ SQL-Translator-0.11007/t/ SQL-Translator-0.11007/t/13schema.t SQL-Translator-0.11007/t/lib/ SQL-Translator-0.11007/t/lib/Producer/ SQL-Translator-0.11007/t/lib/Producer/BaseTest.pm SQL-Translator-0.11007/t/11normalize.t SQL-Translator-0.11007/t/31dumper.t SQL-Translator-0.11007/t/data/ SQL-Translator-0.11007/t/data/xml/ SQL-Translator-0.11007/t/data/xml/samefield.xml SQL-Translator-0.11007/t/data/xml/schema.xml SQL-Translator-0.11007/t/data/diff/ SQL-Translator-0.11007/t/data/diff/pgsql/ SQL-Translator-0.11007/t/data/diff/pgsql/create1.yml SQL-Translator-0.11007/t/data/diff/pgsql/create2.yml SQL-Translator-0.11007/t/data/diff/create1.yml SQL-Translator-0.11007/t/data/diff/create2.yml SQL-Translator-0.11007/t/data/Excel/ SQL-Translator-0.11007/t/data/Excel/t.xls SQL-Translator-0.11007/t/data/mysql/ SQL-Translator-0.11007/t/data/mysql/entire_syntax.sql SQL-Translator-0.11007/t/data/mysql/create.sql SQL-Translator-0.11007/t/data/mysql/BGEP-RE-create.sql SQL-Translator-0.11007/t/data/mysql/Apache-Session-MySQL.sql SQL-Translator-0.11007/t/data/mysql/create2.sql SQL-Translator-0.11007/t/data/mysql/sqlfxml-producer-basic.sql SQL-Translator-0.11007/t/data/pgsql/ SQL-Translator-0.11007/t/data/pgsql/turnkey.sql SQL-Translator-0.11007/t/data/pgsql/Chado-CV-PostGreSQL.sql SQL-Translator-0.11007/t/data/pgsql/entire_syntax.sql SQL-Translator-0.11007/t/data/roundtrip_autogen.yaml SQL-Translator-0.11007/t/data/template/ SQL-Translator-0.11007/t/data/template/table.tt SQL-Translator-0.11007/t/data/template/basic.tt SQL-Translator-0.11007/t/data/access/ SQL-Translator-0.11007/t/data/access/gdpdm.ddl SQL-Translator-0.11007/t/data/sqlserver/ SQL-Translator-0.11007/t/data/sqlserver/create.sql SQL-Translator-0.11007/t/data/roundtrip.xml SQL-Translator-0.11007/t/data/oracle/ SQL-Translator-0.11007/t/data/oracle/schema_diff_a.yaml SQL-Translator-0.11007/t/data/oracle/schema_diff_b.yaml SQL-Translator-0.11007/t/data/oracle/schema_diff_c.yaml SQL-Translator-0.11007/t/data/oracle/create.sql SQL-Translator-0.11007/t/data/oracle/schema_with_options.yaml SQL-Translator-0.11007/t/data/oracle/create2.sql SQL-Translator-0.11007/t/data/sqlite/ SQL-Translator-0.11007/t/data/sqlite/create.sql SQL-Translator-0.11007/t/data/sqlite/create2.sql SQL-Translator-0.11007/t/data/sqlite/named.sql SQL-Translator-0.11007/t/data/sybase/ SQL-Translator-0.11007/t/data/sybase/create.sql SQL-Translator-0.11007/t/05bgep-re.t SQL-Translator-0.11007/t/26sybase.t SQL-Translator-0.11007/t/30sqlt-new-diff.t SQL-Translator-0.11007/t/03mysql-to-oracle.t SQL-Translator-0.11007/t/36-filters.t SQL-Translator-0.11007/t/30sqlt-new-diff-sqlite.t SQL-Translator-0.11007/t/57-class-dbi.t SQL-Translator-0.11007/t/64xml-to-mysql.t SQL-Translator-0.11007/t/09sqlt-diagram.t SQL-Translator-0.11007/t/19sybase-parser.t SQL-Translator-0.11007/t/27sqlite-parser.t SQL-Translator-0.11007/t/53-oracle-delay-constraints.t SQL-Translator-0.11007/t/25storable.t SQL-Translator-0.11007/t/54-oracle-alter-field.t SQL-Translator-0.11007/t/20format_X_name.t SQL-Translator-0.11007/t/37-translator-graph.t SQL-Translator-0.11007/t/24yaml.t SQL-Translator-0.11007/t/08postgres-to-mysql.t SQL-Translator-0.11007/t/32schema-lookups.t SQL-Translator-0.11007/t/55-oracle-add-field.t SQL-Translator-0.11007/t/10excel.t SQL-Translator-0.11007/t/50-sqlserver-parser.t SQL-Translator-0.11007/t/47postgres-producer.t SQL-Translator-0.11007/t/48xml-to-sqlite.t SQL-Translator-0.11007/t/15oracle-parser.t SQL-Translator-0.11007/t/51-xml-to-oracle.t SQL-Translator-0.11007/t/38-mysql-producer.t SQL-Translator-0.11007/t/33tt-table-producer.t SQL-Translator-0.11007/t/07p_args.t SQL-Translator-0.11007/t/61translator_agnostic.t SQL-Translator-0.11007/t/30sqlt-diff.t SQL-Translator-0.11007/t/56-sqlite-producer.t SQL-Translator-0.11007/t/55-oracle-producer.t SQL-Translator-0.11007/t/43xml-to-db2.t SQL-Translator-0.11007/t/14postgres-parser.t SQL-Translator-0.11007/t/02mysql-parser.t SQL-Translator-0.11007/t/16xml-parser.t SQL-Translator-0.11007/t/39-filter-globals.t SQL-Translator-0.11007/t/12header_comment.t SQL-Translator-0.11007/t/18ttschema-producer.t SQL-Translator-0.11007/t/46xml-to-pg.t SQL-Translator-0.11007/t/52-oracle-options.t SQL-Translator-0.11007/t/63-spacial-pgsql.t SQL-Translator-0.11007/t/04file,fh,string.t SQL-Translator-0.11007/t/45db2-producer.t SQL-Translator-0.11007/t/38-filter-names.t SQL-Translator-0.11007/t/30sqlt-new-diff-mysql.t SQL-Translator-0.11007/t/01pod.t SQL-Translator-0.11007/t/60roundtrip.t SQL-Translator-0.11007/t/35-access-parser.t SQL-Translator-0.11007/t/40oracle-parser-dbi.t SQL-Translator-0.11007/t/44-xml-to-db2-array.t SQL-Translator-0.11007/t/06xsv.t SQL-Translator-0.11007/t/51-xml-to-oracle_quoted.t SQL-Translator-0.11007/t/62roundtrip_datacheck.t SQL-Translator-0.11007/t/34tt-base.t SQL-Translator-0.11007/t/53-oracle-delay-constraints_quoted.t SQL-Translator-0.11007/t/17sqlfxml-producer.t SQL-Translator-0.11007/t/29html.t SQL-Translator-0.11007/t/49xml-to-pg-samefield.t SQL-Translator-0.11007/t/30sqlt-new-diff-pgsql.t SQL-Translator-0.11007/inc/ SQL-Translator-0.11007/inc/Module/ SQL-Translator-0.11007/inc/Module/Install/ SQL-Translator-0.11007/inc/Module/Install/Can.pm SQL-Translator-0.11007/inc/Module/Install/Base.pm SQL-Translator-0.11007/inc/Module/Install/Win32.pm SQL-Translator-0.11007/inc/Module/Install/WriteAll.pm SQL-Translator-0.11007/inc/Module/Install/AutoInstall.pm SQL-Translator-0.11007/inc/Module/Install/Makefile.pm SQL-Translator-0.11007/inc/Module/Install/Scripts.pm SQL-Translator-0.11007/inc/Module/Install/Fetch.pm SQL-Translator-0.11007/inc/Module/Install/Share.pm SQL-Translator-0.11007/inc/Module/Install/Include.pm SQL-Translator-0.11007/inc/Module/Install/Metadata.pm SQL-Translator-0.11007/inc/Module/Install.pm SQL-Translator-0.11007/inc/Module/AutoInstall.pm SQL-Translator-0.11007/lib/ SQL-Translator-0.11007/lib/SQL/ SQL-Translator-0.11007/lib/SQL/Translator.pm SQL-Translator-0.11007/lib/SQL/Translator/ SQL-Translator-0.11007/lib/SQL/Translator/Filter/ SQL-Translator-0.11007/lib/SQL/Translator/Filter/DefaultExtra.pm SQL-Translator-0.11007/lib/SQL/Translator/Filter/Globals.pm SQL-Translator-0.11007/lib/SQL/Translator/Filter/Names.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/ SQL-Translator-0.11007/lib/SQL/Translator/Parser/DB2/ SQL-Translator-0.11007/lib/SQL/Translator/Parser/DB2/Grammar.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/DBI/ SQL-Translator-0.11007/lib/SQL/Translator/Parser/DBI/SQLite.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/DBI/MySQL.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/DBI/Sybase.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/DBI/Oracle.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/DBI/PostgreSQL.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/DBI/SQLServer.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/DBI/DB2.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/XML/ SQL-Translator-0.11007/lib/SQL/Translator/Parser/XML/SQLFairy.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/SQLite.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/MySQL.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/XML.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/Sybase.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/Excel.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/Oracle.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/xSV.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/PostgreSQL.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/SQLServer.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/Storable.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/YAML.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/Access.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/DB2.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser/DBI.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/ SQL-Translator-0.11007/lib/SQL/Translator/Schema/Constraint.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/View.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/Graph/ SQL-Translator-0.11007/lib/SQL/Translator/Schema/Graph/Port.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/Graph/Edge.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/Graph/CompoundEdge.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/Graph/HyperEdge.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/Graph/Node.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/Table.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/Object.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/Index.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/Procedure.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/Trigger.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/Graph.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/Field.pm SQL-Translator-0.11007/lib/SQL/Translator/Schema/Constants.pm SQL-Translator-0.11007/lib/SQL/Translator/Diff.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/ SQL-Translator-0.11007/lib/SQL/Translator/Producer/TT/ SQL-Translator-0.11007/lib/SQL/Translator/Producer/TT/Base.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/TT/Table.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/XML/ SQL-Translator-0.11007/lib/SQL/Translator/Producer/XML/SQLFairy.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/ClassDBI.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/Dumper.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/SQLite.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/POD.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/MySQL.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/XML.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/Sybase.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/GraphViz.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/TTSchema.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/Latex.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/Oracle.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/Diagram.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/HTML.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/PostgreSQL.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/DiaUml.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/SQLServer.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/Storable.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/YAML.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer/DB2.pm SQL-Translator-0.11007/lib/SQL/Translator/Producer.pm SQL-Translator-0.11007/lib/SQL/Translator/Utils.pm SQL-Translator-0.11007/lib/SQL/Translator/Parser.pm SQL-Translator-0.11007/lib/SQL/Translator/Manual.pod SQL-Translator-0.11007/lib/SQL/Translator/Schema.pm SQL-Translator-0.11007/lib/Test/ SQL-Translator-0.11007/lib/Test/SQL/ SQL-Translator-0.11007/lib/Test/SQL/Translator.pm SQL-Translator-0.11007/BUGS SQL-Translator-0.11007/LICENSE SQL-Translator-0.11007/share/ SQL-Translator-0.11007/share/DiaUml/ SQL-Translator-0.11007/share/DiaUml/uml-class-start.tt2 SQL-Translator-0.11007/share/DiaUml/uml-class.tt2 SQL-Translator-0.11007/share/DiaUml/diagram.tt2 SQL-Translator-0.11007/share/DiaUml/uml-class-end.tt2 SQL-Translator-0.11007/share/DiaUml/uml-attribute.tt2 SQL-Translator-0.11007/share/DiaUml/layer.tt2 SQL-Translator-0.11007/share/DiaUml/uml-class-all.tt2 SQL-Translator-0.11007/share/DiaUml/schema.tt2 SQL-Translator-0.11007/share/Grammar/ SQL-Translator-0.11007/share/Grammar/DB2.gra SQL-Translator-0.11007/README SQL-Translator-0.11007/Changes SQL-Translator-0.11007/MANIFEST.SKIP SQL-Translator-0.11007/Makefile.PL SQL-Translator-0.11007/META.yml SQL-Translator-0.11007/script/ SQL-Translator-0.11007/script/sqlt SQL-Translator-0.11007/script/sqlt.cgi SQL-Translator-0.11007/script/sqlt-dumper SQL-Translator-0.11007/script/sqlt-diff SQL-Translator-0.11007/script/sqlt-diagram SQL-Translator-0.11007/script/sqlt-graph SQL-Translator-0.11007/script/sqlt-diff-old SQL-Translator-0.11007/AUTHORS SQL-Translator-0.11007/MANIFEST CPAN.pm: Going to build J/JR/JROBINSON/SQL-Translator-0.11007.tar.gz >>> /Users/fly1003/bin/perl Makefile.PL *** Module::AutoInstall version 1.03 *** Checking for Perl dependencies... *** Since we're running under CPAN, I'll just let it take care of the dependency's installation later. [Core Features] - Test::More ...loaded. (0.98 >= 0.6) - Test::Exception ...loaded. (0.31) - Test::Differences ...loaded. (0.5) - YAML ...loaded. (0.72 >= 0.66) - File::Basename ...loaded. (2.76) - ExtUtils::MakeMaker ...loaded. (6.48 >= 6.11) - Scalar::Util ...loaded. (1.23) - IO::Scalar ...loaded. (2.110 >= 2.11) - Class::Base ...loaded. (0.03) - Pod::Usage ...loaded. (1.36) - Digest::SHA1 ...loaded. (2.13 >= 2) - File::Spec ...loaded. (3.33) - Class::Accessor::Fast ...loaded. (0.34) - Parse::RecDescent ...loaded. (1.965001 >= 1.962002) - File::ShareDir ...loaded. (1.03 >= 1) - Class::MakeMethods ...loaded. (1.01) - XML::Writer ...loaded. (0.612 >= 0.5) - Carp::Clan ...loaded. (6.04) - Class::Data::Inheritable ...loaded. (0.08 >= 0.02) - IO::Dir ...loaded. (1.07) - DBI ...loaded. (1.616) *** Module::AutoInstall configuration finished. Checking if your kit is complete... Looks good Writing Makefile for SQL::Translator >>> make cp lib/SQL/Translator/Filter/DefaultExtra.pm blib/lib/SQL/Translator/Filter/DefaultExtra.pm cp lib/SQL/Translator/Parser/Storable.pm blib/lib/SQL/Translator/Parser/Storable.pm cp lib/SQL/Translator.pm blib/lib/SQL/Translator.pm cp lib/SQL/Translator/Parser/Access.pm blib/lib/SQL/Translator/Parser/Access.pm cp lib/SQL/Translator/Parser/DBI/MySQL.pm blib/lib/SQL/Translator/Parser/DBI/MySQL.pm cp lib/SQL/Translator/Parser/DBI/SQLite.pm blib/lib/SQL/Translator/Parser/DBI/SQLite.pm cp lib/SQL/Translator/Producer/Sybase.pm blib/lib/SQL/Translator/Producer/Sybase.pm cp lib/SQL/Translator/Producer/Diagram.pm blib/lib/SQL/Translator/Producer/Diagram.pm cp lib/SQL/Translator/Schema/Table.pm blib/lib/SQL/Translator/Schema/Table.pm cp lib/SQL/Translator/Parser/xSV.pm blib/lib/SQL/Translator/Parser/xSV.pm cp lib/SQL/Translator/Schema/Index.pm blib/lib/SQL/Translator/Schema/Index.pm cp lib/SQL/Translator/Parser/Excel.pm blib/lib/SQL/Translator/Parser/Excel.pm cp lib/SQL/Translator/Producer/GraphViz.pm blib/lib/SQL/Translator/Producer/GraphViz.pm cp lib/SQL/Translator/Manual.pod blib/lib/SQL/Translator/Manual.pod cp lib/SQL/Translator/Parser/DBI/DB2.pm blib/lib/SQL/Translator/Parser/DBI/DB2.pm cp lib/SQL/Translator/Producer/SQLServer.pm blib/lib/SQL/Translator/Producer/SQLServer.pm cp lib/SQL/Translator/Schema/View.pm blib/lib/SQL/Translator/Schema/View.pm cp lib/SQL/Translator/Parser/SQLite.pm blib/lib/SQL/Translator/Parser/SQLite.pm cp lib/SQL/Translator/Parser.pm blib/lib/SQL/Translator/Parser.pm cp lib/SQL/Translator/Producer/XML/SQLFairy.pm blib/lib/SQL/Translator/Producer/XML/SQLFairy.pm cp lib/SQL/Translator/Parser/XML.pm blib/lib/SQL/Translator/Parser/XML.pm cp lib/SQL/Translator/Producer/HTML.pm blib/lib/SQL/Translator/Producer/HTML.pm cp lib/SQL/Translator/Schema/Graph/Edge.pm blib/lib/SQL/Translator/Schema/Graph/Edge.pm cp lib/SQL/Translator/Parser/YAML.pm blib/lib/SQL/Translator/Parser/YAML.pm cp lib/SQL/Translator/Producer/TT/Base.pm blib/lib/SQL/Translator/Producer/TT/Base.pm cp lib/SQL/Translator/Parser/DBI.pm blib/lib/SQL/Translator/Parser/DBI.pm cp lib/SQL/Translator/Schema/Constraint.pm blib/lib/SQL/Translator/Schema/Constraint.pm cp lib/SQL/Translator/Parser/XML/SQLFairy.pm blib/lib/SQL/Translator/Parser/XML/SQLFairy.pm cp lib/SQL/Translator/Producer/TTSchema.pm blib/lib/SQL/Translator/Producer/TTSchema.pm cp lib/SQL/Translator/Schema/Graph/CompoundEdge.pm blib/lib/SQL/Translator/Schema/Graph/CompoundEdge.pm cp lib/SQL/Translator/Schema.pm blib/lib/SQL/Translator/Schema.pm cp lib/SQL/Translator/Producer/TT/Table.pm blib/lib/SQL/Translator/Producer/TT/Table.pm cp lib/SQL/Translator/Producer/Oracle.pm blib/lib/SQL/Translator/Producer/Oracle.pm cp lib/SQL/Translator/Utils.pm blib/lib/SQL/Translator/Utils.pm cp lib/SQL/Translator/Producer/DiaUml.pm blib/lib/SQL/Translator/Producer/DiaUml.pm cp lib/SQL/Translator/Producer/XML.pm blib/lib/SQL/Translator/Producer/XML.pm cp lib/SQL/Translator/Schema/Procedure.pm blib/lib/SQL/Translator/Schema/Procedure.pm cp lib/SQL/Translator/Diff.pm blib/lib/SQL/Translator/Diff.pm cp lib/SQL/Translator/Producer/SQLite.pm blib/lib/SQL/Translator/Producer/SQLite.pm cp lib/SQL/Translator/Parser/PostgreSQL.pm blib/lib/SQL/Translator/Parser/PostgreSQL.pm cp lib/SQL/Translator/Parser/DB2/Grammar.pm blib/lib/SQL/Translator/Parser/DB2/Grammar.pm cp lib/SQL/Translator/Parser/MySQL.pm blib/lib/SQL/Translator/Parser/MySQL.pm cp lib/SQL/Translator/Producer/ClassDBI.pm blib/lib/SQL/Translator/Producer/ClassDBI.pm cp lib/SQL/Translator/Parser/DBI/Oracle.pm blib/lib/SQL/Translator/Parser/DBI/Oracle.pm cp lib/SQL/Translator/Schema/Graph/HyperEdge.pm blib/lib/SQL/Translator/Schema/Graph/HyperEdge.pm cp lib/SQL/Translator/Parser/DBI/SQLServer.pm blib/lib/SQL/Translator/Parser/DBI/SQLServer.pm cp lib/SQL/Translator/Schema/Graph/Port.pm blib/lib/SQL/Translator/Schema/Graph/Port.pm cp lib/SQL/Translator/Parser/DB2.pm blib/lib/SQL/Translator/Parser/DB2.pm cp lib/SQL/Translator/Filter/Globals.pm blib/lib/SQL/Translator/Filter/Globals.pm cp lib/SQL/Translator/Parser/SQLServer.pm blib/lib/SQL/Translator/Parser/SQLServer.pm cp lib/SQL/Translator/Schema/Graph/Node.pm blib/lib/SQL/Translator/Schema/Graph/Node.pm cp lib/SQL/Translator/Parser/Oracle.pm blib/lib/SQL/Translator/Parser/Oracle.pm cp lib/SQL/Translator/Producer/Dumper.pm blib/lib/SQL/Translator/Producer/Dumper.pm cp lib/SQL/Translator/Producer/Latex.pm blib/lib/SQL/Translator/Producer/Latex.pm cp lib/SQL/Translator/Parser/DBI/PostgreSQL.pm blib/lib/SQL/Translator/Parser/DBI/PostgreSQL.pm cp lib/SQL/Translator/Schema/Trigger.pm blib/lib/SQL/Translator/Schema/Trigger.pm cp lib/SQL/Translator/Schema/Field.pm blib/lib/SQL/Translator/Schema/Field.pm cp lib/SQL/Translator/Producer/POD.pm blib/lib/SQL/Translator/Producer/POD.pm cp lib/SQL/Translator/Schema/Graph.pm blib/lib/SQL/Translator/Schema/Graph.pm cp lib/SQL/Translator/Filter/Names.pm blib/lib/SQL/Translator/Filter/Names.pm cp lib/SQL/Translator/Producer/PostgreSQL.pm blib/lib/SQL/Translator/Producer/PostgreSQL.pm cp lib/SQL/Translator/Producer/DB2.pm blib/lib/SQL/Translator/Producer/DB2.pm cp lib/SQL/Translator/Producer/MySQL.pm blib/lib/SQL/Translator/Producer/MySQL.pm cp lib/SQL/Translator/Producer/Storable.pm blib/lib/SQL/Translator/Producer/Storable.pm cp lib/SQL/Translator/Schema/Object.pm blib/lib/SQL/Translator/Schema/Object.pm cp lib/SQL/Translator/Parser/Sybase.pm blib/lib/SQL/Translator/Parser/Sybase.pm cp lib/SQL/Translator/Schema/Constants.pm blib/lib/SQL/Translator/Schema/Constants.pm cp lib/Test/SQL/Translator.pm blib/lib/Test/SQL/Translator.pm cp lib/SQL/Translator/Producer.pm blib/lib/SQL/Translator/Producer.pm cp lib/SQL/Translator/Parser/DBI/Sybase.pm blib/lib/SQL/Translator/Parser/DBI/Sybase.pm cp lib/SQL/Translator/Producer/YAML.pm blib/lib/SQL/Translator/Producer/YAML.pm cp script/sqlt-dumper blib/script/sqlt-dumper /Users/fly1003/bin/perl "-Iinc" "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/sqlt-dumper cp script/sqlt-diagram blib/script/sqlt-diagram /Users/fly1003/bin/perl "-Iinc" "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/sqlt-diagram cp script/sqlt-graph blib/script/sqlt-graph /Users/fly1003/bin/perl "-Iinc" "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/sqlt-graph cp script/sqlt-diff blib/script/sqlt-diff /Users/fly1003/bin/perl "-Iinc" "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/sqlt-diff cp script/sqlt-diff-old blib/script/sqlt-diff-old /Users/fly1003/bin/perl "-Iinc" "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/sqlt-diff-old cp script/sqlt blib/script/sqlt /Users/fly1003/bin/perl "-Iinc" "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/sqlt Manifying blib/man1/sqlt-dumper.1 Manifying blib/man1/sqlt-diagram.1 Manifying blib/man1/sqlt-graph.1 Manifying blib/man1/sqlt-diff.1 Manifying blib/man1/sqlt-diff-old.1 Manifying blib/man1/sqlt.1 Manifying blib/man3/SQL::Translator::Parser::Storable.3 Manifying blib/man3/SQL::Translator::Filter::DefaultExtra.3 Manifying blib/man3/SQL::Translator.3 Manifying blib/man3/SQL::Translator::Parser::DBI::MySQL.3 Manifying blib/man3/SQL::Translator::Parser::Access.3 Manifying blib/man3/SQL::Translator::Producer::SQLite.3 Manifying blib/man3/SQL::Translator::Parser::PostgreSQL.3 Manifying blib/man3/SQL::Translator::Parser::DBI::SQLite.3 Manifying blib/man3/SQL::Translator::Producer::Diagram.3 Manifying blib/man3/SQL::Translator::Producer::Sybase.3 Manifying blib/man3/SQL::Translator::Parser::MySQL.3 Manifying blib/man3/SQL::Translator::Schema::Table.3 Manifying blib/man3/SQL::Translator::Producer::ClassDBI.3 Manifying blib/man3/SQL::Translator::Parser::xSV.3 Manifying blib/man3/SQL::Translator::Parser::DBI::Oracle.3 Manifying blib/man3/SQL::Translator::Parser::Excel.3 Manifying blib/man3/SQL::Translator::Schema::Index.3 Manifying blib/man3/SQL::Translator::Manual.3 Manifying blib/man3/SQL::Translator::Producer::GraphViz.3 Manifying blib/man3/SQL::Translator::Parser::DBI::SQLServer.3 Manifying blib/man3/SQL::Translator::Parser::DBI::DB2.3 Manifying blib/man3/SQL::Translator::Producer::SQLServer.3 Manifying blib/man3/SQL::Translator::Filter::Globals.3 Manifying blib/man3/SQL::Translator::Schema::View.3 Manifying blib/man3/SQL::Translator::Parser::SQLServer.3 Manifying blib/man3/SQL::Translator::Parser::Oracle.3 Manifying blib/man3/SQL::Translator::Parser::SQLite.3 Manifying blib/man3/SQL::Translator::Producer::Dumper.3 Manifying blib/man3/SQL::Translator::Producer::Latex.3 Manifying blib/man3/SQL::Translator::Parser.3 Manifying blib/man3/SQL::Translator::Producer::XML::SQLFairy.3 Manifying blib/man3/SQL::Translator::Parser::DBI::PostgreSQL.3 Manifying blib/man3/SQL::Translator::Parser::XML.3 Manifying blib/man3/SQL::Translator::Schema::Trigger.3 Manifying blib/man3/SQL::Translator::Producer::HTML.3 Manifying blib/man3/SQL::Translator::Parser::YAML.3 Manifying blib/man3/SQL::Translator::Schema::Field.3 Manifying blib/man3/SQL::Translator::Parser::DBI.3 Manifying blib/man3/SQL::Translator::Producer::TT::Base.3 Manifying blib/man3/SQL::Translator::Producer::POD.3 Manifying blib/man3/SQL::Translator::Parser::XML::SQLFairy.3 Manifying blib/man3/SQL::Translator::Schema::Constraint.3 Manifying blib/man3/SQL::Translator::Filter::Names.3 Manifying blib/man3/SQL::Translator::Producer::TTSchema.3 Manifying blib/man3/SQL::Translator::Producer::PostgreSQL.3 Manifying blib/man3/SQL::Translator::Producer::DB2.3 Manifying blib/man3/SQL::Translator::Producer::MySQL.3 Manifying blib/man3/SQL::Translator::Schema.3 Manifying blib/man3/SQL::Translator::Producer::Storable.3 Manifying blib/man3/SQL::Translator::Producer::Oracle.3 Manifying blib/man3/SQL::Translator::Producer::TT::Table.3 Manifying blib/man3/SQL::Translator::Utils.3 Manifying blib/man3/SQL::Translator::Schema::Object.3 Manifying blib/man3/SQL::Translator::Parser::Sybase.3 Manifying blib/man3/SQL::Translator::Schema::Constants.3 Manifying blib/man3/Test::SQL::Translator.3 Manifying blib/man3/SQL::Translator::Parser::DBI::Sybase.3 Manifying blib/man3/SQL::Translator::Producer.3 Manifying blib/man3/SQL::Translator::Producer::YAML.3 Manifying blib/man3/SQL::Translator::Producer::XML.3 Manifying blib/man3/SQL::Translator::Schema::Procedure.3 Manifying blib/man3/SQL::Translator::Producer::DiaUml.3 Manifying blib/man3/SQL::Translator::Diff.3 JROBINSON/SQL-Translator-0.11007.tar.gz make -- OK Running make test >>> make test TEST_VERBOSE=1 PERL_DL_NONLAZY=1 /Users/fly1003/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(1, 'inc', 'blib/lib', 'blib/arch')" t/*.t t/01pod.t ............................... 1..77 ok 1 - POD test for blib/script/sqlt ok 2 - POD test for blib/script/sqlt-diagram ok 3 - POD test for blib/script/sqlt-diff ok 4 - POD test for blib/script/sqlt-diff-old ok 5 - POD test for blib/script/sqlt-dumper ok 6 - POD test for blib/script/sqlt-graph ok 7 - POD test for blib/lib/SQL/Translator.pm ok 8 - POD test for blib/lib/SQL/Translator/Diff.pm ok 9 - POD test for blib/lib/SQL/Translator/Manual.pod ok 10 - POD test for blib/lib/SQL/Translator/Parser.pm ok 11 - POD test for blib/lib/SQL/Translator/Producer.pm ok 12 - POD test for blib/lib/SQL/Translator/Schema.pm ok 13 - POD test for blib/lib/SQL/Translator/Utils.pm ok 14 - POD test for blib/lib/Test/SQL/Translator.pm ok 15 - POD test for blib/lib/SQL/Translator/Filter/DefaultExtra.pm ok 16 - POD test for blib/lib/SQL/Translator/Filter/Globals.pm ok 17 - POD test for blib/lib/SQL/Translator/Filter/Names.pm ok 18 - POD test for blib/lib/SQL/Translator/Parser/Access.pm ok 19 - POD test for blib/lib/SQL/Translator/Parser/DB2.pm (no pod) ok 20 - POD test for blib/lib/SQL/Translator/Parser/DBI.pm ok 21 - POD test for blib/lib/SQL/Translator/Parser/Excel.pm ok 22 - POD test for blib/lib/SQL/Translator/Parser/MySQL.pm ok 23 - POD test for blib/lib/SQL/Translator/Parser/Oracle.pm ok 24 - POD test for blib/lib/SQL/Translator/Parser/PostgreSQL.pm ok 25 - POD test for blib/lib/SQL/Translator/Parser/SQLite.pm ok 26 - POD test for blib/lib/SQL/Translator/Parser/SQLServer.pm ok 27 - POD test for blib/lib/SQL/Translator/Parser/Storable.pm ok 28 - POD test for blib/lib/SQL/Translator/Parser/Sybase.pm ok 29 - POD test for blib/lib/SQL/Translator/Parser/XML.pm ok 30 - POD test for blib/lib/SQL/Translator/Parser/xSV.pm ok 31 - POD test for blib/lib/SQL/Translator/Parser/YAML.pm ok 32 - POD test for blib/lib/SQL/Translator/Producer/ClassDBI.pm ok 33 - POD test for blib/lib/SQL/Translator/Producer/DB2.pm ok 34 - POD test for blib/lib/SQL/Translator/Producer/Diagram.pm ok 35 - POD test for blib/lib/SQL/Translator/Producer/DiaUml.pm ok 36 - POD test for blib/lib/SQL/Translator/Producer/Dumper.pm ok 37 - POD test for blib/lib/SQL/Translator/Producer/GraphViz.pm ok 38 - POD test for blib/lib/SQL/Translator/Producer/HTML.pm ok 39 - POD test for blib/lib/SQL/Translator/Producer/Latex.pm ok 40 - POD test for blib/lib/SQL/Translator/Producer/MySQL.pm ok 41 - POD test for blib/lib/SQL/Translator/Producer/Oracle.pm ok 42 - POD test for blib/lib/SQL/Translator/Producer/POD.pm ok 43 - POD test for blib/lib/SQL/Translator/Producer/PostgreSQL.pm ok 44 - POD test for blib/lib/SQL/Translator/Producer/SQLite.pm ok 45 - POD test for blib/lib/SQL/Translator/Producer/SQLServer.pm ok 46 - POD test for blib/lib/SQL/Translator/Producer/Storable.pm ok 47 - POD test for blib/lib/SQL/Translator/Producer/Sybase.pm ok 48 - POD test for blib/lib/SQL/Translator/Producer/TTSchema.pm ok 49 - POD test for blib/lib/SQL/Translator/Producer/XML.pm ok 50 - POD test for blib/lib/SQL/Translator/Producer/YAML.pm ok 51 - POD test for blib/lib/SQL/Translator/Schema/Constants.pm ok 52 - POD test for blib/lib/SQL/Translator/Schema/Constraint.pm ok 53 - POD test for blib/lib/SQL/Translator/Schema/Field.pm ok 54 - POD test for blib/lib/SQL/Translator/Schema/Graph.pm (no pod) ok 55 - POD test for blib/lib/SQL/Translator/Schema/Index.pm ok 56 - POD test for blib/lib/SQL/Translator/Schema/Object.pm ok 57 - POD test for blib/lib/SQL/Translator/Schema/Procedure.pm ok 58 - POD test for blib/lib/SQL/Translator/Schema/Table.pm ok 59 - POD test for blib/lib/SQL/Translator/Schema/Trigger.pm ok 60 - POD test for blib/lib/SQL/Translator/Schema/View.pm ok 61 - POD test for blib/lib/SQL/Translator/Parser/DB2/Grammar.pm (no pod) ok 62 - POD test for blib/lib/SQL/Translator/Parser/DBI/DB2.pm ok 63 - POD test for blib/lib/SQL/Translator/Parser/DBI/MySQL.pm ok 64 - POD test for blib/lib/SQL/Translator/Parser/DBI/Oracle.pm ok 65 - POD test for blib/lib/SQL/Translator/Parser/DBI/PostgreSQL.pm ok 66 - POD test for blib/lib/SQL/Translator/Parser/DBI/SQLite.pm ok 67 - POD test for blib/lib/SQL/Translator/Parser/DBI/SQLServer.pm ok 68 - POD test for blib/lib/SQL/Translator/Parser/DBI/Sybase.pm ok 69 - POD test for blib/lib/SQL/Translator/Parser/XML/SQLFairy.pm ok 70 - POD test for blib/lib/SQL/Translator/Producer/TT/Base.pm ok 71 - POD test for blib/lib/SQL/Translator/Producer/TT/Table.pm ok 72 - POD test for blib/lib/SQL/Translator/Producer/XML/SQLFairy.pm ok 73 - POD test for blib/lib/SQL/Translator/Schema/Graph/CompoundEdge.pm (no pod) ok 74 - POD test for blib/lib/SQL/Translator/Schema/Graph/Edge.pm (no pod) ok 75 - POD test for blib/lib/SQL/Translator/Schema/Graph/HyperEdge.pm (no pod) ok 76 - POD test for blib/lib/SQL/Translator/Schema/Graph/Node.pm (no pod) ok 77 - POD test for blib/lib/SQL/Translator/Schema/Graph/Port.pm (no pod) ok t/02mysql-parser.t ...................... 1..317 ok 1 - Schema is valid ok 2 - Right number of tables (1) ok 3 - Found "sessions" table ok 4 - Right number of fields (4) ok 5 - First field name is "id" ok 6 - Type is "char" ok 7 - Size is "32" ok 8 - Field cannot be null ok 9 - Default value is "0" ok 10 - Field is PK ok 11 - Second field name is "a_session" ok 12 - Type is "text" ok 13 - Size is "65,535" ok 14 - Field can be null ok 15 - Default value is undefined ok 16 - Field is not PK ok 17 - Right number of indices (2) ok 18 - Found fulltext ok 19 - Right number of constraints (2) ok 20 - Constraint is a PK ok 21 - Constraint is on "id" ok 22 - Constraint is UNIQUE ok 23 - Constraint is on "ssn" ok 24 - Schema is valid ok 25 - Right number of tables (1) ok 26 - Found "check" table ok 27 - Right number of fields (10) ok 28 - First field name is "check_id" ok 29 - Type is "int" ok 30 - Size is "7" ok 31 - Field cannot be null ok 32 - Default value is "0000000" ok 33 - Field is PK ok 34 - Field is auto inc ok 35 - Field is unsigned ok 36 - Field is zerofill ok 37 - Second field name is "successful" ok 38 - Type is "date" ok 39 - Size is "0" ok 40 - Field cannot be null ok 41 - Default value is "0000-00-00" ok 42 - Field is not PK ok 43 - Third field name is "unsuccessful" ok 44 - Type is "date" ok 45 - Size is "0" ok 46 - Field can be null ok 47 - Default value is "0000-00-00" ok 48 - Field is not PK ok 49 - Fourth field name is "i1" ok 50 - Type is "int" ok 51 - Size is "11" ok 52 - Field cannot be null ok 53 - Default value is "0" ok 54 - Field is not PK ok 55 - Fifth field name is "s1" ok 56 - Type is "set" ok 57 - Size is "1" ok 58 - Field can be null ok 59 - Default value is "b" ok 60 - Field is not PK ok 61 - List is "a,b,c" ok 62 - Sixth field name is "e1" ok 63 - Type is "enum" ok 64 - Size is "1" ok 65 - Field can be null ok 66 - Default value is "c" ok 67 - Field is not PK ok 68 - List is "a,b,c" ok 69 - Seventh field name is "name" ok 70 - Type is "varchar" ok 71 - Size is "30" ok 72 - Field can be null ok 73 - Default value is "NULL" ok 74 - Field is not PK ok 75 - Eighth field name is "foo_type" ok 76 - Type is "enum" ok 77 - Size is "2" ok 78 - Field cannot be null ok 79 - Default value is "vk" ok 80 - Field is not PK ok 81 - List is "vk,ck" ok 82 - Ninth field name is "date" ok 83 - Type is "timestamp" ok 84 - Size is "0" ok 85 - Field can be null ok 86 - Default value is undefined ok 87 - Field is not PK ok 88 - Tenth field name is "time_stamp2" ok 89 - Type is "timestamp" ok 90 - Size is "0" ok 91 - Field can be null ok 92 - Default value is undefined ok 93 - Field is not PK ok 94 - Right number of indices (3) ok 95 - No name on index ok 96 - Normal index ok 97 - Index is on field "i1" ok 98 - Name is "date_idx" ok 99 - Normal index ok 100 - Index is on field "date" ok 101 - Name is "name_idx" ok 102 - Normal index ok 103 - Index is on field "name(10)" ok 104 - Right number of constraints (2) ok 105 - Constraint is a PK ok 106 - Constraint is on "check_id" ok 107 - Constraint is UNIQUE ok 108 - Constraint is on "date, i1" ok 109 - Schema is valid ok 110 - Right number of tables (2) ok 111 - Found "orders" table ok 112 - Table comment OK ok 113 - Right number of fields (10) ok 114 - First field name is "order_id" ok 115 - Type is "int" ok 116 - Size is "11" ok 117 - Field cannot be null ok 118 - Default value is undefined ok 119 - Field is PK ok 120 - Field is auto inc ok 121 - Second field name is "member_id" ok 122 - Type is "varchar" ok 123 - Size is "255" ok 124 - Field can be null ok 125 - Field comment OK ok 126 - Default value is undefined ok 127 - Third field name is "billing_address_id" ok 128 - Type is "int" ok 129 - Size is "11" ok 130 - Fourth field name is "shipping_address_id" ok 131 - Type is "int" ok 132 - Size is "11" ok 133 - Fifth field name is "credit_card_id" ok 134 - Type is "int" ok 135 - Size is "11" ok 136 - Sixth field name is "status" ok 137 - Type is "smallint" ok 138 - Size is "6" ok 139 - Field cannot be null ok 140 - Seventh field name is "store_id" ok 141 - Type is "varchar" ok 142 - Size is "255" ok 143 - Field cannot be null ok 144 - Field is a FK ok 145 - FK isa SQL::Translator::Schema::Constraint ok 146 - FK is to "store" table ok 147 - Eighth field name is "tax" ok 148 - Type is "decimal" ok 149 - Size is "8,2" ok 150 - Ninth field name is "shipping_charge" ok 151 - Type is "decimal" ok 152 - Size is "8,2" ok 153 - Tenth field name is "price_paid" ok 154 - Type is "decimal" ok 155 - Size is "8,2" ok 156 - Right number of indices (4) ok 157 - First index is normal ok 158 - Index is on "status" ok 159 - Second index is normal ok 160 - Index is on "billing_address_id" ok 161 - Third index is normal ok 162 - Index is on "shipping_address_id" ok 163 - Third index is normal ok 164 - Index is on "member_id,store_id" ok 165 - Right number of constraints (5) ok 166 - Constraint is a PK ok 167 - Constraint is on "order_id" ok 168 - Constraint is a FK ok 169 - Constraint is on "status" ok 170 - To table "order_status" ok 171 - To field "id" ok 172 - Constraint is a FK ok 173 - Constraint is on "billing_address_id" ok 174 - To table "address" ok 175 - To field "address_id" ok 176 - Constraint is a FK ok 177 - Constraint is on "shipping_address_id" ok 178 - To table "address" ok 179 - To field "address_id" ok 180 - Constraint is a FK ok 181 - Constraint is on "store_id" ok 182 - To table "store" ok 183 - No reference fields defined ok 184 - Found "address" table ok 185 - Right number of fields (8) ok 186 - Schema is valid ok 187 - Database name extracted from USE ok 188 - Right number of tables (2) ok 189 - Found "one" table ok 190 - Found "two" table ok 191 - Right number of constraints (2) on table one ok 192 - Constraint is a PK ok 193 - Constraint is on "id" ok 194 - Constraint is a FK ok 195 - Constraint is on "two_id" ok 196 - To table "two" ok 197 - To field "id" ok 198 - Right number of constraints (2) on table two ok 199 - Constraint is a PK ok 200 - Constraint is on "id" ok 201 - Constraint is a FK ok 202 - Constraint is on "one_id" ok 203 - To table "one" ok 204 - To field "id" ok 205 - Schema is valid ok 206 - Right number of tables (1) ok 207 - Found "one" table ok 208 - Right number of fields (2) on table one ok 209 - Table has right table type option ok 210 - Table has right character set option ok 211 - Field is a varchar ok 212 - Field is right size ok 213 - Field has right character set qualifier ok 214 - Field has right collate qualifier ok 215 - Field has right default value ok 216 - Field is a timestamp ok 217 - Field is not nullable ok 218 - Field has right default value ok 219 - Field has right on update qualifier ok 220 - Right number of views (3) ok 221 - Found "vs_asset" view ok 222 - Found "vs_asset2" view ok 223 - Found "vs_asset3" view ok 224 - Detected algorithm ok 225 - Detected view vs_asset ok 226 - Did not detect cfgmgmt_mig ok 227 - Right number of procedures (2) ok 228 - Found "ap_from_millitime_nullable" procedure ok 229 - Detected procedure ap_from_millitime_nullable ok 230 - Found "sp_update_security_acl" procedure ok 231 - Detected procedure sp_update_security_acl ok 232 - Schema is valid ok 233 - Right number of tables (1) ok 234 - Found "test" table ok 235 - Collate found ok 236 - Character set found ok 237 - '4' parsed as perl version '4' ok 238 - '5.01.0' parsed as perl version '5.001' ok 239 - '50003' parsed as perl version '5.000003' ok 240 - '5.1' parsed as perl version '5.001' ok 241 - '3.23.2' parsed as perl version '3.023002' ok 242 - '4' parsed as mysql version '40000' ok 243 - '5.01.0' parsed as mysql version '50100' ok 244 - '50003' parsed as mysql version '50003' ok 245 - '5.1' parsed as mysql version '50100' ok 246 - '3.23.2' parsed as mysql version '32302' ok 247 - Exception thrown on invalid version string ok 248 - Schema is valid ok 249 - Right number of tables (1) ok 250 - Found "merge_example" table ok 251 - Table has right table engine option ok 252 - UNION option has correct set ok 253 - Right number of fields (2) ok 254 - First field name is "id" ok 255 - Type is "int" ok 256 - Size is "11" ok 257 - Field cannot be null ok 258 - Field is PK ok 259 - Second field name is "shape_field" ok 260 - Type is "geometry" ok 261 - Field cannot be null ok 262 - Field is not PK ok 263 - Right number of indices (1) ok 264 - No name on index ok 265 - Spatial index ok 266 - Right number of constraints (1) ok 267 - Constraint is a PK ok 268 - Constraint is on "id" ok 269 - Schema is valid ok 270 - Right number of tables (1) ok 271 - Found "quote" table ok 272 - Table has right table engine option ok 273 - First field name is "id" ok 274 - Type is "int" ok 275 - Size is "11" ok 276 - Field cannot be null ok 277 - Field is PK ok 278 - Schema is valid ok 279 - Right number of tables (1) ok 280 - Found "quote" table ok 281 - Table has right table engine option ok 282 - First field name is "id" ok 283 - Type is "int" ok 284 - Size is "11" ok 285 - Field cannot be null ok 286 - Field is PK ok 287 - Schema is valid ok 288 - Right number of tables (1) ok 289 - Found "quote" table ok 290 - Table has right table engine option ok 291 - First field name is "id" ok 292 - Type is "int" ok 293 - Size is "11" ok 294 - Field cannot be null ok 295 - Field is PK ok 296 - Schema is valid ok 297 - Right number of tables (1) ok 298 - Found "sessions" table ok 299 - Right number of fields (3) ok 300 - First field name is "id" ok 301 - Type is "char" ok 302 - Size is "32" ok 303 - Field cannot be null ok 304 - Default value is "0" ok 305 - Field is PK ok 306 - Second field name is "ssn" ok 307 - Type is "varchar" ok 308 - Size is "12" ok 309 - Field can not be null ok 310 - Single quote in default value is escaped properly ok 311 - Field is not PK ok 312 - Second field name is "user" ok 313 - Type is "varchar" ok 314 - Size is "20" ok 315 - Field can not be null ok 316 - Single quote in default value is escaped properly ok 317 - Field is not PK ok t/03mysql-to-oracle.t ................... 1..3 ok 1 - Translate MySQL to Oracle ok 2 - Normal index definition translated. ok 3 - Unique index definition translated. ok t/04file,fh,string.t .................... 1..3 ok 1 - passing string (filename) works ok 2 - passing string as SCALAR reference ok 3 - from file == from string ok t/05bgep-re.t ........................... 1..2 ok 1 - MySQL->XML-SQLFairy ok 2 - Successfully parsed output ok t/06xsv.t ............................... 1..25 ok 1 - Correct number of tables (1) ok 2 - Table is named "table1" ok 3 - Correct number of fields (7) ok 4 - First field name is "One" ok 5 - Data type is "char" ok 6 - Size is "3" ok 7 - Field is PK ok 8 - First field name is "Two" ok 9 - Data type is "char" ok 10 - Size is "2" ok 11 - Field is not PK ok 12 - Fifth field name is "Five" ok 13 - Data type is "char" ok 14 - Size is "26" ok 15 - Field is not PK ok 16 - Sixth field name is "Six" ok 17 - Data type is "integer" ok 18 - Size is "6" ok 19 - Seventh field name is "Seven" ok 20 - Data type is "float" ok 21 - Size is "3,2" ok 22 - Correct number of indices (0) ok 23 - Correct number of constraints (1) ok 24 - Constraint is a PK ok 25 - On field "One" ok t/07p_args.t ............................ 1..9 ok 1 - parser_args works when called directly ok 2 - right number of tables ok 3 - right number of fields ok 4 - parser_args works when called indirectly ok 5 - right number of tables ok 6 - right number of fields ok 7 - parser_args works when called as constructor arg ok 8 - right number of tables ok 9 - right number of fields with new delimiter ok t/08postgres-to-mysql.t ................. 1..1 ok 1 - Translate PG2My ok t/09sqlt-diagram.t ...................... 1..3 ok 1 Image written to 'sqlCfbP_'. Done. ok 2 ok 3 ok t/10excel.t ............................. 1..31 ok 1 - Parsed 1 table ok 2 - Table name is "Sheet1" ok 3 - Table has 7 fields ok 4 - First field name is "ID" ok 5 - Data type is "integer" ok 6 - Size is "5" ok 7 - Field is PK ok 8 - Second field name is "text" ok 9 - Data type is "char" ok 10 - Size is "7" ok 11 - Field is not PK ok 12 - Third field name is "number" ok 13 - Data type is "integer" ok 14 - Size is "1" ok 15 - Field is not PK ok 16 - Fourth field name is "math" ok 17 - Data type is "float" ok 18 - Size is "3,1" ok 19 - Field is not PK ok 20 - Fifth field name is "bitmap" ok 21 - Data type is "char" ok 22 - Size is "1" ok 23 - Field is not PK ok 24 - Sixth field name is "today" ok 25 - Data type is "CHAR" ok 26 - Size is "10" ok 27 - Field is not PK ok 28 - Seventh field name is "silly_field_with_random_characters" ok 29 - Data type is "CHAR" ok 30 - Size is "11" ok 31 - Field is not PK ok t/11normalize.t ......................... 1..5 ok 1 - use SQL::Translator::Utils; ok 2 - normalize_name('- 9s80 qwehjf 4r') => '_9s80_qwehjf_4r' ok 3 - normalize_name('hello, world') => 'hello_world' ok 4 - normalize_name('444') => '_444' ok 5 - normalize_name('silly field (with random characters)') => 'silly_field_with_random_characters' ok t/12header_comment.t .................... 1..5 ok 1 - use SQL::Translator::Utils; ok 2 - default comment ok 3 - Created by... ok 4 - Multiline header comment... ok 5 - ...with additional junk ok t/13schema.t ............................ 1..238 ok 1 - require SQL::Translator; ok 2 - require SQL::Translator::Schema; ok 3 - The object isa SQL::Translator::Schema ok 4 - Schema name is "foo" ok 5 - Schema name changed to "bar" ok 6 - Schema database is "MySQL" ok 7 - Schema database changed to "PostgreSQL" ok 8 - Schema not valid... ok 9 - ...because there are no tables ok 10 - Table "foo" isa SQL::Translator::Schema::Table ok 11 - Table "bar" isa SQL::Translator::Schema::Table ok 12 - Add table "bar" ok 13 - Schema isa SQL::Translator::Schema ok 14 - Can't change name of table "bar" to "foo"... ok 15 - ...because "foo" exists ok 16 - Can't create another "foo" table... ok 17 - ... because "foo" exists ok 18 - Can't add an anonymous table... ok 19 - ... because it has no name ok 20 - Can't create an anonymous table ok 21 - ... because it has no name ok 22 - Dropped table "foo" isa SQL::Translator::Schema::Table ok 23 - Dropped table "foo" by object isa SQL::Translator::Schema::Table ok 24 - Can't drop non-existant table "foo" ok 25 - Table name is "foo" ok 26 - Table stringifies to "foo" ok 27 - Table "foo" is not yet valid ok 28 - Table "foo" has no fields ok 29 - Error for no fields ok 30 - No comments ok 31 - Table name is "person" ok 32 - Table is not yet valid ok 33 - Comments = "foo" ok 34 - Table comments = "foo,bar" ok 35 - Table comments = "foo,bar" ok 36 - Field isa SQL::Translator::Schema::Field ok 37 - Field name is "foo" ok 38 - Field full_name is "person.foo" ok 39 - Field stringifies to "foo" ok 40 - Field data type is blank ok 41 - Field size is "0" ok 42 - Field is_primary_key is false ok 43 - Field can be NULL ok 44 - Field default is undefined ok 45 - No comments ok 46 - Field table is person ok 47 - Field schema shortcut works ok 48 - f2 isa SQL::Translator::Schema::Field ok 49 - Add field "f2" ok 50 - Field cannot be NULL ok 51 - Field cannot be NULL ok 52 - Field cannot be NULL ok 53 - Field default is empty string ok 54 - Field comment = "foo" ok 55 - Field comment = "foo,bar" ok 56 - Field comment = "foo,bar" ok 57 - person_table isa SQL::Translator::Schema::Table ok 58 - Can't set field name of "f2" to "foo"... ok 59 - ...because name exists ok 60 - Didn't create another "f2" field... ok 61 - ... because it exists ok 62 - Didn't add a "" field... ok 63 - ... because it has no name ok 64 - Didn't create a "" field... ok 65 - ... because it has no name ok 66 - Table "foo" has 2 fields ok 67 - First field is "foo" ok 68 - Second field is "f2" ok 69 - field_names is "foo,f2" ok 70 - Dropped field "f2" isa SQL::Translator::Schema::Field ok 71 - Dropped field "f2" by object isa SQL::Translator::Schema::Field ok 72 - Can't drop non-existant field "f2" ok 73 - Field name is "person_name" ok 74 - Field data type is "varchar" ok 75 - Field size is "30" ok 76 - Field is_primary_key is negative ok 77 - Field extra "foo" is "bar" ok 78 - Field extra "baz" is "quux" ok 79 - Field name is "age" ok 80 - Field data type is "float" ok 81 - Field size is "10,2" ok 82 - Field size still "10,2" ok 83 - Field size still "10,2" ok 84 - Field size still "10,2" ok 85 - Field size returns array ok 86 - No indices ok 87 - Error for no indices ok 88 - Index isa SQL::Translator::Schema::Index ok 89 - Index name is "foo" ok 90 - Index name is not valid... ok 91 - ...because it has no fields ok 92 - Index accepts fields ok 93 - Index name is not valid... ok 94 - ...because it used fields not in the table ok 95 - Index accepts fields ok 96 - Index name is now valid ok 97 - Index type is "normal" ok 98 - Index isa SQL::Translator::Schema::Index ok 99 - Index name is "bar" ok 100 - Two indices ok 101 - "foo" index ok 102 - "bar" index ok 103 - Dropped index "foo" isa SQL::Translator::Schema::Index ok 104 - Dropped index "foo" by object isa SQL::Translator::Schema::Index ok 105 - Dropped correct index "foo" ok 106 - Can't drop non-existant index "foo" ok 107 - No constraints ok 108 - Error for no constraints ok 109 - Constraint isa SQL::Translator::Schema::Constraint ok 110 - Constraint name is "foo" ok 111 - Constraint field = "age" ok 112 - Constraint fields returns a SQL::Translator::Schema::Field ok 113 - Constraint field = "age" ok 114 - Constraint field = "age,name" ok 115 - Constraint field = "age,name" ok 116 - Constraint field = "age,name" ok 117 - Constraint field = "age,name" ok 118 - Constraint field = "age,name" ok 119 - Constraint field_names = "age,name" ok 120 - Constraint match type is empty ok 121 - Constraint match type rejects bad arg... ok 122 - ...because it is invalid ok 123 - Constraint match type = "full" ok 124 - Constraint isa SQL::Translator::Schema::Constraint ok 125 - Constraint name is "bar" ok 126 - Constraint isa SQL::Translator::Schema::Constraint ok 127 - Constraint type is "CHECK" ok 128 - Constraint expression is "foo bar" ok 129 - Three constraints ok 130 - "foo" constraint ok 131 - "bar" constraint ok 132 - Dropped constraint "foo" isa SQL::Translator::Schema::Constraint ok 133 - Dropped constraint "foo" by object isa SQL::Translator::Schema::Constraint ok 134 - Dropped correct constraint "foo" ok 135 - Can't drop non-existant constraint "foo" ok 136 - View isa SQL::Translator::Schema::View ok 137 - View SQL is good ok 138 - Add view "view2" ok 139 - Didn't create another "view2" view... ok 140 - ... because it exists ok 141 - Dropped view "view1" isa SQL::Translator::Schema::View ok 142 - Dropped view "view1" by object isa SQL::Translator::Schema::View ok 143 - Dropped correct view "view1" ok 144 - Can't drop non-existant view "view1" ok 145 - Error on no arg to get_table ok 146 - Error on bad arg to get_table ok 147 - Error on no arg to get_view ok 148 - Error on bad arg to get_view ok 149 - Table "foo" isa SQL::Translator::Schema::Table ok 150 - View "view1" isa SQL::Translator::Schema::View ok 151 - View SQL is good ok 152 - Found 2 tables ok 153 - Found 1 view ok 154 - Field is PK ok 155 - Field is auto inc ok 156 - Constraint on "person" not valid... ok 157 - ...because it has no type ok 158 - Constraint type now a FK ok 159 - Constraint on "person" not valid... ok 160 - ...because it has no fields ok 161 - Fields now = "foo" ok 162 - Constraint on "person" not valid... ok 163 - ...because field "foo" doesn't exist ok 164 - Added field "pet_id" ok 165 - Fields now = "pet_id" ok 166 - Fields now = "f1,f2" ok 167 - Constraint on "person" not valid... ok 168 - ...because too many fields for FK ok 169 - Constraint on "person" not valid... ok 170 - ...because there's no reference table ok 171 - Reference table now = "foo" ok 172 - Constraint on "person" not valid... ok 173 - ...because reference table "foo" doesn't exist ok 174 - Added "pet" table ok 175 - Reference table now = "pet" ok 176 - Constraint on "person" not valid... ok 177 - ...because there're no reference fields ok 178 - Reference fields = "pet_id" ok 179 - Constraint on "person" not valid... ok 180 - ...because there's no "pet_id" field in "pet" ok 181 - Added field "pet_id" ok 182 - Constraint now valid ok 183 - No primary key ok 184 - Can't make PK on "person_id"... ok 185 - ...because it doesn't exist ok 186 - Constraint isa SQL::Translator::Schema::Constraint ok 187 - Constraint now on "person_id" ok 188 - Constraint now on "person_id" and "name" ok 189 - Found 1 constraint ok 190 - Made "person_id" PK on "person" ok 191 - FK found PK "person.id" ok 192 - View isa SQL::Translator::Schema::View ok 193 - Schema isa SQL::Translator::Schema ok 194 - Schema name is "'ViewTest'" ok 195 - Name is "foo_view" ok 196 - Name is "select name, age from person" ok 197 - Fields are "name, age" ok 198 - Number of views is 1 ok 199 - View isa SQL::Translator::Schema::View ok 200 - Name is "foo_view" ok 201 - Trigger isa SQL::Translator::Schema::Trigger ok 202 - Schema isa SQL::Translator::Schema ok 203 - Schema name is "'TrigTest'" ok 204 - Name is "foo_trigger" ok 205 - Perform action when is "after" ok 206 - Database event is "insert" ok 207 - table is a Table" isa SQL::Translator::Schema::Table ok 208 - Action is "update modified=timestamp();" ok 209 - Number of triggers is 1 ok 210 - Trigger isa SQL::Translator::Schema::Trigger ok 211 - Name is "foo_trigger" ok 212 - Trigger isa SQL::Translator::Schema::Trigger ok 213 - Schema isa SQL::Translator::Schema ok 214 - Schema name is "'TrigTest2'" ok 215 - Name is "foo_trigger" ok 216 - Database events are [qw/insert update/] ok 217 - Database events isa ARRAY ok 218 - Compare two Triggers with database_event and database_events ok 219 - Compare two Triggers with database_event ok 220 - Compare two Triggers with database_events ok 221 - Dropped trigger "foo_trigger" isa SQL::Translator::Schema::Trigger ok 222 - Dropped trigger "foo_trigger" by object isa SQL::Translator::Schema::Trigger ok 223 - Dropped correct trigger "foo_trigger" ok 224 - Can't drop non-existant trigger "foo_trigger" ok 225 - Procedure isa SQL::Translator::Schema::Procedure ok 226 - Schema isa SQL::Translator::Schema ok 227 - Schema name is "'ProcTest'" ok 228 - Name is "foo_proc" ok 229 - SQL is "select foo from bar" ok 230 - Params = 'foo,bar' ok 231 - Comments = "Go Sox!" ok 232 - Number of procedures is 1 ok 233 - Procedure isa SQL::Translator::Schema::Procedure ok 234 - Name is "foo_proc" ok 235 - Dropped procedure "foo_proc" isa SQL::Translator::Schema::Procedure ok 236 - Dropped procedure "foo_proc" by object isa SQL::Translator::Schema::Procedure ok 237 - Dropped correct procedure "foo_proc" ok 238 - Can't drop non-existant procedure "foo_proc" ok t/14postgres-parser.t ................... 1..129 ok 1 - Schema object isa SQL::Translator::Schema ok 2 - Five tables ok 3 - Table t_test1 exists ok 4 - Table comment exists ok 5 - 13 fields in t_test1 ok 6 - First field is "f_serial" ok 7 - Field is an integer ok 8 - Field cannot be null ok 9 - Size is "11" ok 10 - Default value is "0" ok 11 - Field is PK ok 12 - Comment ok 13 - Field is auto increment ok 14 - Second field is "f_varchar" ok 15 - Field is a varchar ok 16 - Field can be null ok 17 - Size is "255" ok 18 - Default value is undefined ok 19 - Field is not PK ok 20 - Field is not auto increment ok 21 - Third field is "f_double" ok 22 - Field is a float ok 23 - Field can be null ok 24 - Size is "20" ok 25 - Default value is undefined ok 26 - Field is not PK ok 27 - Fourth field is "f_bigint" ok 28 - Field is an integer ok 29 - Field cannot be null ok 30 - Size is "20" ok 31 - Default value is undefined ok 32 - Field is not PK ok 33 - Fifth field is "f_char" ok 34 - Field is char ok 35 - Field can be null ok 36 - Size is "10" ok 37 - Default value is undefined ok 38 - Field is not PK ok 39 - Sixth field is "f_bool" ok 40 - Field is a boolean ok 41 - Field can be null ok 42 - Size is "0" ok 43 - Default value is undefined ok 44 - Field is not PK ok 45 - Seventh field is "f_bin" ok 46 - Field is bytea ok 47 - Field can be null ok 48 - Size is "0" ok 49 - Default value is undefined ok 50 - Field is not PK ok 51 - Eighth field is "f_tz" ok 52 - Field is a timestamp ok 53 - Field can be null ok 54 - Size is "0" ok 55 - Default value is undefined ok 56 - Field is not PK ok 57 - Ninth field is "f_text" ok 58 - Field is text ok 59 - Field can be null ok 60 - Size is "64,000" ok 61 - Default value is undefined ok 62 - Field is not PK ok 63 - Tenth field is "f_fk1" ok 64 - Field is an integer ok 65 - Field cannot be null ok 66 - Size is "10" ok 67 - Default value is undefined ok 68 - Field is not PK ok 69 - Field is a FK ok 70 - FK isa SQL::Translator::Schema::Constraint ok 71 - FK is to "t_test2" table ok 72 - Eleventh field is "f_timestamp" ok 73 - Field is a timestamp with time zone ok 74 - Field can be null ok 75 - Size is "0" ok 76 - Default value is "undef" ok 77 - Field is not PK ok 78 - Field is not FK ok 79 - 12th field is "f_timestamp2" ok 80 - Field is a timestamp without time zone ok 81 - Field can be null ok 82 - Size is "0" ok 83 - Default value is "undef" ok 84 - Field is not PK ok 85 - Field is not FK ok 86 - 8 constraints on t_test1 ok 87 - First constraint is PK ok 88 - Constraint is on field "f_serial" ok 89 - Second constraint is foreign key ok 90 - Constraint is on field "f_fk1" ok 91 - Constraint is to table "t_test2" ok 92 - Constraint is to field "f_id" ok 93 - Third constraint is unique ok 94 - Constraint is on field "f_varchar" ok 95 - Fourth constraint is foreign key ok 96 - Constraint is on field "f_fk2" ok 97 - Constraint is to table "t_test2" ok 98 - Constraint is to field "f_id" ok 99 - On delete: cascade ok 100 - On delete: no action ok 101 - Match type: simple ok 102 - Deferrable detected ok 103 - Table t_test2 exists ok 104 - 3 fields in t_test2 ok 105 - First field is "f_id" ok 106 - Field is an integer ok 107 - Field cannot be null ok 108 - Size is "10" ok 109 - Default value is undefined ok 110 - Field is PK ok 111 - Second field is "f_varchar" ok 112 - Field is an varchar ok 113 - Field can be null ok 114 - Size is "25" ok 115 - Default value is undefined ok 116 - Field is not PK ok 117 - Third field is "f_int" ok 118 - Field is an integer ok 119 - Field can be null ok 120 - Size is "5" ok 121 - Default value is undefined ok 122 - Field is not PK ok 123 - Three constraints on table ok 124 - Constraint is NOT NULL ok 125 - Constraint is a PK ok 126 - Constraint is a 'CHECK' ok 127 - Table is NOT temporary ok 128 - Table is TEMP ok 129 - Table is TEMPORARY ok t/15oracle-parser.t ..................... 1..99 ok 1 - Schema object isa SQL::Translator::Schema ok 2 - Found four tables ok 3 - First table is "qtl_trait_category" ok 4 - Comment = "hey, hey, hey, hey" ok 5 - 2 fields in table ok 6 - First field is "qtl_trait_category_id" ok 7 - Field is a number ok 8 - Size is "11" ok 9 - Field cannot be null ok 10 - Default value is undefined ok 11 - Field is PK ok 12 - Comment = "the primary key!" ok 13 - Second field is "trait_category" ok 14 - Field is a varchar2 ok 15 - Size is "100" ok 16 - Field cannot be null ok 17 - Default value is undefined ok 18 - Field is not PK ok 19 - 0 indices on table ok 20 - 3 constraints on table ok 21 - Constraint name is "pk_qtl_trait_category" ok 22 - First constraint is PK ok 23 - Constraint is on field "qtl_trait_category_id" ok 24 - Second constraint is a check ok 25 - Constraint is on field "trait_category" ok 26 - Third constraint is unique ok 27 - Constraint is on field "trait_category" ok 28 - Table "qtl_trait" exists ok 29 - Comment "foo bar" exists ok 30 - 4 fields in table ok 31 - First field is "qtl_trait_id" ok 32 - Field is a number ok 33 - Size is "11" ok 34 - Field cannot be null ok 35 - Default value is undefined ok 36 - Field is PK ok 37 - Second field is "trait_symbol" ok 38 - Field is a varchar2 ok 39 - Size is "100" ok 40 - Field cannot be null ok 41 - Field is not a FK ok 42 - Third field is "trait_name" ok 43 - Field is a varchar2 ok 44 - Size is "200" ok 45 - Field cannot be null ok 46 - Field is not a FK ok 47 - Fourth field is "qtl_trait_category_id" ok 48 - Field is a number ok 49 - Size is "11" ok 50 - Field cannot be null ok 51 - Field is a FK ok 52 - FK isa SQL::Translator::Schema::Constraint ok 53 - FK references table "qtl_trait_category" ok 54 - FK references field "qtl_trait_category_id" ok 55 - 4 constraints on table ok 56 - First constraint is PK ok 57 - Name is "pk_qtl_trait" ok 58 - Fields = "qtl_trait_id" ok 59 - Second constraint is unique ok 60 - No name ok 61 - Fields = "trait_symbol" ok 62 - Third constraint is unique ok 63 - No name ok 64 - Fields = "trait_name" ok 65 - Fourth constraint is FK ok 66 - No name ok 67 - Fields = "qtl_trait_category_id" ok 68 - Reference table = "qtl_trait_category" ok 69 - Reference fields = "qtl_trait_category_id" ok 70 - Table "qtl" exists ok 71 - 8 fields in table ok 72 - 4 constraints on table ok 73 - Fourth constraint is unique ok 74 - Name = "qtl_accession_upper" ok 75 - Fields = "UPPER(qtl_accession_id)" ok 76 - Comment "qtl table comment" exists ok 77 - Comment "qtl_id comment" exists ok 78 - Comment "accession comment" exists ok 79 - 1 index on table ok 80 - First index is normal ok 81 - Name is "qtl_index" ok 82 - Fields = "qtl_accession_id" ok 83 - Table "qtl_trait_synonym" exists ok 84 - 3 fields in table ok 85 - 3 constraints on table ok 86 - Third constraint is FK ok 87 - No name ok 88 - Fields = "qtl_trait_id" ok 89 - Reference table = "qtl_trait" ok 90 - Reference fields = "qtl_trait_id" ok 91 - on_delete = "SET NULL" ok 92 - Right number of views (1) ok 93 - Found "VS_ASSET" view ok 94 - Detected view VS_ASSET ok 95 - Did not detect CMDOMAIN_MIG ok 96 - Right number of procedures (1) ok 97 - Found "P_24_HOUR_EVENT_SUMMARY" procedure ok 98 - Detected procedure P_24_HOUR_EVENT_SUMMARY ok 99 - Did not detect CMDOMAIN_MIG ok t/16xml-parser.t ........................ 1..238 ok 1 - database_event deprecation warning issued ok 2 - Schema name is '' ok 3 - database is '' ok 4 - extra ok 5 - is valid ok 6 - table names match ok 7 - Table 'Basic' ok 8 - options are 'HASH(0x197f9b0)' ok 9 - extra ok 10 - field names are id, title, description, email, explicitnulldef, explicitemptystring, emptytagdef, another_id, timest ok 11 - Field 'Basic.id' ok 12 - is valid ok 13 - type is 'int' ok 14 - size is '10' ok 15 - default value is UNDEF ok 16 - cannot be null ok 17 - cannot be unique ok 18 - is a primary_key ok 19 - is not a foreign_key ok 20 - is an auto_increment ok 21 - comments ok 22 - extra ok 23 - Field 'Basic.title' ok 24 - is valid ok 25 - type is 'varchar' ok 26 - size is '100' ok 27 - default value is 'hello' ok 28 - cannot be null ok 29 - can be unique ok 30 - is not a primary_key ok 31 - is not a foreign_key ok 32 - is not an auto_increment ok 33 - comments ok 34 - extra ok 35 - Field 'Basic.description' ok 36 - is valid ok 37 - type is 'text' ok 38 - size is '0' ok 39 - default value is '' ok 40 - can be null ok 41 - cannot be unique ok 42 - is not a primary_key ok 43 - is not a foreign_key ok 44 - is not an auto_increment ok 45 - comments ok 46 - extra ok 47 - Field 'Basic.email' ok 48 - is valid ok 49 - type is 'varchar' ok 50 - size is '500' ok 51 - default value is UNDEF ok 52 - can be null ok 53 - can be unique ok 54 - is not a primary_key ok 55 - is not a foreign_key ok 56 - is not an auto_increment ok 57 - comments ok 58 - extra ok 59 - Field 'Basic.explicitnulldef' ok 60 - is valid ok 61 - type is 'varchar' ok 62 - size is '255' ok 63 - default value is UNDEF ok 64 - can be null ok 65 - cannot be unique ok 66 - is not a primary_key ok 67 - is not a foreign_key ok 68 - is not an auto_increment ok 69 - comments ok 70 - extra ok 71 - Field 'Basic.explicitemptystring' ok 72 - is valid ok 73 - type is 'varchar' ok 74 - size is '255' ok 75 - default value is '' ok 76 - can be null ok 77 - cannot be unique ok 78 - is not a primary_key ok 79 - is not a foreign_key ok 80 - is not an auto_increment ok 81 - comments ok 82 - extra ok 83 - Field 'Basic.emptytagdef' ok 84 - is valid ok 85 - type is 'varchar' ok 86 - size is '255' ok 87 - default value is '' ok 88 - can be null ok 89 - cannot be unique ok 90 - is not a primary_key ok 91 - is not a foreign_key ok 92 - is not an auto_increment ok 93 - comments ok 94 - extra ok 95 - Field 'Basic.another_id' ok 96 - is valid ok 97 - type is 'int' ok 98 - size is '10' ok 99 - default value is '2' ok 100 - can be null ok 101 - cannot be unique ok 102 - is not a primary_key ok 103 - is a foreign_key ok 104 - is not an auto_increment ok 105 - comments ok 106 - extra ok 107 - Field 'Basic.timest' ok 108 - is valid ok 109 - type is 'timestamp' ok 110 - size is '0' ok 111 - default value is UNDEF ok 112 - can be null ok 113 - cannot be unique ok 114 - is not a primary_key ok 115 - is not a foreign_key ok 116 - is not an auto_increment ok 117 - comments ok 118 - extra ok 119 - Table has 1 indices ok 120 - Index 'titleindex' ok 121 - is valid ok 122 - type is 'NORMAL' ok 123 - fields are 'title' ok 124 - options are '' ok 125 - extra ok 126 - Table has 4 constraints ok 127 - Constraint '' ok 128 - type is 'PRIMARY KEY' ok 129 - can be deferred ok 130 - is valid ok 131 - table is 'Basic' ok 132 - expression is '' ok 133 - fields are 'id' ok 134 - reference_table is '' ok 135 - reference_fields are '' ok 136 - match_type is '' ok 137 - on_delete is '' ok 138 - on_update is '' ok 139 - options are '' ok 140 - extra ok 141 - Constraint 'emailuniqueindex' ok 142 - type is 'UNIQUE' ok 143 - can be deferred ok 144 - is valid ok 145 - table is 'Basic' ok 146 - expression is '' ok 147 - fields are 'email' ok 148 - reference_table is '' ok 149 - reference_fields are '' ok 150 - match_type is '' ok 151 - on_delete is '' ok 152 - on_update is '' ok 153 - options are '' ok 154 - extra ok 155 - Constraint 'very_long_index_name_on_title_field_which_should_be_truncated_for_various_rdbms' ok 156 - type is 'UNIQUE' ok 157 - can be deferred ok 158 - is valid ok 159 - table is 'Basic' ok 160 - expression is '' ok 161 - fields are 'title' ok 162 - reference_table is '' ok 163 - reference_fields are '' ok 164 - match_type is '' ok 165 - on_delete is '' ok 166 - on_update is '' ok 167 - options are '' ok 168 - extra ok 169 - Constraint 'Basic_fk' ok 170 - type is 'FOREIGN KEY' ok 171 - can be deferred ok 172 - is valid ok 173 - table is 'Basic' ok 174 - expression is '' ok 175 - fields are 'another_id' ok 176 - reference_table is 'Another' ok 177 - reference_fields are 'id' ok 178 - match_type is '' ok 179 - on_delete is '' ok 180 - on_update is '' ok 181 - options are '' ok 182 - extra ok 183 - Table 'Another' ok 184 - options are 'HASH(0x34470)' ok 185 - extra ok 186 - field names are id, num ok 187 - Field 'Another.id' ok 188 - is valid ok 189 - type is 'int' ok 190 - size is '10' ok 191 - default value is UNDEF ok 192 - cannot be null ok 193 - cannot be unique ok 194 - is a primary_key ok 195 - is not a foreign_key ok 196 - is an auto_increment ok 197 - comments ok 198 - extra ok 199 - Field 'Another.num' ok 200 - is valid ok 201 - type is 'numeric' ok 202 - size is '10,2' ok 203 - default value is UNDEF ok 204 - can be null ok 205 - cannot be unique ok 206 - is not a primary_key ok 207 - is not a foreign_key ok 208 - is not an auto_increment ok 209 - comments ok 210 - extra ok 211 - Schema has 2 triggers ok 212 - Trigger 'foo_trigger' ok 213 - is valid ok 214 - perform_action_when is 'after' ok 215 - database_events is 'insert' ok 216 - on_table is 'Basic' ok 217 - action is 'update modified=timestamp();' ok 218 - extra ok 219 - Trigger 'bar_trigger' ok 220 - is valid ok 221 - perform_action_when is 'before' ok 222 - database_events is 'insert,update' ok 223 - on_table is 'Basic' ok 224 - action is 'update modified2=timestamp();' ok 225 - extra ok 226 - Schema has 1 views ok 227 - View 'email_list' ok 228 - is valid ok 229 - sql is 'SELECT email FROM Basic WHERE (email IS NOT NULL)' ok 230 - fields are 'email' ok 231 - extra ok 232 - Schema has 1 procedures ok 233 - Procedure 'foo_proc' ok 234 - sql is 'select foo from bar' ok 235 - parameters are 'foo,bar' ok 236 - comments is 'Go Sox!' ok 237 - owner is 'Nomar' ok 238 - extra ok t/17sqlfxml-producer.t .................. 1..14 ok 1 - Produced something! ok 2 - XML looks right ok 3 - Translate (View) ran ok 4 - Produced something! ok 5 - XML looks right ok 6 - Translate (Trigger) ran ok 7 - Produced something! ok 8 - XML looks right ok 9 - Translate (Procedure) ran ok 10 - Produced something! ok 11 - XML looks right ok 12 - Translate (Field.extra) ran ok 13 - Produced something! ok 14 - XML looks right ok t/18ttschema-producer.t ................. 1..6 ok 1 - Translate ran ok 2 - Produced something! ok 3 - Output looks right ok 4 - Translate ran ok 5 - Produced something! ok 6 - Output looks right ok t/19sybase-parser.t ..................... 1..41 ok 1 - File exists ok 2 - Data ok 3 - Parse ok 4 - Schema isa SQL::Translator::Schema ok 5 - Schema is valid ok 6 - Nine tables ok 7 - Table isa SQL::Translator::Schema::Table ok 8 - Name = 'jdbc_function_escapes' ok 9 - Two fields ok 10 - First field name is 'escape_name' ok 11 - First field is 'varchar' ok 12 - First field size is '40' ok 13 - First field cannot be null ok 14 - Second field name is 'map_string' ok 15 - Second field is 'varchar' ok 16 - Second field size is '40' ok 17 - Second field cannot be null ok 18 - Table isa SQL::Translator::Schema::Table ok 19 - Name = 'spt_jtext' ok 20 - Two fields ok 21 - First field name is 'mdinfo' ok 22 - First field is 'varchar' ok 23 - First field size is '30' ok 24 - First field cannot be null ok 25 - Second field name is 'value' ok 26 - Second field is 'text' ok 27 - Second field size is '0' ok 28 - Second field cannot be null ok 29 - One constraint ok 30 - Constraint is UNIQUE ok 31 - On "mdinfo" ok 32 - Table isa SQL::Translator::Schema::Table ok 33 - Name = 'spt_mda' ok 34 - Seven fields ok 35 - First field name is 'mdinfo' ok 36 - First field is 'varchar' ok 37 - First field size is '30' ok 38 - First field cannot be null ok 39 - One constraint ok 40 - Constraint is UNIQUE ok 41 - On "mdinfo,mdaver_end,srvver_end" ok t/20format_X_name.t ..................... 1..25 ok 1 ok 2 - $tr->format_table_name("foo") == "foo" ok 3 - $tr->format_package_name("foo") == "foo" ok 4 - $tr->format_fk_name("foo") == "foo" ok 5 - $tr->format_pk_name("foo") == "foo" ok 6 - $tr->format_table_name(sub { "table_$_[0]" }) ok 7 - $tr->format_table_name("foo") == "table_foo" ok 8 - $tr->format_package_name(sub { "package_$_[0]" }) ok 9 - $tr->format_package_name("foo") == "package_foo" ok 10 - $tr->format_fk_name(sub { "fk_$_[0]" }) ok 11 - $tr->format_fk_name("foo") == "fk_foo" ok 12 - $tr->format_pk_name(sub { "pk_$_[0]" }) ok 13 - $tr->format_pk_name("foo") == "pk_foo" ok 14 - $tr->format_table_name(sub { "table_$_[0]" }) ok 15 - $tr->format_table_name("foo") == "table_foo" ok 16 - $tr->format_package_name(sub { "package_$_[0]" }) ok 17 - $tr->format_package_name("foo") == "package_foo" ok 18 - $tr->format_fk_name(sub { "fk_$_[0]" }) ok 19 - $tr->format_fk_name("foo") == "fk_foo" ok 20 - $tr->format_pk_name(sub { "pk_$_[0]" }) ok 21 - $tr->format_pk_name("foo") == "pk_foo" ok 22 - $tr->format_table_name(sub { "table_$_[0]" }, "foo") == "table_foo" ok 23 - $tr->format_package_name(sub { "package_$_[0]" }, "foo") == "package_foo" ok 24 - $tr->format_fk_name(sub { "fk_$_[0]" }, "foo") == "fk_foo" ok 25 - $tr->format_pk_name(sub { "pk_$_[0]" }, "foo") == "pk_foo" ok t/24yaml.t .............................. 1..2 ok 1 - Translate SQLite to YAML ok 2 - YAML matches expected ok t/25storable.t .......................... 1..2 ok 1 - use SQL::Translator::Parser::Storable; ok 2 - use SQL::Translator::Producer::Storable; ok t/26sybase.t ............................ 1..3 ok 1 - use SQL::Translator::Parser::DBI::Sybase; ok 2 - use SQL::Translator::Parser::Storable; ok 3 - use SQL::Translator::Producer::Storable; ok t/27sqlite-parser.t ..................... 1..19 ok 1 - Parsed two tables ok 2 - 'Person' table ok 3 - Six fields in "person" table ok 4 - First field is "person_id" ok 5 - Is an autoincrement field ok 6 - 'Pet' table ok 7 - 3 constraints on pet ok 8 - FK constraint ok 9 - References person table ok 10 - References person_id field ok 11 - Parsed one views ok 12 - Parsed one triggers ok 13 - Parsed one table ok 14 - 'Pet' table ok 15 - 3 constraints on pet ok 16 - FK constraint ok 17 - References person table ok 18 - Constraint name fk_person_id ok 19 - References person_id field ok t/29html.t .............................. 1..5 ok 1 - Parsed table OK ok 2 - Parsed HTML OK ok 3 - One table in the SQL produces 3 tags ok 4 - One 'LinkTable' class ok 5 - SQLfairy plug is alive and well ok t/30sqlt-diff.t ......................... 1..21 ok 1 - Found sqlt-diff script ok 2 - Detected 'untested' comment ok 3 - Detected altered 'iq' field ok 4 - Detected missing rock star field ok 5 - Properly detected no differences ok 6 - Did not detect 'untested' comment ok 7 - Detected altered 'person_id' field ok 8 - Detected altered 'iq' field ok 9 - Detected altered 'name' field ok 10 - Detected altered 'age' field ok 11 - Detected missing rock star field ok 12 - Detected missing unique constraint ok 13 - Detected unique index with different name ok 14 - Detected altered table option ok 15 - Detected drop foreign key ok 16 - Detected add constraint ok 17 - Primary key looks different when it shouldn't ok 18 - Properly detected no differences ok 19 - Did not detect 'untested' comment ok 20 - Detected drop foreign key ok 21 - Detected add constraint ok t/30sqlt-new-diff-mysql.t ............... 1..9 ok 1 - use SQL::Translator::Diff; ok 2 - Got a list ok 3 - Diff as expected ok 4 - Diff as expected ok 5 - No differences found ok 6 - No differences found ok 7 - Batch alter of constraints work for InnoDB ok 8 - Alter/drop constraints works with rename table ok 9 - Quoting can be turned on ok t/30sqlt-new-diff-pgsql.t ............... 1..4 ok 1 - use SQL::Translator::Diff; ok 2 - Diff as expected ok 3 - Diff as expected ok 4 - No differences found ok t/30sqlt-new-diff-sqlite.t .............. 1..4 ok 1 - use SQL::Translator::Diff; ok 2 - Diff as expected ok 3 - Diff as expected ok 4 - No differences found ok t/30sqlt-new-diff.t ..................... 1..10 ok 1 - use SQL::Translator::Diff; ok 2 - Correct differences correct on employee table ok 3 - Correct differences correct on person table ok 4 - tables_to_drop right ok 5 - tables_to_create right ok 6 - Correct differences correct on employee table ok 7 - Correct differences correct on person table ok 8 - No differences ok 9 - tables_to_drop right ok 10 - tables_to_create right ok make: *** [test_dynamic] Terminated Timeout (max run time is 300s) /Users/fly1003/bin/perl killed by signal 15