Re: New root cause problems?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Argh, I should have known better than to hope that gmail wouldn't
munch the tables.

The category/status table is:

mysql> select all_id.status, substring(rfcq.category, 1, 40) as "Category", count(all_id.status) as "Num" from rfcq, all_id where all_id.docname = rfcq.docname group by all_id.status, rfcq.category;
+-----------+------------------------------------------+-----+
| status    | Category                                 | Num |
+-----------+------------------------------------------+-----+
| active    | INDEPENDENT SUBMISSIONS UNDER RFC EDITOR |   7 |
| expired   | INDEPENDENT SUBMISSIONS UNDER RFC EDITOR |  18 |
| rfc       | IAB DOCUMENTS (by date received)         |   1 |
| rfc       | NON-WORKING GROUP INFORMATIONAL/EXPERIME |  25 |
| rfc       | NON-WORKING GROUP STANDARDS TRACK (by da |  10 |
| rfc       | WORKING GROUP INFORMATIONAL/EXPERIMENTAL |  24 |
| rfc       | WORKING GROUP STANDARDS TRACK (by date r |  56 |
| withdrawn | NON-WORKING GROUP INFORMATIONAL/EXPERIME |   1 |
| iesg      | IAB DOCUMENTS (by date received)         |   1 |
| iesg      | INDEPENDENT SUBMISSIONS UNDER RFC EDITOR |  12 |
| iesg      | NON-WORKING GROUP INFORMATIONAL/EXPERIME |  21 |
| iesg      | NON-WORKING GROUP STANDARDS TRACK (by da |   2 |
| iesg      | WORKING GROUP INFORMATIONAL/EXPERIMENTAL |  47 |
| iesg      | WORKING GROUP STANDARDS TRACK (by date r |  61 |
+-----------+------------------------------------------+-----+
14 rows in set (0.05 sec)

and the date table is:

mysql> select min(all_id.lastup) as "Updated", substring(rfcq.category, 1, 50) as "Category" from rfcq, all_id where all_id.docname = rfcq.docname and all_id.status != 'rfc' group by rfcq.category;
+------------+----------------------------------------------------+
| Updated    | Category                                           |
+------------+----------------------------------------------------+
| 2004-10-22 | IAB DOCUMENTS (by date received)                   |
| 2003-07-01 | INDEPENDENT SUBMISSIONS UNDER RFC EDITOR REVIEW  ( |
| 2001-07-24 | NON-WORKING GROUP INFORMATIONAL/EXPERIMENTAL/BCP ( |
| 2004-10-01 | NON-WORKING GROUP STANDARDS TRACK (by date receive |
| 2002-10-11 | WORKING GROUP INFORMATIONAL/EXPERIMENTAL/BCP (by d |
| 2002-09-11 | WORKING GROUP STANDARDS TRACK (by date received)   |
+------------+----------------------------------------------------+
6 rows in set (0.04 sec)

  Bill

_______________________________________________

Ietf@xxxxxxxx
https://www1.ietf.org/mailman/listinfo/ietf

[Index of Archives]     [IETF Annoucements]     [IETF]     [IP Storage]     [Yosemite News]     [Linux SCTP]     [Linux Newbies]     [Fedora Users]