tidb v4.0.6 Release Notes
Release Date: 2020-09-15 // over 3 years ago-
๐ Improvements
- Replace error codes and messages with standard errors #19888
- ๐ Improve the write performance of partitioned table #19649
- Record more RPC runtime information in Cop Runtime statistics #19264
- ๐ Forbid creating tables in
metrics_schema
andperformance_schema
#19792 - ๐ Support adjusting the concurrency of the union executor #19886
- ๐ Support out join in broadcast join #19664
- โ Add SQL digest for the process list #19829
- Switch to the pessimistic transaction mode for autocommit statement retry #19796
- Support the
%r
and%T
data format inStr_to_date()
#19693 - Enable
SELECT INTO OUTFILE
to require the file privilege #19577 - ๐ Support the
stddev_pop
function #19541 - โ Add the
TiDB-Runtime
dashboard #19396 - ๐ Improve compatibility for the
ALTER TABLE
algorithms #19364 - โก๏ธ Encode
insert
/delete
/update
plans in the slow logplan
field #19269
๐ Bug Fixes
- Fix an issue of
tikv_cop_wait
time in metric profile #19881 - ๐ Fix the wrong result of
SHOW GRANTS
#19834 - ๐ Fix the incorrect query result of
!= ALL (subq)
#19831 - ๐ Fix a bug of converting the
enum
andset
types #19778 - Add a privilege check for
SHOW STATS_META
andSHOW STATS_BUCKET
#19760 - ๐ Fix the error of unmatched column lengths caused by
builtinGreatestStringSig
andbuiltinLeastStringSig
#19758 - โ If unnecessary errors or warnings occur, the vectorized control expresions fall back to their scalar execution #19749
- ๐ Fix an error of the
Apply
executor when the type of the correlation column isBit
#19692 - ๐ Fix an issue that occurs when the user queries
processlist
andcluster_log
in MySQL 8.0 client #19690 - ๐ Fix an issue that plans of the same type have different plan digests #19684
- Forbid changing the column type from
Decimal
toInt
#19682 - ๐ Fix an issue that
SELECT ... INTO OUTFILE
returns the runtime error #19672 - ๐ Fix an incorrect implementation of
builtinRealIsFalseSig
#19670 - ๐ Fix an issue that the partition expression check misses the parentheses expression #19614
- ๐ Fix a query error when there is an
Apply
executor uponHashJoin
#19611 - ๐ Fix an incorrect result of vectorization that casts
Real
asTime
#19594 - ๐ Fix a bug that the
SHOW GRANTS
statement shows grants for non-existent users #19588 - ๐ Fix a query error when there is an
Apply
executor uponIndexLookupJoin
#19566 - ๐ Fix the wrong results when converting
Apply
toHashJoin
on a partitioned table #19546 - ๐ Fix incorrect results when there is an
IndexLookUp
executor under the inner side of anApply
#19508 - ๐ Fix an unexpected panic when using view #19491
- ๐ Fix an incorrect result of
anti-semi-join
query #19477 - ๐ Fix a bug that topN statistics is not deleted when the statistics is dropped #19465
- ๐ Fix a wrong result caused by mistaken usage of batch point get #19460
- ๐ Fix a bug that a column cannot be found in
indexLookupJoin
with a virtual generated column #19439 - ๐ Fix an error that different plans of the
select
andupdate
queries compare datum #19403 - ๐ Fix a data race for TiFlash work index in region cache #19362
- ๐ Fix a bug that the
logarithm
function does not show a warning #19291 - ๐ Fix an unexpected error that occurs when TiDB persists data to disk #19272
- ๐ Support using a single partitioned table on the inner side of index join #19197
- ๐ Fix the wrong hash key value generated for decimal #19188
- ๐ Fix an issue that TiDB returns an
no regions
error when table endKey and region endKey are the same #19895 - ๐ Fix the unexpected success of alter partition #19891
- ๐ Fix the wrong value of the default maximum packet length allowed for pushed down expressions #19876
- ๐ Fix a wrong behavior for the
Max
/Min
functions on theENUM
/SET
columns #19869 - Fix read failure from the
tiflash_segments
andtiflash_tables
system tables when some TiFlash nodes are offline #19748 - ๐ Fix a wrong result of the
Count(col)
aggregation function #19628 - ๐ Fix a runtime error of the
TRUNCATE
operation #19445 - ๐ Fix the issue that
PREPARE statement FROM @Var
will fail whenVar
contains uppercase characters #19378 - ๐ Fix a bug that schema charset modification in an uppercase schema will cause panic #19302
- Fix inconsistency of plans between
information_schema.statements_summary
andexplain
, when the information containstikv/tiflash
#19159 - ๐ Fix the error in tests that the file does not exist for
select into outfile
#19725 - Fix the issue that
INFORMATION_SCHEMA.CLUSTER_HARDWARE
does not have raid device information #19457 - ๐ Make the
add index
operation that has a generated column with thecase-when
expression can exit normally when it encounters a parse error #19395 - ๐ Fix a bug that DDL takes too long to retry #19488
- ๐ Make statements like
alter table db.t1 add constraint fk foreign key (c2) references t2(c1)
execute without first executinguse db
#19471 - ๐ Change the dispatch error from an Error to an Info message in the server log file #19454