[#MDEV-11833] JSON functions don't seem to respect max_allowed

MariaDB [test]> \W

Show warnings enabled.

MariaDB [test]> set @a= json_quote(json_array(repeat('a',1024),repeat('a',1024))); select length(@a);

Query OK, 0 rows affected (0.00 sec)

+------------+

| length(@a) |

+------------+

|       2062 |

+------------+

1 row in set (0.00 sec)

MariaDB [test]> show variables like 'max_allowed_packet';

+--------------------+-------+

| Variable_name      | Value |

+--------------------+-------+

| max_allowed_packet | 1024  |

+--------------------+-------+

1 row in set (0.00 sec)

MariaDB [test]> select concat(repeat('a',1024),repeat('a',1024));

+-------------------------------------------+

| concat(repeat('a',1024),repeat('a',1024)) |

+-------------------------------------------+

| NULL                                      |

+-------------------------------------------+

1 row in set, 1 warning (0.00 sec)

Warning (Code 1301): Result of concat() was larger than max_allowed_packet (1024) - truncated

MySQL 5.7
MySQL [test]> select json_quote(json_array(repeat('a',1024),repeat('a',1024)));
+-----------------------------------------------------------+
\| json_quote(json_array(repeat('a',1024),repeat('a',1024))) \|
+-----------------------------------------------------------+
\| NULL \|
+-----------------------------------------------------------+
1 row in set, 1 warning (0.00 sec)

MySQL [test]> show warnings;
+---------+------+------------------------------------------------------------------------------+
\| Level \| Code \| Message \|
+---------+------+------------------------------------------------------------------------------+
\| Warning \| 1301 \| Result of json_array() was larger than max_allowed_packet (1024) - truncated \|
+---------+------+------------------------------------------------------------------------------+
1 row in set (0.00 sec)

MySQL [test]> select @@version;
+--------------+
\| @@version \|
+--------------+
\| 5.7.17-debug \|
+--------------+
1 row in set (0.00 sec)

[MDEV-11833] JSON functions don't seem to respect max_allowed_packet Created: 2017-01-18 Updated: 2017-03-15 Resolved: 2017-03-14
Status:	Closed
Project:	MariaDB Server
Component/s:	JSON
Affects Version/s:	10.2
Fix Version/s:	10.2.5