Skip to content

dolt_statistics.created_at is always 0001-01-01 00:00:00 #10168

Description

@angelamayxie
tmp/main*> select * from dolt_statistics;
+---------------+----------------+------------+-----------+----------------+------------+----------------------+-------------------+---------------------------------------------------------------------------+-----------------+---------------------+------+------+------+------+------------+
| database_name | table_name     | index_name | row_count | distinct_count | null_count | columns              | types             | upper_bound                                                               | upper_bound_cnt | created_at          | mcv1 | mcv2 | mcv3 | mcv4 | mcv_counts |
+---------------+----------------+------------+-----------+----------------+------------+----------------------+-------------------+---------------------------------------------------------------------------+-----------------+---------------------+------+------+------+------+------------+
| tmp           | my_table       | primary    | 1         | 1              | 0          | id                   | int               | 0                                                                         | 1               | 0001-01-01 00:00:00 |      |      |      |      |            |
| tmp           | property       | primary    | 10        | 10             | 0          | id                   | int               | 10                                                                        | 1               | 0001-01-01 00:00:00 |      |      |      |      |            |
| tmp           | somecaps       | primary    | 1         | 1              | 0          | i                    | int               | 1                                                                         | 1               | 0001-01-01 00:00:00 |      |      |      |      |            |
| tmp           | aaa            | primary    | 4         | 4              | 0          | a                    | int               | 4                                                                         | 1               | 0001-01-01 00:00:00 |      |      |      |      |            |
| tmp           | ab             | primary    | 4         | 4              | 0          | a                    | int               | 3                                                                         | 1               | 0001-01-01 00:00:00 |      |      |      |      |            |
| tmp           | animals_a      | primary    | 4         | 4              | 0          | id                   | int               | 4                                                                         | 1               | 0001-01-01 00:00:00 |      |      |      |      |            |
| tmp           | animals_b      | primary    | 5         | 5              | 0          | id                   | int               | 6                                                                         | 1               | 0001-01-01 00:00:00 |      |      |      |      |            |
| tmp           | c              | primary    | 6         | 6              | 0          | c_id                 | int               | 6                                                                         | 1               | 0001-01-01 00:00:00 |      |      |      |      |            |
| tmp           | child          | primary    | 2         | 2              | 0          | parent_id,version_id | char(36),char(36) | e6333228-ca35-4ea2-9bf3-d2abdc75fde5,aad1894b-833c-4d83-8b72-8b7b0437fc52 | 1               | 0001-01-01 00:00:00 |      |      |      |      |            |
| tmp           | comp_index_t0  | primary    | 101       | 101            | 0          | pk                   | bigint            | 100                                                                       | 1               | 0001-01-01 00:00:00 |      |      |      |      |            |

(table truncated because too many rows)

dolt_statistics.created_at is also of type datetime (zero precision) and may need to be updated to precision 3 or 6 (see #10128)

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingstatssystem tablesIssues and feature requests related to system tables

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions