--- title: "V$OB_COMPATIBILITY_CONTROL - OceanBase Database AI V4.6.2 | OceanBase 文档中心" description: V$OB_COMPATIBILITY_CONTROL 功能描述 视图 V$OB_COMPATIBILITY_CONTROL 用于展示所有可以按 OceanBase DataBase AI 发行版本进行产品行为兼容控制的功能。 字段说明 字段名称 类型 是否可以为 NULL 描述 NAME varchar(128) N… image: https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*OSPzQ6GUQF4AAAAAQHAAAAgAeiGDAQ/original --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*inJjSpyNOjUAAAAAHtAAAAgAeiGDAQ/original) OceanBase Database AIV 4.6.2 # V$OB_COMPATIBILITY_CONTROL 更新时间：2026-08-14 11:48:11 [编辑](https://github.com/oceanbase/oceanbase-database-ai/edit/V4.6.2/zh-CN/700.reference/700.system-views/400.system-view-of-mysql-mode/300.performance-view-of-mysql-mode/30850.v-ob_compatibility_control-of-mysql-mode.md) ## 功能描述 视图 `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 发行版本进行产品行为兼容控制的功能。 ```shell obclient [oceanbase]> SELECT * FROM oceanbase.V$OB_COMPATIBILITY_CONTROL; ``` 查询结果如下： ```shell +---------------------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+---------------------------------+ | 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) ``` ## 相关系统变量 - [ob_compatibility_version](https://www.oceanbase.com/docs/common-oceanbase-database-ai-1000000006780996) - [ob_compatibility_control](https://www.oceanbase.com/docs/common-oceanbase-database-ai-1000000006780915) - [ob_security_version](https://www.oceanbase.com/docs/common-oceanbase-database-ai-1000000006780916) 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线