Re: UDD Bugs data for stable release

[hassaan afridi <afridihassaan@gmail.com>]

Hi Lucas,

Thank you for the reply.

Yes I have got this column in 'bugs' table. 

But when I see 'archived_bugs' table and in that table 'affects_stable',  'affects_unstable',  'affects_testing', all these columns contains the value false(f). So how can I get the archived bugs for stable release only?

Regards

Hassaan Afridi

On Mon, Jul 17, 2017 at 12:31 PM, Lucas Nussbaum <lucas@debian.org> wrote:

Hi,

On 15/07/17 at 19:32 +0200, hassaan afridi wrote:
> Dear Debian Team,
>
> Hi I am working with UDD to get data for my master's thesis. I am just
> wondering is there any way I could get bugs for the packages of stable
> release only.
>
> I could not find any column where I can filtered out the data for stable
> release. Is there any way to do it?

There's no real notion of "bugs for the packages of stable release only"
in Debian. bugs affect ranges of versions of packages, and the version
of a given package in our current stable release can be among those
affected versions or not.

To see if a given bug affects our stable release, you can look at the
'affects_stable' column.

Lucas