dolthub / dolthub/dolt

`information_schema.user_attributes` table is missing `attributes` column values

Open
#5,203 3 comments 0 reactions 2 assignees Claimed by @zachmu View on GitHub
enhancement sql
Dominant language
Go
Stars
24.4k
Forks
873
Avg merge
1d 5h
Merged PRs (30d)
108

Description

Set up:
```
> create user tester@localhost attribute '{"fname": "John", "lname": "R"}';
```
MySQL:
```
mysql> select * from information_schema.user_attributes where user = 'tester';
+--------+-----------+---------------------------------+
| USER | HOST | ATTRIBUTE |
+--------+-----------+---------------------------------+
| tester | localhost | {"fname": "John", "lname": "R"} |
+--------+-----------+---------------------------------+
```
Dolt:
```
dolt> select * from information_schema.user_attributes where user = 'tester';
+--------+-----------+-----------+
| USER | HOST | ATTRIBUTE |
+--------+-----------+-----------+
| tester | localhost | NULL |
+--------+-----------+-----------+
```

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.