Lindorm SQL engine versions-Lindorm(Lindorm)-阿里云帮助中心

The Lindorm SQL engine is continuously updated. Some SQL syntax is available only in specific engine versions. Before using a feature, verify that your engine version supports it. This topic describes the SQL engine versions and explains how to check your engine's version.

Check SQL version with an SQL statement

Run the following statement to check your SQL engine version:

SELECT @@VERSION;

Important

When you use the SELECT @@VERSION statement to query the SQL version in LindormTable, the statement may fail to execute. This is because the SQL engine in LindormTable underwent a technical architecture upgrade in version 2.6.0, and the SELECT @@VERSION statement is supported only in version 2.6.0 and later. Therefore, an error occurs if you use this syntax on an earlier LindormTable instance, especially an instance created before September 2023.

If the statement fails for LindormTable, use the console to check the engine version. For more information, see Check SQL version in the console.

The following sample output is returned:

+---------+--------------------------+------------+
| VERSION |        BUILD_TIME        | GIT_COMMIT |
+---------+--------------------------+------------+
| 2.6.3.5 | 2023-12-13T11:04:51+0800 | 6d8ffc4    |
+---------+--------------------------+------------+

Field descriptions

Field	Description
VERSION	The version of the SQL engine.
BUILD_TIME	The build timestamp of the SQL engine.
GIT_COMMIT	The Git commit hash of the SQL engine build. Note When you contact technical support for SQL-related issues, provide this commit hash to accelerate troubleshooting.

Check SQL version in the console

You can currently check the SQL engine version only for LindormTable in the Lindorm console. Follow these steps:

Log on to the Lindorm console. In the upper-left corner of the page, select the region of the instance. On the Instances page, click the ID of the target instance or click View Instance Details in the Actions column for the instance.
In the left-side navigation pane, click Database Connections.

Click the Wide Table Engine tab. The current SQL version is displayed after the Lindorm Wide Table SQL Address. See the following table for details about the version numbers.

Version	Description
1.2.00	The SQL engine in LindormTable is an older version. Important For backward compatibility, instances created before September 2023 do not automatically switch to the new SQL engine architecture, even if LindormTable is upgraded to version 2.6.0 or later. If you need to upgrade the SQL engine, contact Lindorm technical support (DingTalk ID: s0s3eg3) for a backend upgrade.
Not 1.2.00	This indicates a new version of the SQL engine in LindormTable. The version number changes with subsequent engine updates.

The following figures show how the versions of old and new SQL engines are displayed:

The version of an older SQL engine is always 1.2.00 and does not change.
The version of a newer SQL engine varies and changes with engine updates.