Bug#569408: libdbix-class-perl: FTBFS: tests failed
Lucas Nussbaum
lucas at lucas-nussbaum.net
Thu Feb 11 19:01:04 UTC 2010
Source: libdbix-class-perl
Version: 0.08115-1
Severity: serious
User: debian-qa at lists.debian.org
Usertags: qa-ftbfs-20100211 qa-ftbfs
Justification: FTBFS on amd64
Hi,
During a rebuild of all packages in sid, your package failed to build on
amd64.
Relevant part:
> make[2]: Entering directory `/build/user-libdbix-class-perl_0.08115-1-amd64-OWpTgm/libdbix-class-perl-0.08115'
> PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'inc', 'blib/lib', 'blib/arch')" t/*.t t/bind/*.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/schema/*.t t/search/*.t t/sqlahacks/limit_dialects/*.t t/sqlahacks/quotes/*.t t/sqlahacks/sql_maker/*.t t/storage/*.t t/update/*.t
> t/02pod.t ........................................ ok
> t/03podcoverage.t ................................ ok
> t/04dont_break_c3.t .............................. ok
> t/05components.t ................................. ok
> t/100extra_source.t .............................. ok
> t/100populate.t .................................. ok
> t/101populate_rs.t ............................... ok
> t/102load_classes.t .............................. ok
> t/103many_to_many_warning.t ...................... ok
> t/104view.t ...................................... ok
> t/18insert_default.t ............................. ok
> t/20setuperrors.t ................................ ok
> t/26dumper.t ..................................... ok
> t/30dbicplain.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/40resultsetmanager.t ........................... ok
> t/41orrible.t .................................... ok
> t/46where_attribute.t ............................ ok
> t/50fork.t ....................................... skipped: Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test (note: creates and drops a table named artist!)
> t/51threads.t .................................... skipped: Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test (note: creates and drops a table named artist!)
> t/51threadtxn.t .................................. skipped: Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test (note: creates and drops a table named artist!)
> t/52cycle.t ...................................... ok
> t/54taint.t ...................................... ok
> t/55storage_stress.t ............................. skipped: This test needs some non-sqlite connect info!
> t/60core.t ....................................... ok
> t/61findnot.t .................................... ok
> t/63register_class.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/73oracle.t ..................................... skipped: Set $ENV{DBICTEST_ORA_DSN}, _USER and _PASS to run this test. Warning: This test drops and creates tables called 'artist', 'cd', 'track' and 'sequence_test' as well as following sequences: 'pkid1_seq', 'pkid2_seq' and 'nonpkid_seq'
> 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
> t/747mssql_ado.t ................................. skipped: Set $ENV{DBICTEST_MSSQL_ADO_DSN}, _USER and _PASS to run this test
> t/74mssql.t ...................................... skipped: Set $ENV{DBICTEST_MSSQL_DSN}, _USER and _PASS to run this test
> t/75limit.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/81transactions.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/89dbicadmin.t .................................. ok
> t/90ensure_class_loaded.t ........................ ok
> t/90join_torture.t ............................... ok
> t/91merge_attr.t ................................. ok
>
> # Failed test 'expected sql with casting on'
> # at t/93autocast.t line 65.
> # SQL expressions differ
> # got: (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me LEFT JOIN track tracks ON tracks.cd = me.cdid WHERE ( ( cdid > CAST(? AS INT) AND tracks.last_updated_at IS NOT NULL AND tracks.last_updated_on < CAST(? AS DateTime) AND tracks.position = ? AND tracks.single_track = CAST(? AS INT) ) ))
> # expected: (
> # SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track
> # FROM cd me
> # LEFT JOIN track tracks ON tracks.cd = me.cdid
> # WHERE
> # cdid > CAST(? AS INT)
> # AND tracks.last_updated_at IS NOT NULL
> # AND tracks.last_updated_on < CAST (? AS yyy)
> # AND tracks.position = ?
> # AND tracks.single_track = CAST(? AS INT)
> # )
> # differing in :
> # [ CAST (? AS DateTime) ] != [ CAST (? AS yyy) ]
> #
> # Looks like you failed 1 test of 2.
> t/93autocast.t ...................................
> Dubious, test returned 1 (wstat 256, 0x100)
> Failed 1/2 subtests
> t/93nobindvars.t ................................. skipped: Set $ENV{DBICTEST_MYSQL_DSN}, _USER and _PASS to run this test
> 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 DBICTEST_(PG|MYSQL)_DSN _USER and _PASS if you want to run savepoint tests
> t/99dbic_sqlt_parser.t ........................... ok
>
> # Failed test 'got correct SQL'
> # at t/bind/attribute.t line 77.
> # SQL expressions differ
> # got: (SELECT me.artistid, me.name, me.rank, me.charfield FROM ( SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year
> # FROM artist a
> # JOIN cd ON cd.artist = a.artistid
> # WHERE cd.year = ?)
> # me WHERE ( title LIKE ? ))
> # expected: (SELECT me.artistid, me.name, me.rank, me.charfield FROM (SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year FROM artist a JOIN cd ON cd.artist = a.artistid WHERE cd.year = ?) WHERE title LIKE ?)
> # differing in :
> # left: (SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year FROM artist a JOIN cd ON cd.artist = a.artistid WHERE cd.year = ?) me
> # right: (SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year FROM artist a JOIN cd ON cd.artist = a.artistid WHERE cd.year = ?)
> #
>
> # Failed test 'got correct SQL (cookbook arbitrary SQL, in separate file)'
> # at t/bind/attribute.t line 106.
> # SQL expressions differ
> # got: (SELECT me.artistid, me.name, me.rank, me.charfield FROM ( SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year
> # FROM artist a
> # JOIN cd ON cd.artist = a.artistid
> # WHERE cd.year = ?)
> # me WHERE ( title LIKE ? ))
> # expected: (SELECT me.artistid, me.name, me.rank, me.charfield FROM (SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year FROM artist a JOIN cd ON cd.artist = a.artistid WHERE cd.year = ?) WHERE title LIKE ?)
> # differing in :
> # left: (SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year FROM artist a JOIN cd ON cd.artist = a.artistid WHERE cd.year = ?) me
> # right: (SELECT a.*, cd.cdid AS cdid, cd.title AS title, cd.year AS year FROM artist a JOIN cd ON cd.artist = a.artistid WHERE cd.year = ?)
> #
> # Looks like you failed 2 tests of 13.
> t/bind/attribute.t ...............................
> Dubious, test returned 2 (wstat 512, 0x200)
> Failed 2/13 subtests
> t/bind/bindtype_columns.t ........................ skipped: Set $ENV{DBICTEST_PG_DSN}, _USER and _PASS to run this test
> t/bind/order_by.t ................................ ok
> t/cdbi/01-columns.t .............................. ok
> t/cdbi/02-Film.t ................................. ok
> t/cdbi/03-subclassing.t .......................... ok
> t/cdbi/04-lazy.t ................................. ok
> t/cdbi/06-hasa.t ................................. ok
> t/cdbi/08-inheritcols.t .......................... ok
> t/cdbi/09-has_many.t ............................. ok
> t/cdbi/11-triggers.t ............................. ok
> t/cdbi/12-filter.t ............................... ok
> t/cdbi/13-constraint.t ........................... ok
> t/cdbi/14-might_have.t ........................... ok
> t/cdbi/15-accessor.t ............................. ok
> t/cdbi/16-reserved.t ............................. ok
> t/cdbi/18-has_a.t ................................ ok
> t/cdbi/19-set_sql.t .............................. ok
> t/cdbi/21-iterator.t ............................. ok
> t/cdbi/22-deflate_order.t ........................ skipped: Need MySQL for this test
> t/cdbi/22-self_referential.t ..................... ok
> t/cdbi/23-cascade.t .............................. ok
> t/cdbi/24-meta_info.t ............................ ok
> t/cdbi/26-mutator.t .............................. ok
> t/cdbi/30-pager.t ................................ ok
> t/cdbi/68-inflate_has_a.t ........................ ok
> t/cdbi/98-failure.t .............................. ok
> t/cdbi/abstract/search_where.t ................... ok
> t/cdbi/columns_as_hashes.t ....................... ok
> t/cdbi/columns_dont_override_custom_accessors.t .. ok
> t/cdbi/construct.t ............................... ok
> t/cdbi/copy.t .................................... ok
> t/cdbi/DeepAbstractSearch/01_search.t ............ skipped: needs Class::DBI::Plugin::DeepAbstractSearch
> t/cdbi/early_column_heisenbug.t .................. ok
> t/cdbi/has_many_loads_foreign_class.t ............ ok
> t/cdbi/hasa_without_loading.t .................... ok
> t/cdbi/max_min_value_of.t ........................ ok
> t/cdbi/mk_group_accessors.t ...................... ok
> t/cdbi/multi_column_set.t ........................ ok
> t/cdbi/object_cache.t ............................ ok
> t/cdbi/retrieve_from_sql_with_limit.t ............ ok
> t/cdbi/set_to_undef.t ............................ ok
> t/cdbi/set_vs_DateTime.t ......................... ok
> t/cdbi/sweet/08pager.t ........................... ok
> t/count/count_rs.t ............................... ok
> t/count/distinct.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/m2m.t ................................... ok
> t/delete/related.t ............................... ok
> t/discard_changes_in_DESTROY.t ................... ok
>
> # Failed test at t/from_subquery.t line 21.
> # SQL expressions differ
> # got: (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( artist_id IN ( SELECT id FROM artist me LIMIT 1 ) ))
> # expected: (SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track FROM cd me WHERE artist_id IN ( SELECT id FROM artist me LIMIT 1 ))
> # differing in :
> # [ me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track ] != [ me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track ]
> #
>
> # Failed test at t/from_subquery.t line 74.
> # SQL expressions differ
> # got: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( id > ? )) cd2)
> # expected: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track FROM cd me WHERE ( id > ? ) ) cd2)
> # differing in :
> # [ me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track ] != [ me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track ]
> #
>
> # Failed test at t/from_subquery.t line 120.
> # SQL expressions differ
> # got: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT cd3.cdid, cd3.artist, cd3.title, cd3.year, cd3.genreid, cd3.single_track FROM (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( id < ? )) cd3 WHERE ( id > ? )) cd2)
> # expected: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track
> # FROM
> # (SELECT cd3.cdid,cd3.artist,cd3.title,cd3.year,cd3.genreid,cd3.single_track
> # FROM
> # (SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track
> # FROM cd me WHERE ( id < ? ) ) cd3
> # WHERE ( id > ? ) ) cd2)
> # differing in :
> # [ cd3.cdid, cd3.artist, cd3.title, cd3.year, cd3.genreid, cd3.single_track ] != [ cd3.cdid,cd3.artist,cd3.title,cd3.year,cd3.genreid,cd3.single_track ]
> #
>
> # Failed test at t/from_subquery.t line 164.
> # SQL expressions differ
> # got: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( title = ? )) cd2)
> # expected: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track FROM cd me WHERE ( title = ? ) ) cd2)
> # differing in :
> # [ me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track ] != [ me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track ]
> #
> # Looks like you failed 4 tests of 8.
> t/from_subquery.t ................................
> Dubious, test returned 4 (wstat 1024, 0x400)
> Failed 4/8 subtests
> t/inflate/core.t ................................. ok
> t/inflate/datetime.t ............................. ok
> t/inflate/datetime_determine_parser.t ............ ok
> t/inflate/datetime_mssql.t ....................... skipped: Set $ENV{DBICTEST_MSSQL_ODBC_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_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/prefetch/attrs_untouched.t ..................... ok
> t/prefetch/count.t ............................... ok
> t/prefetch/diamond.t ............................. ok
> t/prefetch/double_prefetch.t ..................... ok
>
> # Failed test 'next() query generated expected SQL'
> # at t/prefetch/grouped.t line 99.
> # SQL expressions differ
> # got: (SELECT me.cd, me.track_count, cd.cdid, cd.artist, cd.title, cd.year, cd.genreid, cd.single_track FROM (SELECT me.cd, COUNT( me.trackid ) AS track_count FROM track me JOIN cd cd ON cd.cdid = me.cd WHERE ( me.cd IN ( ?, ?, ?, ?, ? ) ) GROUP BY me.cd) me JOIN cd cd ON cd.cdid = me.cd WHERE ( me.cd IN ( ?, ?, ?, ?, ? ) ))
> # expected: (
> # SELECT me.cd, me.track_count, cd.cdid, cd.artist, cd.title, cd.year, cd.genreid, cd.single_track
> # FROM (
> # SELECT me.cd, COUNT (me.trackid) AS track_count,
> # FROM track me
> # JOIN cd cd ON cd.cdid = me.cd
> # WHERE ( me.cd IN ( ?, ?, ?, ?, ? ) )
> # GROUP BY me.cd
> # ) as me
> # JOIN cd cd ON cd.cdid = me.cd
> # WHERE ( me.cd IN ( ?, ?, ?, ?, ? ) )
> # )
> # differing in :
> # [ me.cd, COUNT (me.trackid) AS track_count ] != [ me.cd, COUNT (me.trackid) AS track_count, ]
> #
>
> # Failed test 'next() query generated expected SQL'
> # at t/prefetch/grouped.t line 162.
> # SQL expressions differ
> # got: (SELECT me.cdid, me.track_count, me.maxtr, tracks.trackid, tracks.cd, tracks.position, tracks.title, tracks.last_updated_on, tracks.last_updated_at, tracks.small_dt, liner_notes.liner_id, liner_notes.notes FROM (SELECT me.cdid, COUNT( tracks.trackid ) AS track_count, MAX( tracks.trackid ) AS maxtr FROM cd me LEFT JOIN track tracks ON tracks.cd = me.cdid WHERE ( me.cdid IS NOT NULL ) GROUP BY me.cdid ORDER BY track_count DESC, maxtr ASC LIMIT 2) me LEFT JOIN track tracks ON tracks.cd = me.cdid LEFT JOIN liner_notes liner_notes ON liner_notes.liner_id = me.cdid WHERE ( me.cdid IS NOT NULL ) ORDER BY track_count DESC, maxtr ASC, tracks.cd)
> # expected: (
> # SELECT me.cdid, me.track_count, me.maxtr,
> # tracks.trackid, tracks.cd, tracks.position, tracks.title, tracks.last_updated_on, tracks.last_updated_at, tracks.small_dt,
> # liner_notes.liner_id, liner_notes.notes
> # FROM (
> # SELECT me.cdid, COUNT( tracks.trackid ) AS track_count, MAX( tracks.trackid ) AS maxtr,
> # FROM cd me
> # LEFT JOIN track tracks ON tracks.cd = me.cdid
> # WHERE ( me.cdid IS NOT NULL )
> # GROUP BY me.cdid
> # ORDER BY track_count DESC, maxtr ASC
> # LIMIT 2
> # ) me
> # LEFT JOIN track tracks ON tracks.cd = me.cdid
> # LEFT JOIN liner_notes liner_notes ON liner_notes.liner_id = me.cdid
> # WHERE ( me.cdid IS NOT NULL )
> # ORDER BY track_count DESC, maxtr ASC, tracks.cd
> # )
> # differing in :
> # [ me.cdid, COUNT (tracks.trackid) AS track_count, MAX (tracks.trackid) AS maxtr ] != [ me.cdid, COUNT (tracks.trackid) AS track_count, MAX (tracks.trackid) AS maxtr, ]
> #
> # Looks like you failed 2 tests of 44.
> t/prefetch/grouped.t .............................
> Dubious, test returned 2 (wstat 512, 0x200)
> Failed 2/44 subtests
> t/prefetch/incomplete.t .......................... ok
> t/prefetch/join_type.t ........................... ok
> t/prefetch/multiple_hasmany.t .................... ok
> t/prefetch/standard.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/doesnt_exist.t .................... ok
> t/relationship/update_or_create_multi.t .......... ok
> t/relationship/update_or_create_single.t ......... ok
> t/resultset/as_query.t ........................... ok
> t/resultset/is_paged.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/schema/clone.t ................................. ok
> t/search/preserve_original_rs.t .................. ok
>
> # Failed test 'Testcase 1, pass 1'
> # at t/search/subquery.t line 155.
> # SQL expressions differ
> # got: (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( title = ? AND year LIKE ? ) LIMIT 5)
> # expected: ( SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track FROM cd me WHERE (title = ? AND year LIKE ?) LIMIT 5)
> # differing in :
> # [ me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track ] != [ me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track ]
> #
>
> # Failed test 'Testcase 1, pass 2'
> # at t/search/subquery.t line 155.
> # SQL expressions differ
> # got: (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( title = ? AND year LIKE ? ) LIMIT 5)
> # expected: ( SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track FROM cd me WHERE (title = ? AND year LIKE ?) LIMIT 5)
> # differing in :
> # [ me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track ] != [ me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track ]
> #
>
> # Failed test 'Testcase 2, pass 1'
> # at t/search/subquery.t line 155.
> # SQL expressions differ
> # got: (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( artist_id IN ( SELECT id FROM artist me LIMIT 1 ) ))
> # expected: ( SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track FROM cd me WHERE artist_id IN ( SELECT id FROM artist me LIMIT 1 ) )
> # differing in :
> # [ me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track ] != [ me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track ]
> #
>
> # Failed test 'Testcase 2, pass 2'
> # at t/search/subquery.t line 155.
> # SQL expressions differ
> # got: (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( artist_id IN ( SELECT id FROM artist me LIMIT 1 ) ))
> # expected: ( SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track FROM cd me WHERE artist_id IN ( SELECT id FROM artist me LIMIT 1 ) )
> # differing in :
> # [ me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track ] != [ me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track ]
> #
>
> # Failed test 'Testcase 5, pass 1'
> # at t/search/subquery.t line 155.
> # SQL expressions differ
> # got: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( id > ? )) cd2)
> # expected: ( SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track FROM cd me WHERE id > ?) cd2 )
> # differing in :
> # [ me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track ] != [ me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track ]
> #
>
> # Failed test 'Testcase 5, pass 2'
> # at t/search/subquery.t line 155.
> # SQL expressions differ
> # got: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( id > ? )) cd2)
> # expected: ( SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track FROM cd me WHERE id > ?) cd2 )
> # differing in :
> # [ me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track ] != [ me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track ]
> #
>
> # Failed test 'Testcase 7, pass 1'
> # at t/search/subquery.t line 155.
> # SQL expressions differ
> # got: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT cd3.cdid, cd3.artist, cd3.title, cd3.year, cd3.genreid, cd3.single_track FROM (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( id < ? )) cd3 WHERE ( id > ? )) cd2)
> # expected: ( SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track
> # FROM
> # (SELECT cd3.cdid,cd3.artist,cd3.title,cd3.year,cd3.genreid,cd3.single_track
> # FROM
> # (SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track
> # FROM cd me WHERE id < ?) cd3
> # WHERE id > ?) cd2
> # )
> # differing in :
> # [ cd3.cdid, cd3.artist, cd3.title, cd3.year, cd3.genreid, cd3.single_track ] != [ cd3.cdid,cd3.artist,cd3.title,cd3.year,cd3.genreid,cd3.single_track ]
> #
>
> # Failed test 'Testcase 7, pass 2'
> # at t/search/subquery.t line 155.
> # SQL expressions differ
> # got: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT cd3.cdid, cd3.artist, cd3.title, cd3.year, cd3.genreid, cd3.single_track FROM (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( id < ? )) cd3 WHERE ( id > ? )) cd2)
> # expected: ( SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track
> # FROM
> # (SELECT cd3.cdid,cd3.artist,cd3.title,cd3.year,cd3.genreid,cd3.single_track
> # FROM
> # (SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track
> # FROM cd me WHERE id < ?) cd3
> # WHERE id > ?) cd2
> # )
> # differing in :
> # [ cd3.cdid, cd3.artist, cd3.title, cd3.year, cd3.genreid, cd3.single_track ] != [ cd3.cdid,cd3.artist,cd3.title,cd3.year,cd3.genreid,cd3.single_track ]
> #
>
> # Failed test 'Testcase 9, pass 1'
> # at t/search/subquery.t line 155.
> # SQL expressions differ
> # got: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( title = ? )) cd2)
> # expected: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track FROM cd me WHERE title = ?) cd2)
> # differing in :
> # [ me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track ] != [ me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track ]
> #
>
> # Failed test 'Testcase 9, pass 2'
> # at t/search/subquery.t line 155.
> # SQL expressions differ
> # got: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( title = ? )) cd2)
> # expected: (SELECT cd2.cdid, cd2.artist, cd2.title, cd2.year, cd2.genreid, cd2.single_track FROM (SELECT me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track FROM cd me WHERE title = ?) cd2)
> # differing in :
> # [ me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track ] != [ me.cdid,me.artist,me.title,me.year,me.genreid,me.single_track ]
> #
> # Looks like you failed 10 tests of 18.
> t/search/subquery.t ..............................
> Dubious, test returned 10 (wstat 2560, 0xa00)
> Failed 10/18 subtests
>
> # Failed test at t/sqlahacks/limit_dialects/toplimit.t line 46.
> # SQL expressions differ
> # got: ( SELECT me__id, source, owner, title, price, owner__id, name FROM ( SELECT TOP 1 me__id, source, owner, title, price, owner__id, name FROM ( SELECT TOP 4 me.id AS me__id, me.source, me.owner, me.title, me.price, owner.id AS owner__id, owner.name FROM books me JOIN owners owner ON owner.id = me.owner WHERE ( source = ? ) ORDER BY foo ASC, bar ASC ) me ORDER BY foo DESC, bar DESC ) me ORDER BY foo, bar )
> # expected: (SELECT
> # me__id, source, owner, title, price, owner__id, name FROM
> # (SELECT
> # TOP 1 me__id, source, owner, title, price, owner__id, name FROM
> # (SELECT
> # TOP 4 me.id AS me__id, me.source, me.owner, me.title, me.price, owner.id AS owner__id, owner.name FROM
> # books me
> # JOIN owners owner ON owner.id = me.owner
> # WHERE ( source = ? )
> # ORDER BY foo ASC,bar ASC
> # ) me ORDER BY foo DESC, bar DESC
> # ) me ORDER BY foo, bar
> # )
> # differing in :
> # [ foo ASC, bar ASC ] != [ foo ASC,bar ASC ]
> #
> # Looks like you failed 1 test of 13.
> t/sqlahacks/limit_dialects/toplimit.t ............
> Dubious, test returned 1 (wstat 256, 0x100)
> Failed 1/13 subtests
> t/sqlahacks/quotes/quotes.t ...................... ok
> t/sqlahacks/quotes/quotes_newstyle.t ............. ok
> t/sqlahacks/sql_maker/sql_maker.t ................ ok
>
> # Failed test 'got correct SQL and bind parameters for complex select query with quoting'
> # at t/sqlahacks/sql_maker/sql_maker_quote.t line 56.
> # SQL expressions differ
> # got: SELECT `me`.`cdid`, COUNT( `tracks`.`cd` ), MIN( `me`.`year` ) AS me.minyear FROM `cd` `me` JOIN `artist` `artist` ON `artist`.`artistid` = `me`.`artist` LEFT JOIN `tracks` `tracks` ON `tracks`.`cd` = `me`.`cdid` WHERE ( ( `artist`.`name` = ? AND `me`.`year` = ? ) )
> # expected:
> # SELECT `me`.`cdid`, COUNT( `tracks`.`cd` ), MIN( `me`.`year` ) AS `me`.`minyear`
> # FROM `cd` `me`
> # JOIN `artist` `artist` ON ( `artist`.`artistid` = `me`.`artist` )
> # LEFT JOIN `tracks` `tracks` ON ( `tracks`.`cd` = `me`.`cdid` )
> # WHERE ( `artist`.`name` = ? AND `me`.`year` = ? )
> #
> # differing in :
> # [ `me`.`cdid`, COUNT (`tracks`.`cd`) , MIN (`me`.`year`) AS me.minyear ] != [ `me`.`cdid`, COUNT (`tracks`.`cd`) , MIN (`me`.`year`) AS `me`.`minyear` ]
> #
>
> # Failed test 'got correct SQL and bind parameters for count query with bracket quoting'
> # at t/sqlahacks/sql_maker/sql_maker_quote.t line 336.
> # SQL expressions differ
> # got: SELECT MAX( [rank] ) AS max_rank, [rank], COUNT( * ) AS cnt FROM [cd] [me] JOIN [artist] [artist] ON [artist].[artistid] = [me].[artist] WHERE ( ( [artist].[name] = ? AND [me].[year] = ? ) )
> # expected: SELECT MAX ( [rank] ) AS [max_rank], [rank], COUNT( * ) AS [cnt] FROM [cd] [me] JOIN [artist] [artist] ON ( [artist].[artistid] = [me].[artist] ) WHERE ( [artist].[name] = ? AND [me].[year] = ? )
> # differing in :
> # [ MAX ([rank]) AS max_rank, [rank], COUNT (*) AS cnt ] != [ MAX ([rank]) AS [max_rank], [rank], COUNT (*) AS [cnt] ]
> #
> # Looks like you failed 2 tests of 14.
> t/sqlahacks/sql_maker/sql_maker_quote.t ..........
> Dubious, test returned 2 (wstat 512, 0x200)
> Failed 2/14 subtests
> t/storage/base.t ................................. ok
> t/storage/dbh_do.t ............................... ok
> t/storage/dbi_coderef.t .......................... ok
>
> # Failed test 'got correct SQL with all bind parameters (debugcb)'
> # at t/storage/debug.t line 58.
> # SQL expressions differ
> # got: SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( ( artist = ? AND ( cdid BETWEEN ? AND ? ) ) )
> # expected: SELECT me.cdid, me.artist, me.title, me.year, me.genreid, me.single_track FROM cd me WHERE ( artist = ? AND (cdid BETWEEN ? AND ?) ): '1', '1', '3'
> # differing in :
> # left: artist = ? AND (cdid BETWEEN ? AND ?)
> # right: (artist = ? AND (cdid BETWEEN ? AND ?)) : '1', '1', '3'
> #
> # Looks like you failed 1 test of 7.
> t/storage/debug.t ................................
> Dubious, test returned 1 (wstat 256, 0x100)
> Failed 1/7 subtests
> t/storage/disable_sth_caching.t .................. ok
> t/storage/error.t ................................ ok
> t/storage/exception.t ............................ ok
> t/storage/on_connect_call.t ...................... ok
> t/storage/on_connect_do.t ........................ ok
> t/storage/ping_count.t ........................... ok
> t/storage/reconnect.t ............................ ok
> # Using Moose version 0.97 and MooseX::Types version 0.21
> Deep recursion on subroutine "DBIx::Class::Storage::DBI::Replicated::Replicant::debugobj" at /build/user-libdbix-class-perl_0.08115-1-amd64-OWpTgm/libdbix-class-perl-0.08115/blib/lib/DBIx/Class/Storage/DBI/Replicated.pm line 758.
> Deep recursion on subroutine "DBIx::Class::Storage::DBI::Replicated::debugobj" at /build/user-libdbix-class-perl_0.08115-1-amd64-OWpTgm/libdbix-class-perl-0.08115/blib/lib/DBIx/Class/Storage/DBI/Replicated/Replicant.pm line 69.
> make: make[1]: make[2]: E: *** [build] Terminated
> Caught signal 'Terminated': terminating immediately
> *** [test_dynamic] Terminated
> *** [override_dh_auto_test] Terminated
> Build killed with signal TERM after 74 minutes of inactivity
> ────────────────────────────────────────────────────────────────────────────────
> Build finished at 20100211-1754
The full build log is available from:
http://people.debian.org/~lucas/logs/2010/02/11/libdbix-class-perl_0.08115-1_lsid64.buildlog
A list of current common problems and possible solutions is available at
http://wiki.debian.org/qa.debian.org/FTBFS . You're welcome to contribute!
About the archive rebuild: The rebuild was done on about 50 AMD64 nodes
of the Grid'5000 platform, using a clean chroot. Internet was not
accessible from the build systems.
--
| Lucas Nussbaum
| lucas at lucas-nussbaum.net http://www.lucas-nussbaum.net/ |
| jabber: lucas at nussbaum.fr GPG: 1024D/023B3F4F |
More information about the pkg-perl-maintainers
mailing list