JSON datatype sampling error

[martianzhang]

Please answer these questions before submitting your issue. Thanks!

1. What did you do?

create table test_json(
id int,
`c` json DEFAULT NULL
) engine=InnoDB charset=utf8mb4;

insert into test_json values (1, '{"k1": "value", "k2": 10}');

soar -query "select * from test_json"

2. What did you see instead?

Error 3144: Cannot create a JSON value from a string with CHARACTER SET 'binary'.

insert into `test_json` (`id`,`c`) values (unhex("31"),unhex("7b226b31223a202276616c7565222c20226b32223a2031307d"));

3. What version of are you using (soar -version)?

Version: 2018-12-28 22:50:30 +0800 0.10.0-81-gd9f6ef7
Branch: master
Compile: 2019-01-02 19:51:33 +0800 by go version go1.10.4 linux/amd64
GitDirty: 0

[martianzhang]

Error:
insert into `test_json` (`id`,`c`) values (unhex("31"),unhex("7b226b31223a202276616c7565222c20226b32223a2031307d"));

Right:
insert into `test_json` (`id`,`c`) values (unhex("31"), CONVERT(X'7b226b31223a202276616c7565222c20226b32223a2031307d' using utf8mb4))

Reference:

• https://dev.mysql.com/doc/refman/8.0/en/json.html
• https://stackoverflow.com/questions/38078119/mysql-5-7-12-import-cannot-create-a-json-value-from-a-string-with-character-set