information_schema.user_attributes table is missing attributes column values

[jennifersp]

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      |
+--------+-----------+-----------+

[PrathyushaModala]

I would like work on this :)

[PrathyushaModala]

Hi @jennifersp Can you suggest any idea on how to solve the above issue.

[jennifersp]

Hi @PrathyushaModala, this issue will require some changes on https://github.com/dolthub/go-mysql-server . I found this hint when I looked at the issue briefly. I'm not familiar with what unexpected behavior it's causing, but it's the reason we are not able to fill in the attribute data in the user table when the user is created in the first place. Then this user table is used to retrieve that value to put in the information_schema.user_attributes table.