· · · · · · · · · · · · · · · · · · · · · 1207 11 7.7.17 How does TiCDC Open Protocol represent null? · · · · · · · · · · · · · · · · · · 1207 7.7.18 How can I tell if a Row Changed Event of TiCDC Open added, the type is changed from boolean to enu- mera- tion, the default value is changed from OFF to null, and the op- tional values TABLE and GLOBAL are added. In ad- dition, it now sup- ports cluster- level estimates the number of rows as 1 when accessing a unique index with the query condition column IS NULL #56116 @hawkingrei • Fix the issue that the optimizer does not use the best multi-column statistics

added, the type is changed from boolean to enu- mera- tion, the default value is changed from OFF to null, and the op- tional values TABLE and GLOBAL are added. In ad- dition, it now sup- ports cluster- level estimates the number of rows as 1 when accessing a unique index with the query condition column IS NULL #56116 @hawkingrei • Fix the issue that the optimizer does not use the best multi-column statistics #49692 @solotzg • Fix the issue that the SUB_PART value in the INFORMATION_SCHEMA.STATISTICS table is NULL #55812 @Defined2014 • Fix the issue that an error occurs when a DML statement contains nested gener-

• Use index order to avoid extra sorting operations for SQL queries like WHERE idx �→ _col_1 IS NULL ORDER BY idx_col_2 #54188 @ari-e • Display analyzed indexes in the mysql.analyze_jobs system table #54908 @xzhangxian1008 • Fix the issue that internal SQL statements in the slow log are redacted to null by default #54190 #52743 #53264 @lcwangchao • Fix the issue that PointGet execution plans for _tidb_rowid �→ DATA �→ 5 Y Y Y Y Y Y Y Y Y Y Y 5Starting from TiDB v7.0.0, the new parameter FIELDS DEFINED NULL BY and support for importing data from S3 and GCS are experimental features. Starting from v7.6.0

earlier versions, when processing a transaction containing UPDATE changes, if the primary key or non-null unique index value is modified in an UPDATE event, TiCDC splits this event into DELETE and INSERT Authen- tication requests with user- names not in this list will be rejected. The default value is null. TiCDC security �→ . �→ client �→ - �→ user �→ - �→ required �→ Newly added Controls whether to use LOAD �→ �→ DATA �→ 5 Y Y Y Y Y Y Y Y Y 5Starting from TiDB v7.0.0, the new parameter FIELDS DEFINED NULL BY and support for importing data from S3 and GCS are experimental features. Starting from v7.6.0

issue that in the disaggregated storage and compute architecture, null values might be incorrectly returned in queries after adding non-null columns in DDL operations #9084 @Lloyd-Pottiger • Fix the issue �→ �→ DATA �→ 5 Y Y Y Y Y Y Y Y Y Y 5Starting from TiDB v7.0.0, the new parameter FIELDS DEFINED NULL BY and support for importing data from S3 and GCS are experimental features. Starting from v7.6.0 DATABASE bikeshare; USE bikeshare; CREATE TABLE trips ( trip_id bigint NOT NULL PRIMARY KEY AUTO_INCREMENT, duration integer not null, start_date datetime, end_date datetime, start_station_number integer,

7.8.16 TiCDC 把数据同步到 Kafka 时，如何确定一条消息中包含的数据变更发生在哪个时间点？ · · · · 954 7.8.17 TiCDC Open protocol 如何标示 null 值？ · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · · 954 10 7.8 #55981 @winoros – 修复统计信息初始化时，使用非二进制排序规则的字符串类型列的统计信息可能无法正常加载的 问题 #55684 @winoros – 修复当查询条件为 column IS NULL 访问唯一索引时，优化器将行数错误地估算为 1 的问题 #56116 @hawkingrei – 修复当查询包含形如 (... AND ...)OR (... AND ...)... 的过滤条件时，优化器没有使用最优的 前台限流 Y Y Y Y Y Y Y E N N N N 后台限流 E E E E E E E N N N N N 5从TiDB v7.0.0 开始新增的参数 FIELDS DEFINED NULL BY 以及新增支持从 S3 和 GCS 导入数据，均为实验特性。从TiDB v7.6.0 开始 LOAD DATA 的事务行为与 MySQL 的事务行为一致，包括事务内的 LOAD DATA

