All Products
Search

This Product

    Lindorm:SQL versions

    Document Center

    Lindorm:SQL versions

    Last Updated:Apr 28, 2024

    Lindorm continuously releases new Lindorm SQL versions. Some SQL syntaxes are supported only in specific Lindorm SQL versions. Therefore, when you use a SQL syntax, make sure that the current Lindorm SQL version of your instance supports the syntax. This topic describes the versions of Lindorm SQL and how to view the Lindorm SQL version.

    Execute a SQL statement to view the Lindorm SQL version

    You can execute the following statement to query the version of Lindorm SQL. 

    SELECT @@VERSION;
    Important

    When you execute the SELECT @@VERSION statement in LindormTable to query the version of Lindorm SQL, the statement may fail to be executed. This is because the SELECT @@VERSION statement is supported only by Lindorm SQL 2.6.0 and later versions in LindormTable. These versions are upgraded in their architecture. Therefore, the statement may fail to be executed in LindormTable of earlier versions, especially the versions that are released before September 2023.

    If an error is reported when you execute the SELECT @@VERSION statement in LindormTable, you can view the Lindorm SQL version in the Lindorm console. For more information, see View the Lindorm SQL version in the console.

    The following result is returned:

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

    Returned results

    Field

    Description

    VERSION

    The version of Lindorm SQL.

    BUILD_TIME

    The time when Lindorm SQL is built.

    GIT_COMMIT

    The revision number that is generated when Lindorm SQL is built.

    Note

    If errors related to Lindorm SQL occur, you may need to provide this revision number to the technical support for efficient troubleshooting.

    View the Lindorm SQL version in the console

    You can view only the Lindorm SQL version in LindormTable in the Lindorm console. Perform the following steps to view the Lindorm SQL version:

    1. Log on to the Lindorm console. In the upper-left corner of the page, select the region where the instance is deployed. On the Instances page, click the ID of the instance that you want to manage or click Manage in the Actions column corresponding to the instance.

    2. In the left-side navigation pane, click Database Connections.

    3. Click the Wide Table Engine tab and view the Lindorm SQL version that is displayed in the SQL Version field. The following table describes the version numbers that may be displayed in this field.

      Version

      Description

      1.2.00

      The Lindorm SQL in LindormTable is of an earlier version.

      Important

      If your Lindorm instance is purchased before September 2023, the Lindorm SQL version is not automatically upgraded to the latest version even if LindormTable is upgraded to 2.6.0 and later for backward compatibility. In this case, you can contact the technical support (DingTalk ID: s0s3eg3) to upgrade the Lindorm SQL version.

      A version number that is not 1.2.00

      The Lindorm SQL in LindormTable is of the latest version. The displayed version is the latest version of Lindorm SQL.

      The following figures show the Lindorm SQL versions displayed in the console.

      • The version of Lindorm SQL in Lindorm instances purchased before September, 2023 is displayed as 1.2.00 and is not automatically upgraded.image

      • The version of Lindorm SQL in Lindorm instances purchased after September, 2023 is automatically upgraded to the latest in the console.image