Hi all,
I have a script running collecting data in multiple wikipedia(s), I started
to notice that revision table in lbwiki_p has some incorrect data.
Here is an example:
mysql> select rev_id, rev_user, rev_page, rev_deleted, rev_len,
rev_timestamp from revision where rev_id = 185751;
+--------+----------+----------+-------------+---------+----------------+
| rev_id | rev_user | rev_page | rev_deleted | rev_len | rev_timestamp |
+--------+----------+----------+-------------+---------+----------------+
| 185751 | 580 | 83446 | 0 | NULL | 20061203231418 |
+--------+----------+----------+-------------+---------+----------------+
mysql> select rev_id, rev_page, rev_len from revision where rev_page =
83446 and rev_timestamp < 20061203231418;
+--------+----------+---------+
| rev_id | rev_page | rev_len |
+--------+----------+---------+
| 115478 | 83446 | NULL |
| 118003 | 83446 | NULL |
| 118009 | 83446 | NULL |
| 138010 | 83446 | NULL |
+--------+----------+---------+
According to my understanding if a record exist rev_len shouldn't be NULL,
if the revision deleted then rev_deleted should get flag but rev_length
should remain as it is.
Hope someone can look into this, because people who are doing analysis
might end up getting wrong results.
Best;
--
Anuradha Uduwage (Anu)