Note
Introduced in V4.1.0.
Description
The regexp_stack_limit variable specifies the maximum available memory for the internal stack of regular expression matching operations, in bytes.
Privilege requirements
Query variables
Users in the
systenant and all user tenants can execute theSHOW VARIABLESstatement or view theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) and theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to query the value of a global system variable.Modify variables
Users in the
systenant can directly modify the value of a global system variable.MySQL users need the
SUPERorALTER SYSTEMprivilege to modify the value of a global system variable.For V4.x, Oracle users need the
ALTER SYSTEMprivilege to modify the value of a global system variable, starting from V4.2.0.
Attributes
| Attribute | Description |
|---|---|
| Type | int |
| Default value | 8000000 |
| Value range | [0, 2147483647] |
| Scope | Global |
| Modifiable | Yes, you can modify it by using the SET statement. |