Bugs search

Bugs search

Useful queries for testing (trixie)

21 bugs found

Generated in 3.748 seconds.

select id, bugs.package, bugs.source, severity, title, last_modified, status, affects_stable, affects_testing, affects_unstable, affects_experimental , coalesce(popcon_src.insts, 0) as popcon, coalesce(testing_autoremovals.removal_time, 0) as autormdate , coalesce(testing_autoremovals.removal_time, 1746556984) as autormtime , coalesce(key_packages.reason, '') as whykey, coalesce(migration_excuses.migration_policy_verdict, '') as britney, migration_excuses.reason as excuse_reason, (migration_excuses.policy_info::json#>>'{age,current-age}')::int as currentage, (migration_excuses.policy_info::json#>>'{age,age-requirement}')::int as agerequirement, (array(select json_array_elements_text(migration_excuses.policy_info::json#>'{rc-bugs,unique-source-bugs}'))) as newbugs, migration_excuses.policy_info , coalesce(mb, '-') as missingbuilds, to_char(lastupload_s,'YYYY-MM-DD') as lastupload
from bugs  left join popcon_src on (bugs.source = popcon_src.source)  left join testing_autoremovals on (bugs.source = testing_autoremovals.source)  left join key_packages on (bugs.source = key_packages.source)  left join migration_excuses on (bugs.source = migration_excuses.item_name)  left join (
        select string_agg(distinct(wannabuild.architecture),', ' order by wannabuild.architecture) mb, source
        from wannabuild
        where distribution='sid'
        and not vancouvered
        and notes='out-of-date'
        and state not in ('Installed')
        group by source
        ) as wb on (bugs.source = wb.source)  left join (
        select max(date) lastupload_s, s1.source
        from sources s1, upload_history uh
        where s1.source = uh.source
        and s1.version = uh.version
        and s1.release='sid'
        group by s1.source
        ) as lu on (bugs.source = lu.source) 
where id in (select id from bugs_rt_affects_testing) and id not in (select id from bugs_rt_affects_unstable) 
and not (id in (select id from bugs_merged_with where id > merged_with)) 
and not ('block' = any(migration_excuses.reason)) 
and policy_info::json#>>'{age,verdict}' != 'PASS' 
and not (migration_policy_verdict in ('PASS', 'PASS_HINTED')) 
and not (bugs.id in (select id from bugs_packages bp, key_packages kp where bp.source = kp.source)) 
AND (severity >= 'serious')
order by last_modified asc