All Products
Search

This Product

    Lindorm:SQL version guide

    Document Center

    Lindorm:SQL version guide

    Last Updated:Mar 28, 2026

    Lindorm SQL is continuously upgraded, and some SQL syntax requires a minimum SQL engine version. Before using specific SQL features, confirm that your SQL engine version meets the requirements.

    Check the version using a SQL statement

    Run the following statement to query the SQL engine version:

    SELECT @@VERSION;

    The output looks similar to this:

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

    Output fields

    FieldDescription
    VERSIONThe SQL engine version number.
    BUILD_TIMEThe date and time when the SQL engine binary was built.
    GIT_COMMITThe commit hash of the build. When reporting a SQL-related issue to Lindorm technical support, include this value to speed up troubleshooting.
    Important

    In LindormTable, SELECT @@VERSION is supported only on SQL engine version 2.6.0 and later. Instances created before September 2023 may be running an older engine that does not support this statement. If the statement fails, check the version in the console instead.

    View the version in the console

    You can view the SQL version in the console for LindormTable only.

    1. Log on to the Lindorm console. In the upper-left corner, select the region of your instance. On the Instances page, click the instance ID, or click View Instance Details in the Actions column.

    2. In the navigation pane on the left, click Database Connections.

    3. Click the Wide Table Engine tab. The SQL version appears next to Lindorm Wide Table SQL Address.

    The following table describes the version number and the action to take:

    Version displayedWhat it meansAction
    1.2.00Your LindormTable instance is running an older SQL engine. This version does not change even when the LindormTable engine is upgraded to 2.6.0 or later — instances purchased before September 2023 are not automatically migrated to the new SQL engine architecture.Contact Lindorm technical support (DingTalk ID: s0s3eg3) to request a backend upgrade.
    Any other versionYour LindormTable instance is running a newer SQL engine. The version number updates with each SQL engine release.No action needed.

    The following images show how the SQL version appears in the console:

    • Older SQL versions always display as 1.2.00.image

    • Newer SQL versions display a version number that updates with each SQL engine iteration.image