Bug#924683: binnmus for multiarch coinstallability

[Helmut Grohne <helmut@subdivi.de>]

Hi Ivo,

On Sun, Mar 17, 2019 at 10:48:52AM +0100, Ivo De Decker wrote:
> Just out of curiosity:
> 
> What query did you use to generate this list?

This list was generated manually. I started with the dose results from
my cross buildd and filtered for reasons with "skew". That gave me a
list of binary packages + affected source packages. Then I went to
buildd.debian.org and checked which archs needed syncing. Given the low
number, I didn't automate it beyond this.

If you want to sync up packages regularly, I'd expect that a udd query
can produce such a list.

The following query could serve as a starting point:

select pa.package, pa.architecture, pa.version, pb.version, pb.architecture from packages as pa join packages as pb on pa.package = pb.package where pa.release = 'sid' and pb.release = 'sid' and pa.version < pb.version and pa.architecture in ('amd64', 'arm64', 'armel', 'armhf', 'mips', 'mipsel', 'mips64el', 's390x', 'ppc64el', 'i386') and pb.architecture in ('amd64', 'arm64', 'armel', 'armhf', 'mips', 'mipsel', 'mips64el', 's390x', 'ppc64el', 'i386') and (pa.version like '%+b%' or pb.version like '%+b%');

Helmut