Event Timeline
20:18 <Hauskatze> jynus: when I use "describe user" on metawiki_p, the user_editcount field says it's NULLed, but in fact it's not, and should not 20:19 <Hauskatze> https://phabricator.wikimedia.org/P7068
The default value being NULL has nothing to do with us NULLing some fields that are privacy-sensitive. The default value is used when I do something like INSERT INTO user (user_id, user_name,user_real_name) VALUES (15, 'eddiegp', 'Eddie Greiner-Petter'). Because I didn't specify values for user_password, user_newpassword, user_email, ... these fields get the respective "default value" for that column - which is NULL.
I'm not sure what that sentence means ("the Null field" is a bit ambiguous). If you're refering to the integer "0" for user_id, yes, it works the same way (if no user id is specified, 0 will be used).
At the very top of the table there's a Null column. Does your explanation aply to that column as well? Because obviously user_editcount is queriable and not nulled in our replicas as it doesn't contain any private data. Thanks.
Each column in the "user" table is a row in the "describe user" view. The column "Null" in the "describe user" view above describes whether the respective column in the "user" table is allowed to have NULL as a value. It says nothing about whether we're nulling it on the cloud replicas for privacy reasons. You cannot see that from the "describe user" view at all.