TiFlash v5.3.4

Bug fixes

• Fix the issue that logical operators return wrong results when the argument type is UInt8 #6127
• Fix the issue that TiFlash bootstrap fails when 0.0 is used as the default value for integers, for example, `i` int(11) NOT NULL DEFAULT '0.0' #3157

TiFlash v6.4.0

Improvements

• Refactor the TiFlash MPP error handling logic to further improve the stability of MPP #5095 @windtalker
• Optimize the sorting of the TiFlash computation process, and optimize the key handling for Join and Aggregation #5294 @solotzg
• Optimize the memory usage for decoding and remove redundant transfer columns to improve Join performance #6157 @yibin87

Bug fixes

• Fix the OOM issue due to oversized WAL files that occurs when PageStorage GC does not clear the Page deletion marker properly #6163 @JaySon-Huang

TiFlash v5.4.3

Bug fixes

• Fix the issue that the format function might return a Data truncated error #4891
• Fix the issue that TiFlash might crash due to an error in parallel aggregation #5356
• Fix the panic that occurs after creating the primary index with a column containing the NULL value #5859

TiFlash v6.1.2

Bug fixes

• Fix the issue that I/O Limiter might incorrectly throttle the I/O throughput of query requests after bulk writes, which reduces the query performance #5801 @JinheLin
• Fix the issue that a window function might cause TiFlash to crash when the query is canceled #5814 @SeaRise
• Fix the panic that occurs after creating the primary index with a column containing the NULL value #5859 @JaySon-Huang

TiFlash v6.3.0

Improvements

• Support pushing down the elt function to TiFlash #5104 @Willendless
• Support pushing down the leftShift function to TiFlash #5099 @AnnieoftheStars
• Support pushing down the castTimeAsDuration function to TiFlash #5306 @AntiTopQuark
• Support pushing down the HexIntArg/HexStrArg function to TiFlash #5107 @YangKeao
• Refactor TiFlash's interpreter, and support the new interpreter Planner #4739 @SeaRise
• Improve the accuracy of memory tracker in TiFlash #5609 @bestwoody
• Improve the performance of string columns with the UTF8_BIN/ASCII_BIN/LATIN1_BIN/UTF8MB4_BIN collations #5294 @solotzg
• Calculate the I/O throughput in background in ReadLimiter #5401, #5091 @Lloyd-Pottiger

Bug fixes

• Fix the issue that a window function might cause TiFlash to crash when the query is canceled #5814 @SeaRise
• Fix the issue that wrong data input for CAST(value AS DATETIME) causing high TiFlash sys CPU #5097 @xzhangxian1008
• Fix the issue that the result of CAST(Real/Decimal AS time) is inconsistent with MySQL #3779 @mengxin9014
• Fix the issue that some obsolete data in storage cannot be deleted #5570 @JaySon-Huang
• Fix the issue that page GC might block creating tables #5697 @JaySon-Huang
• Fix the panic that occurs after creating the primary index with a column containing the NULL value #5859 @JaySon-Huang

TiFlash v6.1.1

Bug fixes

• Fix the issue that TiFlash crashes after dropping a column of a table with clustered indexes in some situations #5154 @hongyunyan
• Fix the issue that the format function might return a Data truncated error #4891 @xzhangxian1008
• Fix the issue that some obsolete data might persist in storage and cannot be deleted #5659 @lidezhu
• Fix unnecessary CPU usage in some edge cases #5409 @breezewish
• Fix a bug that TiFlash cannot work in a cluster using IPv6 #5247 @solotzg
• Fix a bug that TiFlash might crash due to an error in parallel aggregation #5356 @gengliqi
• Fix a bug that thread resources might leak in case of MinTSOScheduler query errors #5556 @windtalker

TiFlash v6.2.0

For the complete and official release notes, see https://docs.pingcap.com/tidb/v6.2/release-6.2.0.

Improvements

• Refine error handling of the TiFlash MPP engine, thereby enhancing stability #5095 @windtalker @yibin87
• Optimize the comparison and sorting of UTF8_BIN and UTF8MB4_BIN collations #5294 @solotzg

TiFlash v5.4.2

Bug Fixes

• Fix the issue that TiFlash crashes after dropping a column of a table with clustered indexes in some situations #5154
• Fix potential data inconsistency after a lot of INSERT and DELETE operations #4956
• Fix wrong decimal comparison results in corner cases #4512

TiFlash v5.3.3

There is no release note for this version.

TiFlash v5.3.2

Bug Fixes

• Fix the bug that invalid storage directory configurations lead to unexpected behaviors #4093
• Fix TiFlash_schema_error reported when NOT NULL columns are added #4596
• Fix repeated crashes caused by the commit state jump backward errors #2576
• Fix potential data inconsistency after a lot of INSERT and DELETE operations #4956
• Fix a bug that canceled MPP queries might cause tasks to hang forever when the local tunnel is enabled #4229
• Fix false reports of inconsistent TiFlash versions when TiFlash uses remote read #3713
• Fix a bug that an MPP query might fail due to random gRPC keepalive timeout #4662
• Fix a bug that an MPP query might hang forever if there are retries in the exchange receiver #3444
• Fix the wrong result that occurs when casting DATETIME to DECIMAL #4151
• Fix the overflow that occurs when casting FLOAT to DECIMAL #3998
• Fix the potential index out of bounds error if calling json_length with empty string #2705
• Fix wrong decimal comparison results in corner cases #4512
• Fix bug that MPP query may hang forever if query failed in join build stage #4195
• Fix possible wrong results when a query contains the where <string> clause #3447
• Fix the issue that the CastStringAsReal behavior is inconsistent in TiFlash and in TiDB or TiKV #3475
• Fix incorrect microsecond when casting string to datetime #3556
• Fix potential errors when querying on a table with many delete operations #4747
• Fix a bug that TiFlash reports many "Keepalive watchdog fired" errors randomly #4192
• Fix a bug that data not matching any region range remains on a TiFlash node #4414
• Fix a bug that MPP tasks might leak threads forever #4238
• Fix a bug that empty segments cannot be merged after GC #4511
• Fix the panic issue that occurs when TLS is enabled #4196
• Fix the issue that expired data is recycled slowly #4146
• Fix the bug that invalid storage directory configurations lead to unexpected behaviors #4093
• Fix the bug that some exceptions are not handled properly #4101
• Fix the potential query error after adding columns under heavy read workload #3967
• Fix the bug that the STR_TO_DATE() function incorrectly handles leading zeros when parsing microseconds #3557
• Fix the issue that TiFlash might return the EstablishMPPConnection error after it is restarted #3615