The work from T389026: Rethink rev_sha1 field will remove revision.rev_sha1 from MariaDB.
This field is currently used to compute identity-reverts in the `mediawiki_history` dataset.
The value can still be computed using content-slots-sha1 available in the `content` table (to be accessed from the `revision` table with a join to the `slots` table and then the `content` table).
As written in [[ https://phabricator.wikimedia.org/T405641#11226440 | this comment ]], an implementation of the sha1 value using content-slots-sha1 is easy.
As written in [[ https://phabricator.wikimedia.org/T405641#11226440 | this comment ]], an implementation of the sha1 value using content-slots-sha1 is easy,n analysis of the code shows that the slot-order is made on the slot-role (alphabetical). but we need a confirmation on the ordering of the slots.