the projection result is empty #23887 – Fix the issue of wrong query results when a column contains NULL values in some cases #23891 – Forbid generating MPP plans when the scan contains virtual columns consecutive and fast writes might make TiFlash out of memory – Fix the potential issue that the exception of null pointer might be raised during the table GC – Fix the TiFlash panic issue that occurs when writing bikeshare; USE bikeshare; CREATE TABLE trips ( 87 trip_id bigint NOT NULL PRIMARY KEY AUTO_INCREMENT, duration integer not null, start_date datetime, end_date datetime, start_station_number integer,

SHOW VIEW permission to execute the SHOW CREATE VIEW statement. • The system variable sql_auto_is_null is added to the noop functions. When tidb_enable_noop_functions = 0/OFF, modifying this variable value value of the plugin_dir configuration #28084 – Fix the issue that the CONVERT_TZ function returns NULL when it is given a named timezone and a UTC offset #8311 – Fix the issue that CREATE SCHEMA does DATABASE bikeshare; USE bikeshare; CREATE TABLE trips ( trip_id bigint NOT NULL PRIMARY KEY AUTO_INCREMENT, 107 duration integer not null, start_date datetime, end_date datetime, start_station_number integer

characters by other characters in a string. In TiDB, this function does not treat empty strings as NULL as Oracle does. User document • Support spilling HashAgg Support spilling HashAgg into disk. When panic issue that might occur when the Date_Format function is called with the STRING type argument and NULL values • Tools – TiCDC * Fix a bug that TiCDC owner exits abnormally when refreshing the checkpoint DATABASE bikeshare; USE bikeshare; CREATE TABLE trips ( trip_id bigint NOT NULL PRIMARY KEY AUTO_INCREMENT, 95 duration integer not null, start_date datetime, end_date datetime, start_station_number integer

current session. The default value is 0. tidb_regard_null_as_point �→ Newly added Controls whether the optimizer can use a query condition including null equivalence as a prefix condition for index access 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, CREATE TABLE `tab_tidb` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL DEFAULT '', `age` int(11) NOT NULL DEFAULT 0, `version` varchar(20) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `idx_age`

consistent with MySQL 8.0 #49227 @lcwangchao • Fix the issue that the ROW function incorrectly infers the null type and causes an unexpected error #49015 @wshwsh12 • Fix the issue that the ILIKE function might histogram statistics might not be parsed into readable strings when the histogram boundary contains NULL #49823 @AilinKid • Fix the issue that executing queries containing the GROUP_CONCAT(ORDER BY) 68 cap- ture (CDC) 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

• Fix the issue of local backend import failure when the auto_random or auto_increment column is null #34208 85 2.3 TiDB Features This document lists the features supported in each TiDB version. Note DATABASE bikeshare; USE bikeshare; CREATE TABLE trips ( trip_id bigint NOT NULL PRIMARY KEY AUTO_INCREMENT, 137 duration integer not null, start_date datetime, end_date datetime, start_station_number integer sequence player_jpa_id_seq start with 1 increment by 1 Hibernate: create table player_jpa (id bigint not null, coins integer, goods �→ integer, primary key (id)) engine=InnoDB 2023-01-05T14:06:55.332+08:00

�→ DATA �→ 5 Y Y Y Y Y Y Y Y Y N 6 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. 6For TiDB v4.0, the LOAD 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, Insert data and Update data. Query data PlayerBean player = playerRepository.findById(id).orElse(null); For more information, refer to Query data. Delete data playerRepository.deleteById(id); For

· · · · · · · · · · · · · · · · · · · · · 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