Note
This parameter is available starting from OceanBase Database V4.2.1.
Description
init_sql specifies the initialization SQL statements that ODP sends to the OceanBase cluster after successfully connecting to it.
Attributes
Attribute |
Description |
|---|---|
| Parameter type | String |
| 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 successfully connects to the OceanBase cluster.
obclient> ALTER proxyconfig SET init_sql='set _show_ddl_in_compat_mode = 1;';