System variables Variable name Change type Description cte_max_recursion_depth �→ Newly added Controls the maximum recursion depth in Common Table Expressions. init_connect �→ Newly added Controls the optimizer builds the IndexMerge plan for clustered indexes #23906 – Fix the type inference of the BIT-type errors #23832 – Fix the issue that some optimizer hints do not take effect when the PointGet String functions Y Y Y Y Numeric functions and operators Y Y Y Y Date and time functions Y Y Y Y Bit functions and operators Y Y Y Y Cast functions and operators Y Y Y Y Encryption and compression functions

conversion function: CAST(time, real) * Aggregation functions: GROUP_CONCAT(), SUM(enum) – Support 512-bit SIMD – Enhance the cleanup algorithm for outdated data to reduce disk usage and read files more efficiently functions Y Y Y Y Y Numeric functions and operators Y Y Y Y Y Date and time functions Y Y Y Y Y Bit functions and operators Y Y Y Y Y Cast functions and operators Y Y Y Y Y Encryption and compression numa 2.0.12 or later tar any 4.1.3 Server recommendations You can deploy and run TiDB on the 64-bit generic hardware server platform in the Intel x86-64 architecture or on the hardware server platform

String functions Y Y Y Y Numeric functions and operators Y Y Y Y Date and time functions Y Y Y Y Bit functions and operators Y Y Y Y Cast functions and operators Y Y Y Y Encryption and compression functions numa 2.0.12 or later tar any 4.1.3 Server recommendations You can deploy and run TiDB on the 64-bit generic hardware server platform in the Intel x86-64 architecture or on the hardware server platform For the table with the primary key of the NONCLUSTERED type, TiDB uses an automatically allocated 64-bit integer as the RowID. In this case, you can use the SHARD_ROW_ID_BITS feature. For more details about

functions Y Y Y Y Y Y Numeric functions and operators Y Y Y Y Y Y Date and time functions Y Y Y Y Y Y Bit functions and operators Y Y Y Y Y Y Cast functions and operators Y Y Y Y Y Y Encryption and compression numa 2.0.12 or later tar any 4.1.3 Server recommendations You can deploy and run TiDB on the 64-bit generic hardware server platform in the Intel x86-64 architecture or on the hardware server platform is inconsistent | Online check is not supported for data migration between MySQL and TiDB. JSON, BIT, BINARY, BLOB and other types of data are not supported. | 5.2.1 Install tools using TiUP Since

fixes • TiDB • Fix the issue of possible panic that might occur when the in function processes the bit type data #33070 • Fix the issue of wrong query result because the UnionScan operator cannot main- Y Y Y Numeric functions and operators Y Y Y Y Y Y Y Y Date and time functions Y Y Y Y Y Y Y Y Bit functions and operators Y Y Y Y Y Y Y Y Cast functions and operators Y Y Y Y Y Y Y Y Encryption data types and use the data types that match the data you want to save in the database. To make it a bit more complex, you can define a books table which will be the core of the bookshop data. The books table

added Specifies the en- cryption key in hexadeci- mal string format for log backup data. It is a 128-bit (16 bytes) key for the algo- rithm aes128- �→ ctr, a 24-byte key for the algo- rithm aes192- �→ ctr @hbisheng • TiFlash • Fix the issue that TiFlash fails to parse the table schema when the table contains Bit-type columns with a default value that contains invalid characters #9461 @Lloyd-Pottiger • Fix the functions and operators Y Y Y Y Y Y Y Y Y Y Y Y Date and time functions Y Y Y Y Y Y Y Y Y Y Y Y Bit functions and operators Y Y Y Y Y Y Y Y Y Y Y Y Cast functions and operators Y Y Y Y Y Y Y Y Y Y Y

added Specifies the en- cryption key in hexadeci- mal string format for log backup data. It is a 128-bit (16 bytes) key for the algo- rithm aes128- �→ ctr, a 24-byte key for the algo- rithm aes192- �→ ctr @hbisheng • TiFlash • Fix the issue that TiFlash fails to parse the table schema when the table contains Bit-type columns with a default value that contains invalid characters #9461 @Lloyd-Pottiger • Fix the functions and operators Y Y Y Y Y Y Y Y Y Y Y Y Date and time functions Y Y Y Y Y Y Y Y Y Y Y Y Bit functions and operators Y Y Y Y Y Y Y Y Y Y Y Y Cast functions and operators Y Y Y Y Y Y Y Y Y Y Y

Numeric functions and operators Y Y Y Y Y Y Y Y Y Y Y Date and time functions Y Y Y Y Y Y Y Y Y Y Y Bit functions and operators Y Y Y Y Y Y Y Y Y Y Y Cast functions and operators Y Y Y Y Y Y Y Y Y Y Y data types and use the data types that match the data you want to save in the database. To make it a bit more complex, you can define a books table which will be the core of the bookshop data. The books table example. The 64-bit ID structure generated by uid-generator is as follows: | sign | delta seconds | worker node id | sequencs | |------|---------------|----------------|----------| | 1bit | 28bits | 22bits

limit �→ Modified Changes the max- imum value from 18446744073709551615 �→ (64-bit plat- form) and 4294967295 �→ (32-bit plat- form) to 1048576 to avoid causing TiDB Server OOM when setting it too large Numeric functions and operators Y Y Y Y Y Y Y Y Y Y Date and time functions Y Y Y Y Y Y Y Y Y Y Bit functions and operators Y Y Y Y Y Y Y Y Y Y Cast functions and operators Y Y Y Y Y Y Y Y Y Y Encryption data types and use the data types that match the data you want to save in the database. To make it a bit more complex, you can define a books table which will be the core of the bookshop data. The books table

5.1 Numeric functions and operators Y Y Y Y Y Y Y Y Y Date and time functions Y Y Y Y Y Y Y Y Y Bit functions and operators Y Y Y Y Y Y Y Y Y Cast functions and operators Y Y Y Y Y Y Y Y Y Encryption data types and use the data types that match the data you want to save in the database. To make it a bit more complex, you can define a books table which will be the core of the bookshop data. The books table example. The 64-bit ID structure generated by uid-generator is as follows: | sign | delta seconds | worker node id | sequencs | |------|---------------|----------------|----------| | 1bit | 28bits | 22bits