FreeBSD Bugzilla – Attachment 193050 Details for
Bug 206339
Inconsistent BUG status (Header:In Progress but already Closed)
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
Remember
[x]
|
Forgot Password
Login:
[x]
list_inconsistent_states.pl
list_inconsistent_states.pl (text/plain), 634 bytes, created by
Oleksandr Tymoshenko
on 2018-05-04 20:38:15 UTC
(
hide
)
Description:
list_inconsistent_states.pl
Filename:
MIME Type:
Creator:
Oleksandr Tymoshenko
Created:
2018-05-04 20:38:15 UTC
Size:
634 bytes
patch
obsolete
>#!/usr/local/bin/perl -w > >use lib '.'; > >use strict; >use warnings; >use Bugzilla; >use Bugzilla::Constants; > >my $bugs = Bugzilla->dbh->selectall_arrayref( > "SELECT bug_id, bug_status > FROM bugs > ORDER BY bug_id"); > >foreach my $b (@{$bugs}) { > my $id = $b->[0]; > my $status = $b->[1]; > > my @row = Bugzilla->dbh->selectrow_array( > "SELECT added, id > FROM bugs_activity > WHERE bug_id=$id and fieldid=9 > ORDER BY bug_when DESC, id DESC LIMIT 1"); > if (@row) { > if ($row[0] ne $status) { > print "$id,$row[1],$row[0],$status\n"; > } > } >}
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=193050">View the attachment on a separate page</a>.</b>
View Attachment As Raw
Actions:
View
Attachments on
bug 206339
: 193050 |
193052