[MDEV-11465] JSON_LENGTH returns incorrect length - Jira

XML

Word

Printable

Compare:

MariaDB 10.2
MariaDB [test]> select json_length('{}');
+-------------------+
\| json_length('{}') \|
+-------------------+
\| 1 \|
+-------------------+
1 row in set (0.01 sec)

MariaDB [test]> SELECT JSON_LENGTH('[1, 2, {"a": 3}]');
+---------------------------------+
\| JSON_LENGTH('[1, 2, {"a": 3}]') \|
+---------------------------------+
\| 4 \|
+---------------------------------+
1 row in set (0.00 sec)

MySQL 5.7
MySQL [test]> select json_length('{}');
+-------------------+
\| json_length('{}') \|
+-------------------+
\| 0 \|
+-------------------+
1 row in set (0.00 sec)

MySQL [test]> SELECT JSON_LENGTH('[1, 2, {"a": 3}]');
+---------------------------------+
\| JSON_LENGTH('[1, 2, {"a": 3}]') \|
+---------------------------------+
\| 3 \|
+---------------------------------+
1 row in set (0.01 sec)

relates to

MDEV-9143 JSON_xxx functions

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