Dolt system tables should advertise most specific type on describe
- Dominant language
- Go
- Stars
- 24.4k
- Forks
- 873
- Avg merge
- 1d 5h
- Merged PRs (30d)
- 108
Description
When working on my Django example app I needed to use the `dolt_branches` table. I noticed it advertises it's text fields as `text` type.
```
mydatabase/main> describe dolt_branches;
+------------------------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+----------+------+-----+---------+-------+
| name | text | NO | PRI | NULL | |
| hash | text | NO | | NULL | |
| latest_committer | text | YES | | NULL | |
| latest_committer_email | text | YES | | NULL | |
| latest_commit_date | datetime | YES | | NULL | |
| latest_commit_message | text | YES | | NULL | |
| remote | text | YES | | NULL | |
| branch | text | YES | | NULL | |
+------------------------+----------+------+-----+---------+-------+
8 rows in set (0.00 sec)
```
Where possible, we should advertise the most specific type. For instance `hash` should be `char(20)` or whatever the limit is. `name` should be `varchar(200)` or whatever the actual limit on a the number of characters in a branch name is.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.