JSON datatype sampling error #178
Description
Please answer these questions before submitting your issue. Thanks!
- 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"- 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"));- 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