Event Timeline
Comment Actions
root@db2079.codfw.wmnet[wikidatawiki]> select * from information_schema.columns where table_name='revision_actor_temp'; +---------------+--------------+---------------------+--------------------+------------------+----------------+-------------+ | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | +---------------+--------------+---------------------+--------------------+------------------+----------------+-------------+ | def | wikidatawiki | revision_actor_temp | revactor_rev | 1 | NULL | NO | | def | wikidatawiki | revision_actor_temp | revactor_actor | 2 | NULL | NO | | def | wikidatawiki | revision_actor_temp | revactor_timestamp | 3 | | NO | | def | wikidatawiki | revision_actor_temp | revactor_page | 4 | NULL | NO | +---------------+--------------+---------------------+--------------------+------------------+----------------+-------------+ root@db2079.codfw.wmnet[wikidatawiki]> select * from information_schema.columns where table_name='revision_actor_temp' and column_default IS NOT NULL; +---------------+--------------+---------------------+--------------------+------------------+----------------+-------------+ | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | +---------------+--------------+---------------------+--------------------+------------------+----------------+-------------+ | def | wikidatawiki | revision_actor_temp | revactor_timestamp | 3 | | NO | +---------------+--------------+---------------------+--------------------+------------------+----------------+-------------+ root@db2079.codfw.wmnet[wikidatawiki]> select * from information_schema.columns where table_name='revision_actor_temp' and column_default IS NULL; +---------------+--------------+---------------------+----------------+------------------+----------------+-------------+---- | TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | COLUMN_NAME | ORDINAL_POSITION | COLUMN_DEFAULT | IS_NULLABLE | DAT +---------------+--------------+---------------------+----------------+------------------+----------------+-------------+---- | def | wikidatawiki | revision_actor_temp | revactor_rev | 1 | NULL | NO | int | def | wikidatawiki | revision_actor_temp | revactor_actor | 2 | NULL | NO | big | def | wikidatawiki | revision_actor_temp | revactor_page | 4 | NULL | NO | int +---------------+--------------+---------------------+----------------+------------------+----------------+-------------+----
Comment Actions
root@db2084.codfw.wmnet[information_schema]> select column_name,column_default from information_schema.columns where table_name='revision_actor_temp'; +--------------------+--------------------------------+ | column_name | column_default | +--------------------+--------------------------------+ | revactor_rev | NULL | | revactor_actor | NULL | | revactor_timestamp | '\0\0\0\0\0\0\0\0\0\0\0\0\0\0' | | revactor_page | NULL | +--------------------+--------------------------------+ 4 rows in set (0.038 sec) root@db2084.codfw.wmnet[information_schema]> select @@version; +---------------------+ | @@version | +---------------------+ | 10.4.13-MariaDB-log | +---------------------+ 1 row in set (0.034 sec)