OceanBase Database is constantly iterated and improved and new versions are released from time to time. Database features may differ significantly from one version to another. Therefore, only the help information that matches your database version can be truly helpful.
Version rules of OceanBase Database
The versions of OceanBase Database are defined in the V.x.y.z.f format.
x indicates a major version, which generally involves an architectural upgrade or a release of major features.
y indicates a planned iteration version, which involves an update or optimization of major features in a normal iteration plan.
z indicates an updated version, which involves a few updates in features and fixes known issues.
f indicates a patch upgrade version. It is in the fourth place and suffixed to form a later version number that identifies updates in features and fixed issues.
Check the version of your OceanBase Database
You can check the current version of OceanBase Database from a view or by specifying the version() keyword in an SQL statement.
Generally, you can connect to your OceanBase Database by using an OBClient or a MySQL client to view the database version. You can also query the database version in the following ways.
Check the version of your OceanBase Database in MySQL mode
Log on to the database as the administrator and run the following command:
obclient> SELECT version();
+-----------+
| version() |
+-----------+
| 3.2.4.0 |
+-----------+
1 row in set
Check the version of your OceanBase Database in Oracle mode
Log on to the database as the administrator and run the following command:
obclient> SELECT * FROM v$version;
+--------------------------------------------------------------------------------------------------------------+--------+
| BANNER | CON_ID |
+--------------------------------------------------------------------------------------------------------------+--------+
| OceanBase 3.2.4.0 (r10100022022080214-fe4ff5b098493e55480ed9928b442d4063c29ae7) (Built Aug 2 2022 14:44:41) | 0 |
+--------------------------------------------------------------------------------------------------------------+--------+
1 row in set