Source: libdbix-class-perl Version: 0.08115-1 Severity: serious User: debian...@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 | lu...@lucas-nussbaum.net http://www.lucas-nussbaum.net/ | | jabber: lu...@nussbaum.fr GPG: 1024D/023B3F4F | -- To UNSUBSCRIBE, email to debian-bugs-rc-requ...@lists.debian.org with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org