Note
Introduced in V4.1.0.
Description
regexp_time_limit specifies the time limit for regular expression matching operations. The default unit is milliseconds.
Privilege requirements
Query variables
Users in the
systenant and all users in other tenants can execute theSHOW VARIABLESstatement or view theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (in Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (in MySQL mode) to query the values of global system variables.Modify variables
Users in the
systenant can directly modify the values of global system variables.MySQL users need the
SUPERorALTER SYSTEMprivilege to modify the values of global system variables.For V4.x, Oracle users need the
ALTER SYSTEMprivilege to modify the values of global system variables, starting from V4.2.0.
Attributes
| Attribute | Description |
|---|---|
| Type | int |
| Default value | 32 |
| Value range | [0, 2147483647] |
| Scope | Global |
| Modifiable | Yes. You can modify the value by using the SET statement. |