Hi Alexey, On Fri, Jan 29, 2021 at 10:42:59AM +0400, Alexey Botchkov wrote:
Some updates were pushed. See here for the review. https://github.com/MariaDB/server/commit/d7ff97bd1343a94430152389f90c4d08f56...
Good. First input: MariaDB [(none)]> SELECT x, length(x) FROM JSON_TABLE('{}', '$' COLUMNS (x VARCHAR(10) PATH '$.x' DEFAULT 'abcdefg' ON EMPTY)) jt; +------+-----------+ | x | length(x) | +------+-----------+ | abc | 3 | +------+-----------+ 1 row in set (0.000 sec) Using VARACHAR(12) produces "abcd", so it seems the truncation length is one third of the N in VARCHAR(N). Is this utf8 characters vs bytes error somewhere? Please fix. BR Sergei -- Sergei Petrunia, Software Developer MariaDB Corporation | Skype: sergefp | Blog: http://petrunia.net