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