Note
For V4.6.0, this parameter is available starting with V4.6.0.
Description
The sql_func_extension_mode parameter specifies whether to enable the extension of mainstream compatible mode functions whose naming styles are inconsistent with those of MySQL.
Applicability
This parameter is applicable only to OceanBase Database in MySQL mode.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query this parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
The
systenant and user tenants can modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Varchar |
| Default value | Empty string |
| Value range |
|
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
OceanBase Database maintains a list of functions that are specific to each compatible mode. By default, functions in the list are not exposed. When you set the sql_func_extension_mode parameter to the corresponding mode, all functions in the list are exposed. You can then call these functions in SQL statements.
Notice
The visibility of functions exposed by default in MySQL mode is not affected by this parameter.
Overlapping compatible modes
You can enable multiple compatible modes at the same time. When you enable multiple compatible modes, you can use commas to separate the names of the modes:
ALTER SYSTEM SET sql_func_extension_mode = "mode1, mode2";
Examples
Enable the extension of ClickHouse compatible mode functions.
obclient> ALTER SYSTEM SET sql_func_extension_mode = "ClickHouse";