Note
This parameter is available starting from OceanBase Database V4.2.1.
Description
init_sql specifies the initialization SQL statement that ODP sends to the OceanBase cluster after it connects to the cluster.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | String type |
| Default value | N/A |
| Value range | N/A |
| Effective only after ODP restart | No |
Examples
Run the following command to set the _show_ddl_in_compat_mode parameter to 1 after ODP connects to the OceanBase cluster.
obclient> ALTER proxyconfig SET init_sql='set _show_ddl_in_compat_mode = 1;';