Support the JSON function JSON_STORAGE_SIZE

[qw4990]

Feature Request

Is your feature request related to a problem? Please describe:

Support the JSON function JSON_STORAGE_SIZE.
In MySQL:

mysql> CREATE TABLE jtable (jcol JSON);
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO jtable VALUES  ('{"a": 1000, "b": "wxyz", "c": "[1, 3, 5, 7]"}');
Query OK, 1 row affected (0.00 sec)

mysql> select jcol, JSON_STORAGE_SIZE(jcol) as size from jtable;
+-----------------------------------------------+------+
| jcol                                          | size |
+-----------------------------------------------+------+
| {"a": 1000, "b": "wxyz", "c": "[1, 3, 5, 7]"} |   47 |
+-----------------------------------------------+------+

In TiDB:

mysql> CREATE TABLE jtable (jcol JSON);
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO jtable VALUES  ('{"a": 1000, "b": "wxyz", "c": "[1, 3, 5, 7]"}');
Query OK, 1 row affected (0.00 sec)

mysql> select jcol, JSON_STORAGE_SIZE(jcol) as size from jtable;
ERROR 1305 (42000): FUNCTION JSON_STORAGE_SIZE does not exist

[francis0407]

What are the first three characters of the issue title? In my Chrome, the title is

. Is it expected?
`

[qw4990]

What are the first three characters of the issue title? In my Chrome, the title is

. Is it expected?
`

Is it ok now? In my Chrome it is nothing before Support....

[francis0407]

It's OK now.

[stoksc]

Is anyone working on this? I could take a shot.