This topic introduces the version number guidelines and their meanings for OceanBase Database.
As OceanBase Database continues to evolve and improve, new versions are released periodically. These versions can differ greatly in terms of features and capabilities, so it's essential to identify your database version to obtain the correct documentation.
OceanBase Database versions are represented as V.x.y.z.f, where:
x indicates a major version, typically involving architecture upgrades or significant new features.
y indicates a planned iteration version, featuring important updates and enhancements as part of the regular update cycle.
z indicates an updated version, containing minor feature updates and fixes for known issues.
f indicates a patch upgrade version, used to identify updates in features and fixes when a higher version number is needed
Check your OceanBase Database version
You can view the current database version by querying version() or using a view.
Usually, after connecting to the database with OBClient or a MySQL client, the version information is displayed. To check the version of the database you are using, follow the methods below.
Check the version of your OceanBase Database (MySQL mode)
Log in as the administrator and run the following command to view the database version:
obclient> SELECT version();
+-----------+
| version() |
+-----------+
| 4.0.0.0 |
+-----------+
1 row in set
View the version of your OceanBase Database (Oracle mode)
Log in as the administrator and run the following command to view the database version:
obclient> SELECT * FROM v$version;
+-----------------------------------------------------------------------------------------------------------+--------+
| BANNER | CON_ID |
+-----------------------------------------------------------------------------------------------------------+--------+
| OceanBase 4.0.0.0 (r20220525115829-1873fc2598d56060fe307ce3b7b88647686e0b09) (Built May 25 2022 12:12:10) | 0 |
+-----------------------------------------------------------------------------------------------------------+--------+
1 row in set