Re: Outdated leaf packages to be removed
Hi,
On Mon, Jan 27, 2014 at 01:43:08AM +0100, Michael Banck wrote:
> > Maybe a way to avoid the (few) cases where linux/i386 is lagging behind
> > (due to FTBFS) could be running it against amd64 as well, and not
> > considering the sources not appearing in both.
Those are the ones which get dropped in that case, if I got the query
right:
- chocolate-doom | 2.0.0-1 | 1.7.0-3
- feh | 2.9.3-1 | 2.3-2
- fldigi | 3.21.77-2 | 3.21.77-1
- gcc-mingw-w64 | 4.8.2-12+12 | 4.8.2-11+12
- gromacs | 4.5.5-2 | 4.6.5-1
- haskell-yesod-form | 1.3.0.1-1+b10 | 1.3.0.1-1+b11
- json-wheel | 1.0.6-2+b12 | 1.0.6-2+b10
- juman | 7.0-1.1 | 7.0-3
- lhasa | 0.2.0+git-1 | 0.0.7-2
- libgwenhywfar | 4.10.0beta-1 | 4.9.0beta-1
- libkexiv2 | 4:4.11.5-1 | 4:4.11.3-2
- nettoe | 1.5-1 | 1.4.2-1
- python-libdiscid | 0.4.1-1 | 0.4-1
- rasqal | 0.9.31-3 | 0.9.31-2
- ruby-rmagick | 2.13.2-2 | 2.13.1-6
- uc-echo | 1.12-4 | 1.12-3
- xserver-xorg-video-qxl | 0.1.1-1 | 0.1.0-2.1
This is the new query, again really clumsy:
SELECT DISTINCT b1.source,
b1.binver AS hurdver,
b2.binver AS version
FROM any_associations_source b1,
any_associations_source b2,
any_associations_source b3,
binaries b4
WHERE b1.source = b2.source
AND b2.source = b3.source
AND b1.package = b2.package
AND b2.package = b3.package
AND b2.bin = b4.id
AND b1.architecture = 4
AND b2.architecture = 7
AND b3.architecture = 16
AND b1.suite = 5
AND b2.suite = 5
AND b3.suite = 5
AND b1.binver <> b2.binver
AND b2.binver = b3.binver
AND b1.binver < b2.binver
AND b1.binver !~ 'b.$'
AND b2.binver !~ 'b.$'
AND b3.binver !~ 'b.$'
AND b4.install_date < CURRENT_DATE - interval '10 days'
ORDER BY SOURCE;
Michael
Reply to: