OceanBase
English日本語简体中文
Docs Home
Products
Integrations
Release Notes

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Databases

OceanBase DatabaseOceanBase Cloud OceanBase Best Practices

Connectors and Middleware

OceanBase Database Proxy OceanBase Connector/C OceanBase Connector/J OceanBase Connector/ODBC OceanBase Connector/NETOceanBase Command-Line Client

Tools

OceanBase Cloud PlatformOceanBase Migration ServiceOceanBase Developer CenterOceanBase Migration AssessmentOceanBase Admin ToolOceanBase Loader and DumperOceanBase DeployerKubernetes operator for OceanBaseOceanBase Diagnostic Tool OceanBase Binlog Service
OceanBase DatabaseOceanBase Cloud ToolsConnectors and MiddlewareLifecycle Support Policy

OceanBase Database

SQL - V4.2.5

    Download PDF

    Document Feedback
    1. Documentation Center
    2. OceanBase Database
    3. SQL
    4. V4.2.5

    ob_capability_flag

    Last Updated:2026-09-04 09:48:50

    Description
    Attributes
    Usage

    Note

    This variable is available starting with V1.4.

    Description

    ob_capability_flag specifies the capabilities provided by the OBServer node. It is used to negotiate capabilities with obproxy, informing obproxy of the supported and unsupported features of the current OBServer node.

    Attributes

    Attribute
    Description
    Type Uint
    Default value 0
    Value range [0,18446744073709551615]
    Scope Session
    Modifiable No. This variable can be specified when creating a tenant, but cannot be modified through SQL statements after the tenant is created.
    Visibility No. All tenants cannot see this variable.

    Usage

    Users cannot query the value of this variable using the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) and the information_schema.SESSION_VARIABLES view (MySQL mode). Users can query the value of this variable using the SYS.DBA_OB_SYS_VARIABLES view (Oracle mode) and the oceanbase.DBA_OB_SYS_VARIABLES view (MySQL mode).

    on this page
    Description
    Attributes
    Usage