Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2(EOL)
-
None
-
10.2.5-1
Description
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) |
Similar behavior of other functions:
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 |
While this example looks artificial , it may cause serious stability issues in many scenarios on production (unintentionally, e.g. because of bug in client software or used by attacker to impact performance / stability) - so I put 'Major' priority here, but I am OK with 'Minor' priority if such is justified.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
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) Similar behavior of other functions: 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 While this example looks artificial , it may cause serious stability issues in many scenarios on production (unintentionally, e.g. because of bug in client software or used by attacker to impact performance / stability) - so I put 'Major' priority here, but I am OK with 'Minor' priority if such is justified. |
{code:sql}
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) {code} Similar behavior of other functions: {code:sql} 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 {code} While this example looks artificial , it may cause serious stability issues in many scenarios on production (unintentionally, e.g. because of bug in client software or used by attacker to impact performance / stability) - so I put 'Major' priority here, but I am OK with 'Minor' priority if such is justified. |
| Fix Version/s | 10.2 [ 14601 ] |
| Sprint | 10.2.5-1 [ 144 ] |
| Rank | Ranked lower |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| issue.field.resolutiondate | 2017-03-14 13:51:00.0 | 2017-03-14 13:51:00.361 |
| Fix Version/s | 10.2.4 [ 22116 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Fix Version/s | 10.2.5 [ 22117 ] | |
| Fix Version/s | 10.2.4 [ 22116 ] |
| Workflow | MariaDB v3 [ 79261 ] | MariaDB v4 [ 151554 ] |
I don't think the example is exceedingly artificial. In reality, JSON texts can probably be quite long, so they can exceed max_allowed_packet.
In MySQL it works as expected:
MySQL 5.7
MySQL [test]> show warnings;| @@version || 5.7.17-debug |