The MediaWiki schema description is only valid for the underlying database, you do not have access to that as a labs user - you just have security-sanitised views. rev_text_ids are not useful to you as you cannot access revision texts via the DBs - you must go through the API.
On 1 October 2017 at 04:31, Roy Smith <[email protected]> wrote: > I’ve been exploring the enwiki database. I can find the page row for > [[Iron]] > > MariaDB [enwiki_p]> select page_title from page where page_id = 14734; > +------------+ > | page_title | > +------------+ > | Iron | > +------------+ > > > It looks like it has the right number of revisions: > > MariaDB [enwiki_p]> select count(*) from revision where rev_page = 14734; > +----------+ > | count(*) | > +----------+ > | 5560 | > +----------+ > > > But, all of the rev_text_ids are 0 > > MariaDB [enwiki_p]> select rev_text_id from revision where rev_page = 14734 > and rev_text_id != 0; > Empty set (0.02 sec) > > > The schema description seems pretty straight-forward. What am I not > understanding? > > _______________________________________________ > Cloud mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/cloud > _______________________________________________ Cloud mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/cloud
