[MDEV-22293] JSON_TABLE: Values for regular columns are truncated for no reason - Jira

The column is of sufficient length, there should be no truncation.

MySQL 8.0.19
MySQL [test]> select * from json_table('{"a":"foo"}',"$" columns(a varchar(8) path '$.a')) x;
+------+
\| a \|
+------+
\| foo \|
+------+
1 row in set (0.001 sec)

It works in MariaDB, too, with slightly longer column:

MariaDB [test]> select * from json_table('{"a":"foo"}',"$" columns(a varchar(12) path '$.a')) x;

+------+

| a    |

+------+

| foo  |

+------+

1 row in set (0.002 sec)

set names doesn't seem to change the outcome, tried latin1, utf8, utf8mb4.

relates to

MDEV-17399 Add support for JSON_TABLE

MDEV-22298 JSON_TABLE: EXISTS PATH value is converted to other types incorrectly

Transition	Time In Source Status	Execution Times

Alexey Botchkov made transition - 2020-04-27 19:09

Open

In Progress

9d 2h 54m

Alexey Botchkov made transition - 2020-04-27 19:10

In Progress

Closed

17s

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server