[Labs-l] User registration time is NULL

[Tim Landscheidt]

Damian Zaremba <damian at damianzaremba.co.uk> wrote:

> Around 6 hours ago it appears the user_registration column
> on the enwiki_p users table was NULL'd.

> Is there any reason for this? The column previously
> contained the registration time for users.

> MariaDB [enwiki_p]> SELECT `user_registration` FROM `user`
> WHERE `user_registration` != NULL;
> Empty set (6.71 sec)

> The toolserver contains this information and labs had done
> up until around 07:50 today.

> Unfortunately as CBNG required this information for certain
> whitelisting (such as is the user a new user), it broke the
> bot from reverting any vandalism for around 6 hours.

> It doesn't fill me with confidence that such a change would
> happen randomly with no notice.

"!= NULL" != "IS NOT NULL".

Tim