maria-developers team mailing list archive
-
maria-developers team
-
Mailing list archive
-
Message #12520
MDEV-17399: default value is truncated
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/d7ff97bd1343a94430152389f90c4d08f56fce44
>
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
References