基于湖库一体架构，统一管理结构化、半结构化与非结构化等多模态数据，一个系统承载事务处理、实时分析与 AI 工作负载。
V$OB_COMPATIBILITY_CONTROL
更新时间：2026-08-14 11:48:11
编辑
分享
功能描述
视图 V$OB_COMPATIBILITY_CONTROL 用于展示所有可以按 OceanBase DataBase AI 发行版本进行产品行为兼容控制的功能。
字段说明
| 字段名称 | 类型 | 是否可以为 NULL | 描述 |
|---|---|---|---|
| NAME | varchar(128) | NO | 功能名 |
| DESCRIPTION | varchar(4096) | NO | 功能描述 |
| IS_ENABLE | varchar(5) | NO | 是否生效 |
| ENABLE_VERSIONS | longtext | NO | 生效的版本范围，用一系列区间表示 |
查询示例
查看所有可以按 OceanBase Database AI 发行版本进行产品行为兼容控制的功能。
obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_COMPATIBILITY_CONTROL;
查询结果如下：
+---------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------------------------------+
| NAME | DESCRIPTION | IS_ENABLE | ENABLE_VERSIONS |
+---------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------------------------------+
| FUNC_REPLACE_NULL | The result of REPLACE('abd', '', null) is different in MySQL 5.7 and 8.0 | TRUE | [4.2.3.0, 4.3.0.0), [4.3.2.0, ) |
| UPD_LIMIT_OFFSET | MySQL do not support the use of OFFSET in the LIMIT clause of UPDATE/DELETE statement | TRUE | [4.2.3.0, 4.3.0.0), [4.3.2.0, ) |
| PROJECT_NULL | MySQL will rename the projection item names with pure null values to `NULL` | TRUE | [4.2.3.0, 4.3.0.0), [4.3.2.0, ) |
| VAR_NAME_LENGTH | MySQL will limit the length of user-defined variable names to within 64 characters | TRUE | [4.2.3.0, 4.3.0.0), [4.3.2.0, ) |
| NULL_VALUE_FOR_CLOSED_CURSOR | Return null value to client for closed cursor, indicating that the cursor is not open | TRUE | [4.2.5.0, 4.3.0.0), [4.3.3.0, ) |
| FUNC_LOCATE_NULL | The result of REPLACE('x', 'abc', null) is different in MySQL 5.7 and 8.0 | TRUE | [4.2.5.0, 4.3.0.0), [4.3.3.0, ) |
| INVOKER_RIGHT_COMPILE | Use the definer's database during compile, regardless of whether is definer or invoker right | TRUE | [4.3.5.2, ) |
| RECV_PLAIN_PASSWORD | The set password command is different in different OceanBase versions | TRUE | [4.3.5.2, ) |
| OUT_ANONYMOUS_COLLECTION_IS_ALLOW | The output parameter is returned according to the original input param
type which is not empty for inout anonymous array which used in anonymous block | TRUE | [4.2.5.5, 4.3.0.0), [4.3.5.3, ) |
| IMPLICIT_FIRST_CENTURY_YEAR | The result of cast('x-xx-xx', date) is different in ob and MySQL | TRUE | [4.2.5.5, 4.3.0.0), [4.3.5.4, ) |
| PLSQL_CAN_TRANSFORM_SQL_TO_ASSIGN | Whether can transform the PL/SQL select into from dual statement to an assignment statement | TRUE | [4.4.2.0, ) |
| EXTERNAL_COLUMN_NAME_CASE_INSENSITIVE | Whether column name mapping in Parquet/ORC file is case insensitive | TRUE | [4.5.0.0, ) |
| DEFAULT_CSV_ESCAPE_CHAR_IS_NONE | Whether the default CSV escape character is none | TRUE | [4.5.1.0, ) |
+---------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------------------------------+
13 rows in set (0.012 sec)
