Back
From: metabase:user:315f03b2-2aae-11df-837a-5e0a49663a4f
Subject: FAIL DBIx-Class-0.08204 v5.17.6 GNU/Linux
Date: 2012-11-19T06:40:57Z
This distribution has been tested as part of the CPAN Testers
project, supporting the Perl programming language. See
http://wiki.cpantesters.org/ for more information or email
questions to cpan-testers-discuss@perl.org
--
Dear Torsten Raudssus,
This is a computer-generated report for DBIx-Class-0.08204
on perl 5.17.6, created by CPAN-Reporter-1.2006.
Thank you for uploading your work to CPAN. However, there was a problem
testing your distribution.
If you think this report is invalid, please consult the CPAN Testers Wiki
for suggestions on how to avoid getting FAIL reports for missing library
or binary dependencies, unsupported operating systems, and so on:
http://wiki.cpantesters.org/wiki/CPANAuthorNotes
Sections of this report:
* Tester comments
* Program output
* Prerequisites
* Environment and other context
------------------------------
TESTER COMMENTS
------------------------------
Additional comments from tester:
this report is from an automated smoke testing program
and was not reviewed by a human for accuracy
------------------------------
PROGRAM OUTPUT
------------------------------
Output from 'make test':
PERL_DL_NONLAZY=1 /home/smoke/perl5/perlbrew/perls/perl-blead/bin/perl5.17.6 "-MExtUtils::Command::MM" "-e" "test_harness(0, 'inc', 'blib/lib', 'blib/arch')" t/*.t t/admin/*.t t/cdbi/*.t t/cdbi/DeepAbstractSearch/*.t t/cdbi/abstract/*.t t/cdbi/sweet/*.t t/count/*.t t/delete/*.t t/inflate/*.t t/multi_create/*.t t/ordered/*.t t/prefetch/*.t t/relationship/*.t t/resultset/*.t t/row/*.t t/schema/*.t t/search/*.t t/sqlmaker/*.t t/sqlmaker/limit_dialects/*.t t/sqlmaker/quotes/*.t t/storage/*.t t/update/*.t
t/04_c3_mro.t .................................... ok
t/05components.t ................................. ok
t/100extra_source.t .............................. ok
datatype mismatch: bind param (0) foo as integer at /home/smoke/perl5/perlbrew/perls/perl-blead/lib/site_perl/5.17.6/i686-linux-thread-multi-64int/DBI.pm line 1985, <> line 1.
t/100populate.t .................................. ok
t/101populate_rs.t ............................... ok
t/101source.t .................................... ok
t/102load_classes.t .............................. ok
t/103many_to_many_warning.t ...................... ok
t/104view.t ...................................... ok
t/105view_deps.t ................................. ok
t/106dbic_carp.t ................................. ok
t/107obj_result_class.t .......................... ok
t/18insert_default.t ............................. ok
t/19retrieve_on_insert.t ......................... ok
t/20setuperrors.t ................................ ok
t/26dumper.t ..................................... ok
t/33exception_wrap.t ............................. ok
t/34exception_action.t ........................... ok
t/39load_namespaces_1.t .......................... ok
t/39load_namespaces_2.t .......................... ok
t/39load_namespaces_3.t .......................... ok
t/39load_namespaces_4.t .......................... ok
t/39load_namespaces_exception.t .................. ok
t/39load_namespaces_rt41083.t .................... ok
t/39load_namespaces_stress.t ..................... ok
t/40compose_connection.t ......................... ok
t/40resultsetmanager.t ........................... ok
t/46where_attribute.t ............................ ok
t/50fork.t ....................................... skipped: Test needs DBD::Pg (see DBIx::Class::Optional::Dependencies for details)
t/51threadnodb.t ................................. ok
t/51threads.t .................................... skipped: Test needs DBD::Pg (see DBIx::Class::Optional::Dependencies for details)
t/51threadtxn.t .................................. skipped: Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test (note: creates and drops a table named artist!)
Unhandled type: REGEXP at /home/smoke/perl5/perlbrew/perls/perl-blead/lib/site_perl/5.17.6/Devel/Cycle.pm line 107, <> line 1.
t/52leaks.t ...................................... ok
t/53lean_startup.t ............................... ok
t/54taint.t ...................................... ok
t/55namespaces_cleaned.t ......................... ok
t/60core.t ....................................... ok
t/61findnot.t .................................... ok
t/63register_class.t ............................. ok
t/63register_column.t ............................ ok
t/63register_source.t ............................ ok
t/64db.t ......................................... ok
t/65multipk.t .................................... ok
t/67pager.t ...................................... ok
t/69update.t ..................................... ok
t/70auto.t ....................................... ok
t/71mysql.t ...................................... skipped: Set $ENV{DBICTEST_MYSQL_DSN}, _USER and _PASS to run this test
t/72pg.t ......................................... skipped: Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test
t/72pg_bytea.t ................................... skipped: Test needs DBD::Pg (see DBIx::Class::Optional::Dependencies for details)
t/73oracle.t ..................................... skipped: Set $ENV{DBICTEST_ORA_DSN}, _USER and _PASS to run this test.
t/73oracle_blob.t ................................ skipped: Set $ENV{DBICTEST_ORA_DSN}, _USER and _PASS to run this test.
t/73oracle_hq.t .................................. skipped: Set $ENV{DBICTEST_ORA_DSN}, _USER and _PASS to run this test.
t/745db2.t ....................................... skipped: Set $ENV{DBICTEST_DB2_DSN}, _USER and _PASS to run this test
t/746db2_400.t ................................... skipped: Set $ENV{DBICTEST_DB2_400_DSN}, _USER and _PASS to run this test
t/746mssql.t ..................................... skipped: Set $ENV{DBICTEST_MSSQL_ODBC_DSN}, _USER and _PASS to run this test
t/746sybase.t .................................... skipped: Set $ENV{DBICTEST_SYBASE_DSN}, _USER and _PASS to run this test. Warning: This test drops and creates the tables: 'artist', 'money_test' and 'bindtype_test'
t/747mssql_ado.t ................................. skipped: Set $ENV{DBICTEST_MSSQL_ADO_DSN}, _USER and _PASS to run this test
t/748informix.t .................................. skipped: Set $ENV{DBICTEST_INFORMIX_DSN}, _USER and _PASS to run this test
t/749sqlanywhere.t ............................... skipped: Set $ENV{DBICTEST_SQLANYWHERE_DSN} and/or $ENV{DBICTEST_SQLANYWHERE_ODBC_DSN},
t/74mssql.t ...................................... skipped: Set $ENV{DBICTEST_MSSQL_DSN}, _USER and _PASS to run this test
t/750firebird.t .................................. skipped: Set $ENV{DBICTEST_FIREBIRD_DSN} and/or $ENV{DBICTEST_FIREBIRD_INTERBASE_DSN} and/or $ENV{DBICTEST_FIREBIRD_ODBC_DSN}, _USER and _PASS to run these tests. WARNING: this test creates and drops the tables "artist", "bindtype_test" and "sequence_test"; the generators "gen_artist_artistid", "pkid1_seq", "pkid2_seq" and "nonpkid_seq" and the trigger "artist_bi".
t/751msaccess.t .................................. skipped: Set $ENV{DBICTEST_MSACCESS_ODBC_DSN} and/or $ENV{DBICTEST_MSACCESS_ADO_DSN} (and optionally _USER and _PASS) to run these tests.
t/752sqlite.t .................................... ok
t/76joins.t ...................................... ok
t/76select.t ..................................... ok
t/77join_count.t ................................. ok
t/78self_referencial.t ........................... ok
t/79aliasing.t ................................... ok
t/80unique.t ..................................... ok
t/82cascade_copy.t ............................... ok
t/83cache.t ...................................... ok
t/84serialize.t .................................. ok
t/85utf8.t ....................................... ok
t/86might_have.t ................................. ok
t/86sqlt.t ....................................... ok
t/87ordered.t .................................... ok
t/88result_set_column.t .......................... ok
t/90ensure_class_loaded.t ........................ ok
t/90join_torture.t ............................... ok
t/91merge_joinpref_attr.t ........................ ok
t/93autocast.t ................................... ok
t/93single_accessor_object.t ..................... ok
t/94pk_mutation.t ................................ ok
t/94versioning.t ................................. skipped: Set $ENV{DBICTEST_MYSQL_DSN}, _USER and _PASS to run this test
t/96_is_deteministic_value.t ..................... ok
t/97result_class.t ............................... ok
t/98savepoints.t ................................. skipped: Set $ENV{DBICTEST_PG_DSN} and/or $ENV{DBICTEST_MYSQL_DSN} _USER and _PASS to run these tests.
t/99dbic_sqlt_parser.t ........................... ok
t/admin/01load.t ................................. skipped: Test needs MooseX::Types::JSON >= 0.02 (see DBIx::Class::Optional::Dependencies for details)
t/admin/02ddl.t .................................. skipped: Test needs MooseX::Types::JSON >= 0.02 (see DBIx::Class::Optional::Dependencies for details)
t/admin/03data.t ................................. skipped: Test needs MooseX::Types::JSON >= 0.02 (see DBIx::Class::Optional::Dependencies for details)
t/admin/10script.t ............................... skipped: Test needs MooseX::Types::JSON >= 0.02, Text::CSV >= 1.16
t/cdbi/01-columns.t .............................. skipped: Class::DBI required for this test
t/cdbi/02-Film.t ................................. skipped: Class::DBI required for this test
t/cdbi/03-subclassing.t .......................... skipped: Class::DBI required for this test
t/cdbi/04-lazy.t ................................. skipped: Class::DBI required for this test
t/cdbi/06-hasa.t ................................. skipped: Class::DBI required for this test
t/cdbi/08-inheritcols.t .......................... skipped: Class::DBI required for this test
t/cdbi/09-has_many.t ............................. skipped: Class::DBI required for this test
t/cdbi/11-triggers.t ............................. skipped: Class::DBI required for this test
t/cdbi/12-filter.t ............................... skipped: Class::DBI required for this test
t/cdbi/13-constraint.t ........................... skipped: Class::DBI required for this test
t/cdbi/14-might_have.t ........................... skipped: Class::DBI required for this test
t/cdbi/15-accessor.t ............................. skipped: Class::DBI required for this test
t/cdbi/16-reserved.t ............................. skipped: Class::DBI required for this test
t/cdbi/18-has_a.t ................................ skipped: Class::DBI required for this test
t/cdbi/19-set_sql.t .............................. skipped: Class::DBI required for this test
t/cdbi/21-iterator.t ............................. skipped: Class::DBI required for this test
t/cdbi/22-deflate_order.t ........................ skipped: Class::DBI required for this test
t/cdbi/22-self_referential.t ..................... skipped: Class::DBI required for this test
t/cdbi/23-cascade.t .............................. skipped: Class::DBI required for this test
t/cdbi/24-meta_info.t ............................ skipped: Class::DBI required for this test
t/cdbi/26-mutator.t .............................. skipped: Class::DBI required for this test
t/cdbi/30-pager.t ................................ skipped: Class::DBI required for this test
t/cdbi/68-inflate_has_a.t ........................ skipped: Class::DBI required for this test
t/cdbi/98-failure.t .............................. skipped: Class::DBI required for this test
t/cdbi/abstract/search_where.t ................... skipped: Class::DBI required for this test
t/cdbi/columns_as_hashes.t ....................... skipped: Class::DBI required for this test
t/cdbi/columns_dont_override_custom_accessors.t .. skipped: Class::DBI required for this test
t/cdbi/construct.t ............................... skipped: Class::DBI required for this test
t/cdbi/copy.t .................................... skipped: Class::DBI required for this test
t/cdbi/DeepAbstractSearch/01_search.t ............ skipped: Class::DBI required for this test
t/cdbi/early_column_heisenbug.t .................. skipped: Class::DBI required for this test
t/cdbi/has_many_loads_foreign_class.t ............ skipped: Class::DBI required for this test
t/cdbi/hasa_without_loading.t .................... skipped: Class::DBI required for this test
t/cdbi/max_min_value_of.t ........................ skipped: Class::DBI required for this test
t/cdbi/mk_group_accessors.t ...................... skipped: Class::DBI required for this test
t/cdbi/multi_column_set.t ........................ skipped: Class::DBI required for this test
t/cdbi/object_cache.t ............................ skipped: Class::DBI required for this test
t/cdbi/retrieve_from_sql_with_limit.t ............ skipped: Class::DBI required for this test
t/cdbi/set_to_undef.t ............................ skipped: Class::DBI required for this test
t/cdbi/set_vs_DateTime.t ......................... skipped: Class::DBI required for this test
t/cdbi/sweet/08pager.t ........................... skipped: Class::DBI required for this test
t/count/count_rs.t ............................... ok
Unescaped left brace in regex is deprecated, passed through in regex; marked by <-- HERE in m/select => { <-- HERE distinct => \.\.\. } syntax is not supported for multiple columns/ at t/count/distinct.t line 83.
t/count/distinct.t ............................... ok
t/count/group_by_func.t .......................... ok
t/count/grouped_pager.t .......................... ok
t/count/in_subquery.t ............................ ok
t/count/joined.t ................................. ok
t/count/prefetch.t ............................... ok
t/count/search_related.t ......................... ok
t/delete/cascade_missing.t ....................... ok
t/delete/complex.t ............................... ok
t/delete/m2m.t ................................... ok
t/delete/related.t ............................... ok
t/discard_changes_in_DESTROY.t ................... ok
t/inflate/core.t ................................. ok
t/inflate/datetime.t ............................. skipped: DT inflation tests need DateTime::Format::SQLite
t/inflate/datetime_determine_parser.t ............ skipped: Test needs DateTime::Format::SQLite
t/inflate/datetime_firebird.t .................... skipped: Set $ENV{DBICTEST_FIREBIRD_DSN} and/or $ENV{DBICTEST_FIREBIRD_INTERBASE_DSN}
t/inflate/datetime_informix.t .................... skipped: Set $ENV{DBICTEST_INFORMIX_DSN} _USER and _PASS to run this test'.
t/inflate/datetime_missing_deps.t ................ ok
t/inflate/datetime_msaccess.t .................... skipped: Set $ENV{DBICTEST_MSACCESS_ODBC_DSN} and/or $ENV{DBICTEST_MSACCESS_ADO_DSN} (and optionally _USER and _PASS) to run these tests.
t/inflate/datetime_mssql.t ....................... skipped: Set $ENV{DBICTEST_MSSQL_ODBC_DSN} and/or $ENV{DBICTEST_MSSQL_DSN} and/or $ENV{DBICTEST_MSSQL_ADO_DSN} _USER and _PASS to run this test
t/inflate/datetime_mysql.t ....................... ok
t/inflate/datetime_oracle.t ...................... skipped: Set $ENV{DBICTEST_ORA_DSN}, _USER and _PASS to run this test. Warning: This test drops and creates a table called 'track'
t/inflate/datetime_pg.t .......................... ok
t/inflate/datetime_sqlanywhere.t ................. skipped: Set $ENV{DBICTEST_SQLANYWHERE_DSN} and/or $ENV{DBICTEST_SQLANYWHERE_ODBC_DSN}
t/inflate/datetime_sybase.t ...................... skipped: Set $ENV{DBICTEST_SYBASE_DSN}, _USER and _PASS to run this test
t/inflate/file_column.t .......................... ok
t/inflate/hri.t .................................. ok
t/inflate/serialize.t ............................ ok
t/multi_create/cd_single.t ....................... ok
t/multi_create/diamond.t ......................... ok
t/multi_create/existing_in_chain.t ............... ok
t/multi_create/has_many.t ........................ ok
t/multi_create/in_memory.t ....................... ok
t/multi_create/insert_defaults.t ................. ok
t/multi_create/m2m.t ............................. ok
t/multi_create/multilev_single_PKeqFK.t .......... ok
t/multi_create/reentrance_count.t ................ ok
t/multi_create/standard.t ........................ ok
t/multi_create/torture.t ......................... ok
t/ordered/cascade_delete.t ....................... ok
t/ordered/unordered_movement.t ................... ok
t/prefetch/attrs_untouched.t ..................... ok
t/prefetch/bugs.t ................................ ok
t/prefetch/correlated.t .......................... ok
t/prefetch/count.t ............................... ok
t/prefetch/diamond.t ............................. ok
t/prefetch/double_prefetch.t ..................... ok
t/prefetch/grouped.t ............................. ok
t/prefetch/incomplete.t .......................... ok
t/prefetch/join_type.t ........................... ok
t/prefetch/multiple_hasmany.t .................... ok
t/prefetch/o2m_o2m_order_by_with_limit.t ......... ok
t/prefetch/one_to_many_to_one.t .................. ok
t/prefetch/standard.t ............................ ok
t/prefetch/undef_prefetch_bug.t .................. ok
t/prefetch/via_search_related.t .................. ok
t/prefetch/with_limit.t .......................... ok
t/relationship/after_update.t .................... ok
t/relationship/core.t ............................ ok
t/relationship/custom.t .......................... ok
t/relationship/doesnt_exist.t .................... ok
t/relationship/info.t ............................ ok
t/relationship/proxy.t ........................... ok
t/relationship/set_column_on_fk.t ................ ok
t/relationship/unresolvable.t .................... ok
t/relationship/update_or_create_multi.t .......... ok
t/relationship/update_or_create_single.t ......... ok
t/resultset/as_query.t ........................... ok
# Failed test at t/resultset/as_subselect_rs.t line 45.
# SQL expressions differ
# got: (SELECT COUNT( * ) FROM (SELECT artist.name AS artist__name, me.title, (SELECT COUNT(*) FROM cds WHERE cd.artist = artist.id), genre.name AS genre__name, me.year FROM cd me LEFT JOIN genre genre ON genre.genreid = me.genreid JOIN artist artist ON artist.artistid = me.artist GROUP BY artist.name, me.title, (SELECT COUNT(*) FROM cds WHERE cd.artist = artist.id), genre.name, me.year LIMIT ?) me)
# expected: (
# SELECT COUNT( * )
# FROM (
# SELECT artist.name AS artist__name, (SELECT COUNT(*) FROM cds WHERE cd.artist = artist.id), genre.name AS genre__name, me.title, me.year
# FROM cd me
# LEFT JOIN genre genre
# ON genre.genreid = me.genreid
# JOIN artist artist ON artist.artistid = me.artist
# GROUP BY artist.name, (SELECT COUNT(*) FROM cds WHERE cd.artist = artist.id), genre.name, me.title, me.year
# LIMIT ?
# ) me
# )
# differing in :
# OP [-LITERAL] != [-PAREN] in
# left: me.title
# right: ( SELECT COUNT( * ) FROM cds WHERE cd.artist = artist.id )
#
# Looks like you failed 1 test of 6.
t/resultset/as_subselect_rs.t ....................
Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/6 subtests
t/resultset/bind_attr.t .......................... ok
t/resultset/is_ordered.t ......................... ok
t/resultset/is_paged.t ........................... ok
t/resultset/nulls_only.t ......................... ok
t/resultset/plus_select.t ........................ ok
t/resultset/update_delete.t ...................... ok
t/resultset_class.t .............................. ok
t/resultset_overload.t ........................... ok
t/row/filter_column.t ............................ ok
t/row/find_one_has_many.t ........................ ok
t/row/inflate_result.t ........................... ok
t/row/pkless.t ................................... ok
t/schema/anon.t .................................. ok
t/schema/clone.t ................................. ok
t/search/distinct.t .............................. ok
t/search/preserve_original_rs.t .................. ok
t/search/related_has_many.t ...................... ok
t/search/related_strip_prefetch.t ................ ok
t/search/select_chains.t ......................... ok
t/search/select_chains_unbalanced.t .............. ok
t/search/subquery.t .............................. ok
t/search/void.t .................................. ok
t/sqlmaker/bind_transport.t ...................... ok
t/sqlmaker/core.t ................................ ok
t/sqlmaker/core_quoted.t ......................... ok
t/sqlmaker/limit_dialects/basic.t ................ ok
t/sqlmaker/limit_dialects/custom.t ............... ok
t/sqlmaker/limit_dialects/fetch_first.t .......... ok
t/sqlmaker/limit_dialects/first_skip.t ........... ok
# Failed test 'Pagination with sub-query in ORDER BY works'
# at t/sqlmaker/limit_dialects/generic_subq.t line 170.
# SQL expressions differ
# got: (
# SELECT "me"."id", "baz", "bar"
# FROM (
# SELECT "me"."id", ? AS "baz", ? * ? AS "bar" FROM "books" "me" WHERE ( "source" = ? ) HAVING ?
# ) "me"
# WHERE ( SELECT COUNT(*) FROM "books" "rownum__emulation" WHERE "rownum__emulation"."id" < "me"."id" ) BETWEEN ? AND ?
# ORDER BY "id", ? / ?, ?
# )
# expected: (
# SELECT "me"."id", "bar", "baz"
# FROM (
# SELECT "me"."id", ? * ? AS "bar", ? AS "baz"
# FROM "books" "me"
# WHERE ( "source" = ? )
# HAVING ?
# ) "me"
# WHERE ( SELECT COUNT(*) FROM "books" "rownum__emulation" WHERE "rownum__emulation"."id" < "me"."id" ) BETWEEN ? AND ?
# ORDER BY "id", ? / ?, ?
# )
# differing in :
# [ "baz" ] != [ "bar" ]
# left: "me"."id" "baz" "bar"
# right: "me"."id" "bar" "baz"
#
# BIND values differ
# got: $VAR1 = [
# [
# {},
# 13
# ],
# [
# $VAR1->[0][0],
# 11
# ],
# [
# $VAR1->[0][0],
# 12
# ],
# [
# {
# 'dbic_colname' => 'source',
# 'sqlt_size' => '100',
# 'sqlt_datatype' => 'varchar'
# },
# 'Library'
# ],
# [
# $VAR1->[0][0],
# 21
# ],
# [
# {
# 'sqlt_datatype' => 'integer'
# },
# 3
# ],
# [
# {
# 'sqlt_datatype' => 'integer'
# },
# 6
# ],
# [
# $VAR1->[0][0],
# 1
# ],
# [
# $VAR1->[0][0],
# 2
# ],
# [
# $VAR1->[0][0],
# 3
# ]
# ];
# expected: $VAR1 = [
# [
# {},
# 11
# ],
# [
# $VAR1->[0][0],
# 12
# ],
# [
# $VAR1->[0][0],
# 13
# ],
# [
# {
# 'dbic_colname' => 'source',
# 'sqlt_size' => 100,
# 'sqlt_datatype' => 'varchar'
# },
# 'Library'
# ],
# [
# $VAR1->[0][0],
# 21
# ],
# [
# {
# 'sqlt_datatype' => 'integer'
# },
# 3
# ],
# [
# {
# 'sqlt_datatype' => 'integer'
# },
# 6
# ],
# [
# $VAR1->[0][0],
# 1
# ],
# [
# $VAR1->[0][0],
# 2
# ],
# [
# $VAR1->[0][0],
# 3
# ]
# ];
# Looks like you failed 1 test of 8.
t/sqlmaker/limit_dialects/generic_subq.t .........
Dubious, test returned 1 (wstat 256, 0x100)
Failed 1/8 subtests
t/sqlmaker/limit_dialects/rno.t .................. ok
t/sqlmaker/limit_dialects/rownum.t ............... ok
t/sqlmaker/limit_dialects/skip_first.t ........... ok
t/sqlmaker/limit_dialects/toplimit.t ............. ok
# Failed test 'FetchFirst: Unordered limit with select/group/having'
# at t/sqlmaker/limit_dialects/torture.t line 802.
# SQL expressions differ
# got: (SELECT me.id, owner.id, owner.name, ?, ? * ? FROM books me JOIN owners owner ON owner.id = me.owner WHERE ( ( source != ? AND ( me.title = ? AND source = ? ) ) ) GROUP BY avg(me.id / ?) HAVING ? FETCH FIRST 4 ROWS ONLY)
# expected: (
# SELECT me.id, owner.id, owner.name, ? * ?, ?
# FROM books me
# JOIN owners owner
# ON owner.id = me.owner
# WHERE source != ? AND me.title = ? AND source = ?
# GROUP BY avg(me.id / ?)
# HAVING ?
# FETCH FIRST 4 ROWS ONLY
# )
# differing in :
# OP [-PLACEHOLDER] != [-MISC] in
# left: ?
# right: ? * ?
#
# BIND values differ
# got: $VAR1 = [
# [
# {},
# 13
# ],
# [
# $VAR1->[0][0],
# 11
# ],
# [
# $VAR1->[0][0],
# 12
# ],
# [
# {
# 'sqlt_size' => '100',
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Study'
# ],
# [
# {
# 'sqlt_size' => '100',
# 'dbic_colname' => 'me.title',
# 'sqlt_datatype' => 'varchar'
# },
# 'kama sutra'
# ],
# [
# {
# 'sqlt_size' => '100',
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Library'
# ],
# [
# $VAR1->[0][0],
# 21
# ],
# [
# $VAR1->[0][0],
# 31
# ]
# ];
# expected: $VAR1 = [
# [
# {},
# 11
# ],
# [
# $VAR1->[0][0],
# 12
# ],
# [
# $VAR1->[0][0],
# 13
# ],
# [
# {
# 'sqlt_size' => 100,
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Study'
# ],
# [
# {
# 'sqlt_size' => 100,
# 'dbic_colname' => 'me.title',
# 'sqlt_datatype' => 'varchar'
# },
# 'kama sutra'
# ],
# [
# {
# 'sqlt_size' => 100,
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Library'
# ],
# [
# $VAR1->[0][0],
# 21
# ],
# [
# $VAR1->[0][0],
# 31
# ]
# ];
# Failed test 'FetchFirst: Unordered limit+offset with select/group/having'
# at t/sqlmaker/limit_dialects/torture.t line 809.
# SQL expressions differ
# got: (SELECT me.id, owner__id, owner__name, baz, bar FROM ( SELECT me.id, owner.id AS owner__id, owner.name AS owner__name, ? AS baz, ? * ? AS bar FROM books me JOIN owners owner ON owner.id = me.owner WHERE ( ( source != ? AND ( me.title = ? AND source = ? ) ) ) GROUP BY avg(me.id / ?) HAVING ? ORDER BY me.id FETCH FIRST 7 ROWS ONLY ) me ORDER BY me.id DESC FETCH FIRST 4 ROWS ONLY)
# expected: (
# SELECT me.id, owner__id, owner__name, bar, baz
# FROM (
# SELECT me.id, owner.id AS owner__id, owner.name AS owner__name, ? * ? AS bar, ? AS baz
# FROM books me
# JOIN owners owner
# ON owner.id = me.owner
# WHERE source != ? AND me.title = ? AND source = ?
# GROUP BY avg(me.id / ?)
# HAVING ?
# ORDER BY me.id
# FETCH FIRST 7 ROWS ONLY
# ) me
# ORDER BY me.id DESC
# FETCH FIRST 4 ROWS ONLY
# )
# differing in :
# [ baz ] != [ bar ]
# left: me.id owner__id owner__name baz bar
# right: me.id owner__id owner__name bar baz
#
# BIND values differ
# got: $VAR1 = [
# [
# {},
# 13
# ],
# [
# $VAR1->[0][0],
# 11
# ],
# [
# $VAR1->[0][0],
# 12
# ],
# [
# {
# 'sqlt_size' => '100',
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Study'
# ],
# [
# {
# 'sqlt_size' => '100',
# 'dbic_colname' => 'me.title',
# 'sqlt_datatype' => 'varchar'
# },
# 'kama sutra'
# ],
# [
# {
# 'sqlt_size' => '100',
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Library'
# ],
# [
# $VAR1->[0][0],
# 21
# ],
# [
# $VAR1->[0][0],
# 31
# ]
# ];
# expected: $VAR1 = [
# [
# {},
# 11
# ],
# [
# $VAR1->[0][0],
# 12
# ],
# [
# $VAR1->[0][0],
# 13
# ],
# [
# {
# 'sqlt_size' => 100,
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Study'
# ],
# [
# {
# 'sqlt_size' => 100,
# 'dbic_colname' => 'me.title',
# 'sqlt_datatype' => 'varchar'
# },
# 'kama sutra'
# ],
# [
# {
# 'sqlt_size' => 100,
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Library'
# ],
# [
# $VAR1->[0][0],
# 21
# ],
# [
# $VAR1->[0][0],
# 31
# ]
# ];
# Failed test 'FetchFirst: Ordered limit with select/group/having'
# at t/sqlmaker/limit_dialects/torture.t line 820.
# SQL expressions differ
# got: (SELECT me.id, owner.id, owner.name, ?, ? * ? FROM books me JOIN owners owner ON owner.id = me.owner WHERE ( ( source != ? AND ( me.title = ? AND source = ? ) ) ) GROUP BY avg(me.id / ?) HAVING ? ORDER BY ? / ?, ? FETCH FIRST 4 ROWS ONLY)
# expected: (
# SELECT me.id, owner.id, owner.name, ? * ?, ?
# FROM books me
# JOIN owners owner
# ON owner.id = me.owner
# WHERE source != ? AND me.title = ? AND source = ?
# GROUP BY avg(me.id / ?)
# HAVING ?
# ORDER BY ? / ?, ?
# FETCH FIRST 4 ROWS ONLY
# )
# differing in :
# OP [-PLACEHOLDER] != [-MISC] in
# left: ?
# right: ? * ?
#
# BIND values differ
# got: $VAR1 = [
# [
# {},
# 13
# ],
# [
# $VAR1->[0][0],
# 11
# ],
# [
# $VAR1->[0][0],
# 12
# ],
# [
# {
# 'sqlt_size' => '100',
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Study'
# ],
# [
# {
# 'sqlt_size' => '100',
# 'dbic_colname' => 'me.title',
# 'sqlt_datatype' => 'varchar'
# },
# 'kama sutra'
# ],
# [
# {
# 'sqlt_size' => '100',
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Library'
# ],
# [
# $VAR1->[0][0],
# 21
# ],
# [
# $VAR1->[0][0],
# 31
# ],
# [
# $VAR1->[0][0],
# 1
# ],
# [
# $VAR1->[0][0],
# 2
# ],
# [
# $VAR1->[0][0],
# 3
# ]
# ];
# expected: $VAR1 = [
# [
# {},
# 11
# ],
# [
# $VAR1->[0][0],
# 12
# ],
# [
# $VAR1->[0][0],
# 13
# ],
# [
# {
# 'sqlt_size' => 100,
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Study'
# ],
# [
# {
# 'sqlt_size' => 100,
# 'dbic_colname' => 'me.title',
# 'sqlt_datatype' => 'varchar'
# },
# 'kama sutra'
# ],
# [
# {
# 'sqlt_size' => 100,
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Library'
# ],
# [
# $VAR1->[0][0],
# 21
# ],
# [
# $VAR1->[0][0],
# 31
# ],
# [
# $VAR1->[0][0],
# 1
# ],
# [
# $VAR1->[0][0],
# 2
# ],
# [
# $VAR1->[0][0],
# 3
# ]
# ];
# Failed test 'FetchFirst: Ordered limit+offset with select/group/having'
# at t/sqlmaker/limit_dialects/torture.t line 827.
# SQL expressions differ
# got: (SELECT me.id, owner__id, owner__name, baz, bar FROM ( SELECT me.id, owner__id, owner__name, baz, bar, ORDER__BY__001, ORDER__BY__002 FROM ( SELECT me.id, owner.id AS owner__id, owner.name AS owner__name, ? AS baz, ? * ? AS bar, ? / ? AS ORDER__BY__001, ? AS ORDER__BY__002 FROM books me JOIN owners owner ON owner.id = me.owner WHERE ( ( source != ? AND ( me.title = ? AND source = ? ) ) ) GROUP BY avg(me.id / ?) HAVING ? ORDER BY ? / ?, ? FETCH FIRST 7 ROWS ONLY ) me ORDER BY ORDER__BY__001 DESC, ORDER__BY__002 DESC FETCH FIRST 4 ROWS ONLY ) me ORDER BY ORDER__BY__001, ORDER__BY__002)
# expected: (
# SELECT me.id, owner__id, owner__name, bar, baz
# FROM (
# SELECT me.id, owner__id, owner__name, bar, baz, ORDER__BY__001, ORDER__BY__002
# FROM (
# SELECT me.id, owner.id AS owner__id, owner.name AS owner__name, ? * ? AS bar, ? AS baz, ? / ? AS ORDER__BY__001, ? AS ORDER__BY__002
# FROM books me
# JOIN owners owner
# ON owner.id = me.owner
# WHERE source != ? AND me.title = ? AND source = ?
# GROUP BY avg(me.id / ?)
# HAVING ?
# ORDER BY ? / ?, ?
# FETCH FIRST 7 ROWS ONLY
# ) me
# ORDER BY ORDER__BY__001 DESC, ORDER__BY__002 DESC
# FETCH FIRST 4 ROWS ONLY
# ) me
# ORDER BY ORDER__BY__001, ORDER__BY__002
# )
# differing in :
# [ baz ] != [ bar ]
# left: me.id owner__id owner__name baz bar
# right: me.id owner__id owner__name bar baz
#
# BIND values differ
# got: $VAR1 = [
# [
# {},
# 13
# ],
# [
# $VAR1->[0][0],
# 11
# ],
# [
# $VAR1->[0][0],
# 12
# ],
# [
# $VAR1->[0][0],
# 1
# ],
# [
# $VAR1->[0][0],
# 2
# ],
# [
# $VAR1->[0][0],
# 3
# ],
# [
# {
# 'sqlt_size' => '100',
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Study'
# ],
# [
# {
# 'sqlt_size' => '100',
# 'dbic_colname' => 'me.title',
# 'sqlt_datatype' => 'varchar'
# },
# 'kama sutra'
# ],
# [
# {
# 'sqlt_size' => '100',
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Library'
# ],
# [
# $VAR1->[0][0],
# 21
# ],
# [
# $VAR1->[0][0],
# 31
# ],
# [
# $VAR1->[0][0],
# 1
# ],
# [
# $VAR1->[0][0],
# 2
# ],
# [
# $VAR1->[0][0],
# 3
# ]
# ];
# expected: $VAR1 = [
# [
# {},
# 11
# ],
# [
# $VAR1->[0][0],
# 12
# ],
# [
# $VAR1->[0][0],
# 13
# ],
# [
# $VAR1->[0][0],
# 1
# ],
# [
# $VAR1->[0][0],
# 2
# ],
# [
# $VAR1->[0][0],
# 3
# ],
# [
# {
# 'sqlt_size' => 100,
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Study'
# ],
# [
# {
# 'sqlt_size' => 100,
# 'dbic_colname' => 'me.title',
# 'sqlt_datatype' => 'varchar'
# },
# 'kama sutra'
# ],
# [
# {
# 'sqlt_size' => 100,
# 'dbic_colname' => 'source',
# 'sqlt_datatype' => 'varchar'
# },
# 'Library'
# ],
# [
# $VAR1->[0][0],
# 21
# ],
# [
# $VAR1->[0][0],
# 31
# ],
# [
# $VAR1->[0][0],
# 1
# ],
# [
# $VAR1->[0][0],
# 2
# ],
# [
# $VAR1->[0][0],
# 3
# ]
# ];
# Tests were run but no plan was declared and done_testing() was not seen.
t/sqlmaker/limit_dialects/torture.t ..............
Failed 4/5 subtests
t/sqlmaker/literal_with_bind.t ................... ok
t/sqlmaker/msaccess.t ............................ ok
t/sqlmaker/nest_deprec.t ......................... ok
t/sqlmaker/oracle.t .............................. skipped: Test needs Math::Base36 >= 0.07
t/sqlmaker/oraclejoin.t .......................... skipped: Test needs Math::Base36 >= 0.07
t/sqlmaker/order_by_bindtransport.t .............. ok
t/sqlmaker/order_by_func.t ....................... ok
t/sqlmaker/quotes/quotes.t ....................... ok
t/sqlmaker/quotes/quotes_newstyle.t .............. ok
t/sqlmaker/sqlite.t .............................. ok
t/storage/base.t ................................. ok
t/storage/cursor.t ............................... ok
t/storage/dbh_do.t ............................... ok
t/storage/dbi_coderef.t .......................... ok
t/storage/dbi_env.t .............................. ok
t/storage/dbic_pretty.t .......................... ok
t/storage/debug.t ................................ ok
t/storage/deploy.t ............................... ok
t/storage/disable_sth_caching.t .................. ok
t/storage/error.t ................................ ok
t/storage/exception.t ............................ ok
t/storage/global_destruction.t ................... ok
t/storage/nobindvars.t ........................... ok
t/storage/on_connect_call.t ...................... ok
t/storage/on_connect_do.t ........................ ok
t/storage/ping_count.t ........................... ok
t/storage/quote_names.t .......................... ok
t/storage/reconnect.t ............................ ok
t/storage/replicated.t ........................... ok
t/storage/source_bind_compat.t ................... ok
t/storage/stats.t ................................ ok
t/storage/txn.t .................................. ok
t/storage/txn_scope_guard.t ...................... ok
t/update/all.t ................................... ok
t/update/ident_cond.t ............................ ok
t/update/type_aware.t ............................ ok
t/zzzzzzz_perl_perf_bug.t ........................ skipped: Skipping as system appears to be a smoker
t/zzzzzzz_sqlite_deadlock.t ...................... ok
Test Summary Report
-------------------
t/752sqlite.t (Wstat: 0 Tests: 68 Failed: 0)
TODO passed: 35
t/multi_create/existing_in_chain.t (Wstat: 0 Tests: 10 Failed: 0)
TODO passed: 1-2, 5-6, 10
t/multi_create/reentrance_count.t (Wstat: 0 Tests: 18 Failed: 0)
TODO passed: 1-4, 6-10, 12, 15-16, 18
t/prefetch/multiple_hasmany.t (Wstat: 0 Tests: 10 Failed: 0)
TODO passed: 2, 6-8
t/prefetch/via_search_related.t (Wstat: 0 Tests: 24 Failed: 0)
TODO passed: 21-22
t/resultset/as_subselect_rs.t (Wstat: 256 Tests: 6 Failed: 1)
Failed test: 6
Non-zero exit status: 1
t/row/inflate_result.t (Wstat: 0 Tests: 12 Failed: 0)
TODO passed: 3
t/sqlmaker/limit_dialects/generic_subq.t (Wstat: 256 Tests: 8 Failed: 1)
Failed test: 8
Non-zero exit status: 1
t/sqlmaker/limit_dialects/torture.t (Wstat: 0 Tests: 5 Failed: 4)
Failed tests: 1-4
Parse errors: No plan found in TAP output
Files=276, Tests=22872, 311 wallclock secs ( 8.36 usr 3.63 sys + 275.08 cusr 32.35 csys = 319.42 CPU)
Result: FAIL
Failed 3/276 test programs. 6/22872 subtests failed.
make: *** [test_dynamic] Error 255
------------------------------
PREREQUISITES
------------------------------
Prerequisite modules loaded:
requires:
Module Need Have
------------------------ -------- --------
Class::Accessor::Grouped 0.10007 0.10009
Class::C3::Componentised 1.0009 1.001000
Class::Inspector 1.24 1.28
Class::Method::Modifiers 1.06 1.12
Config::Any 0.20 0.23
Context::Preserve 0.01 0.01
Data::Compare 1.22 1.22
Data::Dumper::Concise 2.020 2.020
Data::Page 2.00 2.02
DBD::SQLite 1.29 1.37
DBI 1.57 1.622
Devel::GlobalDestruction 0 0.09
File::Path 2.07 2.08_01
File::Temp 0.22 0.22
Hash::Merge 0.12 0.12
Module::Find 0.06 0.11
Moo 0.009100 1.000006
MRO::Compat 0.09 0.11
namespace::clean 0.20 0.23
Package::Stash 0.28 0.33
Path::Class 0.18 0.26
perl 5.008001 5.017006
Scope::Guard 0.03 0.20
SQL::Abstract 1.73 1.73
strictures 1.003001 1.004004
Sub::Name 0.04 0.05
Test::Builder 0.94 0.98
Test::Exception 0.31 0.31
Test::More 0.94 0.98
Test::Warn 0.21 0.24
Try::Tiny 0.04 0.11
build_requires:
Module Need Have
------------------------ -------- --------
DBD::SQLite 1.29 1.37
ExtUtils::MakeMaker 6.59 6.63_02
File::Temp 0.22 0.22
Package::Stash 0.28 0.33
Test::Builder 0.94 0.98
Test::Exception 0.31 0.31
Test::More 0.94 0.98
Test::Warn 0.21 0.24
configure_requires:
Module Need Have
------------------------ -------- --------
ExtUtils::MakeMaker 6.59 6.63_02
------------------------------
ENVIRONMENT AND OTHER CONTEXT
------------------------------
Environment variables:
AUTOMATED_TESTING = 1
LANG = en_US.UTF-8
PATH = /home/smoke/perl5/perlbrew/bin:/home/smoke/perl5/perlbrew/perls/perl-blead/bin:/usr/local/bin:/usr/bin:/bin:/usr/games
PATH_WITHOUT_PERLBREW = /usr/local/bin:/usr/bin:/bin:/usr/games
PERL5LIB =
PERL5OPT =
PERL5_CPANPLUS_IS_RUNNING = 8080
PERL5_CPAN_IS_RUNNING = 8080
PERL5_CPAN_IS_RUNNING_IN_RECURSION = 24839,8080
PERLBREW_HOME = /home/smoke/.perlbrew
PERLBREW_MANPATH = /home/smoke/perl5/perlbrew/perls/perl-blead/man
PERLBREW_PATH = /home/smoke/perl5/perlbrew/bin:/home/smoke/perl5/perlbrew/perls/perl-blead/bin
PERLBREW_PERL = perl-blead
PERLBREW_ROOT = /home/smoke/perl5/perlbrew
PERLBREW_VERSION = 0.58
PERL_CR_SMOKER_CURRENT = DBIx-Class-Bootstrap-Simple-0.02
PERL_EXTUTILS_AUTOINSTALL = --defaultdeps
PERL_MM_USE_DEFAULT = 1
SHELL = /bin/bash
TERM = screen
Perl special variables (and OS-specific diagnostics, for MSWin32):
$^X = /home/smoke/perl5/perlbrew/perls/perl-blead/bin/perl5.17.6
$UID/$EUID = 1001 / 1001
$GID = 1001 1001
$EGID = 1001 1001
Perl module toolchain versions installed:
Module Have
------------------- --------
CPAN 1.99_51
CPAN::Meta 2.120921
Cwd 3.39_02
ExtUtils::CBuilder 0.280209
ExtUtils::Command 1.17
ExtUtils::Install 1.58
ExtUtils::MakeMaker 6.63_02
ExtUtils::Manifest 1.62
ExtUtils::ParseXS 3.18
File::Spec 3.39_02
JSON 2.53
JSON::PP 2.27200
Module::Build 0.4003
Module::Signature n/a
Parse::CPAN::Meta 1.4404
Test::Harness 3.25_01
Test::More 0.98
YAML 0.84
YAML::Syck 1.21
version 0.9901
--
Summary of my perl5 (revision 5 version 17 subversion 6) configuration:
Snapshot of: 10ffaf90349dac17b6050fa36821c8d99f5dfb87
Platform:
osname=linux, osvers=2.6.32-5-xen-686, archname=i686-linux-thread-multi-64int
uname='linux prickle 2.6.32-5-xen-686 #1 smp tue jun 1 08:48:09 utc 2010 i686 gnulinux '
config_args='-de -Dprefix=/home/smoke/perl5/perlbrew/perls/perl-blead -Duse64bitint -Dusethreads -Dcc=gcc -Dusedevel'
hint=recommended, useposix=true, d_sigaction=define
useithreads=define, usemultiplicity=define
useperlio=define, d_sfio=undef, uselargefiles=define, usesocks=undef
use64bitint=define, use64bitall=undef, uselongdouble=undef
usemymalloc=n, bincompat5005=undef
Compiler:
cc='gcc', ccflags ='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64',
optimize='-O2',
cppflags='-D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include'
ccversion='', gccversion='4.3.2', gccosandvers=''
intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=12345678
d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12
ivtype='long long', ivsize=8, nvtype='double', nvsize=8, Off_t='off_t', lseeksize=8
alignbytes=4, prototype=define
Linker and Libraries:
ld='gcc', ldflags =' -fstack-protector -L/usr/local/lib'
libpth=/usr/local/lib /lib/../lib /usr/lib/../lib /lib /usr/lib
libs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
perllibs=-lnsl -ldl -lm -lcrypt -lutil -lpthread -lc
libc=/lib/libc-2.11.2.so, so=so, useshrplib=false, libperl=libperl.a
gnulibc_version='2.11.2'
Dynamic Linking:
dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags='-Wl,-E'
cccdlflags='-fPIC', lddlflags='-shared -O2 -L/usr/local/lib -fstack-protector'
Characteristics of this binary (from libperl):
Compile-time options: HAS_TIMES MULTIPLICITY PERLIO_LAYERS
PERL_DONT_CREATE_GVSV PERL_IMPLICIT_CONTEXT
PERL_MALLOC_WRAP PERL_PRESERVE_IVUV PERL_USE_DEVEL
USE_64_BIT_INT USE_ITHREADS USE_LARGE_FILES
USE_LOCALE USE_LOCALE_COLLATE USE_LOCALE_CTYPE
USE_LOCALE_NUMERIC USE_PERLIO USE_PERL_ATOF
USE_REENTRANT_API
Built under linux
Compiled at Nov 17 2012 18:11:18
%ENV:
PERL5LIB=""
PERL5OPT=""
PERL5_CPANPLUS_IS_RUNNING="8080"
PERL5_CPAN_IS_RUNNING="8080"
PERL5_CPAN_IS_RUNNING_IN_RECURSION="24839,8080"
PERLBREW_HOME="/home/smoke/.perlbrew"
PERLBREW_MANPATH="/home/smoke/perl5/perlbrew/perls/perl-blead/man"
PERLBREW_PATH="/home/smoke/perl5/perlbrew/bin:/home/smoke/perl5/perlbrew/perls/perl-blead/bin"
PERLBREW_PERL="perl-blead"
PERLBREW_ROOT="/home/smoke/perl5/perlbrew"
PERLBREW_VERSION="0.58"
PERL_CR_SMOKER_CURRENT="DBIx-Class-Bootstrap-Simple-0.02"
PERL_EXTUTILS_AUTOINSTALL="--defaultdeps"
PERL_MM_USE_DEFAULT="1"
@INC:
/home/smoke/perl5/perlbrew/perls/perl-blead/lib/site_perl/5.17.6/i686-linux-thread-multi-64int
/home/smoke/perl5/perlbrew/perls/perl-blead/lib/site_perl/5.17.6
/home/smoke/perl5/perlbrew/perls/perl-blead/lib/5.17.6/i686-linux-thread-multi-64int
/home/smoke/perl5/perlbrew/perls/perl-blead/lib/5.17.6
.