[MDEV-11471] JSON_ARRAY_APPEND returns incorrect results - Jira

Compare:

MariaDB 10.2
MariaDB [test]> SET @j = '["a", ["b", "c"], "d"]';
Query OK, 0 rows affected (0.00 sec)

MariaDB [test]> SELECT JSON_ARRAY_APPEND(@j, '$[0]', 2);
+----------------------------------+
\| JSON_ARRAY_APPEND(@j, '$[0]', 2) \|
+----------------------------------+
\| NULL \|
+----------------------------------+
1 row in set (0.00 sec)

MySQL 5.7
MySQL [test]> SET @j = '["a", ["b", "c"], "d"]';
Query OK, 0 rows affected (0.00 sec)

MySQL [test]> SELECT JSON_ARRAY_APPEND(@j, '$[0]', 2);
+----------------------------------+
\| JSON_ARRAY_APPEND(@j, '$[0]', 2) \|
+----------------------------------+
\| [["a", 2], ["b", "c"], "d"] \|
+----------------------------------+
1 row in set (0.00 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.

MariaDB Server