Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.24, 10.0.31
-
Ubuntu 14.04
Description
The PCRE recursion limit has apparently decreased in 10.1. There is no way to increase this limit through configuration.
eg:
MariaDB [10_1_sandbox]> SELECT CONCAT(REPEAT('100,',98),'101') RLIKE '^(([1-9][0-9]*),)*[1-9][0-9]*$' TEST;
|
+------+
|
| TEST |
|
+------+
|
| 1 |
|
+------+
|
1 row in set (0.02 sec)
|
|
|
MariaDB [10_1_sandbox]> SELECT CONCAT(REPEAT('100,',99),'101') RLIKE '^(([1-9][0-9]*),)*[1-9][0-9]*$' TEST;
|
+------+
|
| TEST |
|
+------+
|
| 0 |
|
+------+
|
1 row in set, 1 warning (0.02 sec)
|
|
|
MariaDB [sandbox]> show warnings;
|
+---------+------+--------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+--------------------------------------------------------------------+
|
| Warning | 1139 | Got error 'pcre_exec: recursion limit of 100 exceeded' from regexp |
|
+---------+------+--------------------------------------------------------------------+
|
1 row in set (0.15 sec)
|
|
In 10.0:
MariaDB [10_0_sandbox]> SELECT CONCAT(REPEAT('100,',99),'101') RLIKE '^(([1-9][0-9]*),)*[1-9][0-9]*$' TEST;
|
+------+
|
| TEST |
|
+------+
|
| 1 |
|
+------+
|
1 row in set (0.14 sec)
|
Attachments
Issue Links
- relates to
-
-
- Closed
-