Note
This variable is available starting with V2.2.77.
Description
ob_proxy_global_variables_version is used in the internal communication between obproxy and OBServer nodes. It specifies the latest version of global variables that the OBServer node returns to obproxy.
Attributes
| Attribute | Description |
|---|---|
| Type | Int |
| Default value | 0 |
| Value range | [0, INT64_MAX) |
| Scope | Session |
| Modifiable | No. This variable can be specified when a tenant is created, but cannot be modified by executing an SQL statement after the tenant is created. |
Considerations
You cannot execute the SHOW VARIABLES statement or query the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) or the information_schema.SESSION_VARIABLES view (MySQL mode) to obtain the value of this variable. You can query the SYS.DBA_OB_SYS_VARIABLES view (Oracle mode) or the oceanbase.DBA_OB_SYS_VARIABLES view (MySQL mode) to obtain the value of this variable.
Alternatively, you can execute the SELECT statement to obtain the latest version number of the global variable:
obclient> SELECT @@ob_proxy_global_variables_version;
The result set is as follows:
+-------------------------------------+
| @@ob_proxy_global_variables_version |
+-------------------------------------+
| 0 |
+-------------------------------------+
1 row in set
