Note
This variable is available starting with V4.1.0.
Description
regexp_time_limit specifies the maximum execution time allowed for a regular expression match operation. The default unit is milliseconds.
Privilege requirements
Query variables
You can execute the
SHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the value of a global system variable. You must be a user of thesystenant or a user tenant.Modify variables
You can modify the value of a global system variable in the
systenant.In MySQL mode, you must have the
SUPERorALTER SYSTEMprivilege to modify the value of a global system variable.In Oracle mode, you must have the
ALTER SYSTEMprivilege to modify the value of a global system variable.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 32 |
| Value range | [0, 2147483647] |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the maximum execution time allowed for a regular expression match operation to 32 ms.
obclient> SET GLOBAL regexp_time_limit = 32;