Adalbert Makarovych

.take-issue

Design doc: https://docs.google.com/document/d/1WU-hkoZ93SaGXyOz_UtX0jXzIRl194hCId_IdmEV9jw/edit?usp=sharing

Hey @larskoole Thanks for reaching out. I created an internal task to investigate this issue.

Hi Martin, Here is more information on Unicode characters in SingleStoreDB JSON type: https://docs.singlestore.com/db/v8.0/en/create-a-database/using-json.html#unicode-support-652809 According to this article, the default behavior of `json_encode` (escape as \uXXXX) should work well. I'm...

Thanks, @michabbb I created an internal ticket for this issue.

A small update regarding this. Despite [this](https://docs.singlestore.com/db/v8.0/create-a-database/using-json/#unicode-support) doc - escaped characters outside the Basic Multilingual Plane (characters whose codepoints are in the range 0x10000 to 0x10FFFF) are not handled correctly. ...

Hi @harisenbon Thanks for your request. As for me, it looks a little bit weird that `JSON_EXTRACT_STRING(`value`, 'lccontent') = 'paid'` works much slower than `JSON_MATCH_ANY(MATCH_PARAM_STRING_STRICT() LIKE '%paid%', `value`, 'lccontent')`. I...

I just had a chance to test this thing. Used 8.0.12 version of the SingleStore. ``` MySQL [db]> select * from t where JSON_EXTRACT_STRING(`value`, 'lccontent') = 'asdas'; Empty set (0.163...

Hey @larskoole Nullable primary key should be forbidden in SingleStore. ``` MySQL [db]> create table t(a char(26), b char(26) null, primary key(a, b)); Query OK, 0 rows affected, 1 warning...

I'm impressed that it was possible to create a nullable column which is a part of the primary key. Do you use the same version of the SingleStore in the...