Page MenuHomePhabricator
Paste P13714

(An Untitled Masterwork)
ActivePublic

Authored by Marostegui on Mon, Jan 11, 1:45 PM.
root@db1089.eqiad.wmnet[information_schema]> select column_name,column_default from columns where table_name like 'revision_actor_temp';
+--------------------+----------------+
| column_name | column_default |
+--------------------+----------------+
| revactor_rev | NULL |
| revactor_actor | NULL |
| revactor_timestamp | |
| revactor_page | NULL |
+--------------------+----------------+
4 rows in set (0.003 sec)
root@db1089.eqiad.wmnet[information_schema]>

Event Timeline

Marostegui created this paste.Mon, Jan 11, 1:45 PM
Kormat added a subscriber: Kormat.Mon, Jan 11, 1:58 PM
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
+---------------+--------------+---------------------+----------------+------------------+----------------+-------------+----
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)