#55981 @winoros – 修复统计信息初始化时，使用非二进制排序规则的字符串类型列的统计信息可能无法正常加载的 问题 #55684 @winoros – 修复当查询条件为 column IS NULL 访问唯一索引时，优化器将行数错误地估算为 1 的问题 #56116 @hawkingrei – 修复当查询包含形如 (... AND ...)OR (... AND ...)... 的过滤条件时，优化器没有使用最优的 Y Y Y Y Y Y Y Y Kubernetes operator Y Y Y Y Y Y Y Y Y Y Y Y 5从TiDB v7.0.0 开始新增的参数 FIELDS DEFINED NULL BY 以及新增支持从 S3 和 GCS 导入数据，均为实验特性。从TiDB v7.6.0 开始 LOAD DATA 的事务行为与 MySQL 的事务行为一致，包括事务内的 LOAD DATA playerRepository.save(player); 更多信息参考插入数据和更新数据。 查询数据 PlayerBean player = playerRepository.findById(id).orElse(null); 更多信息参考查询数据。 删除数据 playerRepository.deleteById(id); 更多信息参考删除数据。 4.3.1.4.4 下一步 • 关于本文使用到的第三方库及框架，可以参考各自官方文档：

@HuSharp • TiFlash – 修复在含空分区的分区表上执行查询时，可能会超时的问题 #9024 @JinheLin – 修复在存算分离架构下，DDL 新增带有 not null 属性的列后，查询可能返回错误的 null 值的问题 #9084 @Lloyd-Pottiger – 修复函数 SUBSTRING_INDEX() 可能导致 TiFlash Crash 的问题 #9116 @wshwsh12 逻辑导出 Y Y Y Y Y Y Y Y Y Y 事务 LOAD DATA 5 Y Y Y Y Y Y Y Y Y Y 5从TiDB v7.0.0 开始新增的参数 FIELDS DEFINED NULL BY 以及新增支持从 S3 和 GCS 导入数据，均为实验特性。从TiDB v7.6.0 开始 LOAD DATA 的事务行为与 MySQL 的事务行为一致，包括事务内的 LOAD DATA playerRepository.save(player); 更多信息参考插入数据和更新数据。 查询数据 PlayerBean player = playerRepository.findById(id).orElse(null); 更多信息参考查询数据。 删除数据 playerRepository.deleteById(id); 更多信息参考删除数据。 4.3.1.4.4 下一步 • 关于本文使用到的第三方库及框架，可以参考各自官方文档：

that you first disable authentication with this com- mand: VBoxManage setproperty websrvauthlibrary null Warning: This will cause all logons to succeed, regardless of user name or password. This should of is configurable by way of the VBoxManage command: VBoxManage setproperty websrvauthlibrary default|null| This way you can specify any shared object/dynamic link module that conforms with the specifications initialize XPCOM: #include "VBoxCAPI_v2_5.h" ... PCVBOXXPCOM g_pVBoxFuncs = NULL; IVirtualBox *vbox = NULL; ISession *session = NULL; /* * VBoxGetXPCOMCFunctions() is the only function exported by * VBoxXPCOMC

that you first disable authentication with this com- mand: VBoxManage setproperty websrvauthlibrary null Warning: This will cause all logons to succeed, regardless of user name or password. This should of is configurable by way of the VBoxManage command: VBoxManage setproperty websrvauthlibrary default|null| This way you can specify any shared object/dynamic link module that conforms with the specifications initialize XPCOM: #include "VBoxCAPI_v4_3.h" ... PCVBOXXPCOM g_pVBoxFuncs = NULL; IVirtualBox *vbox = NULL; ISession *session = NULL; /* * VBoxGetXPCOMCFunctions() is the only function exported by * VBoxXPCOMC