« Changelog History


tidb v3.0.10 Release Notes

Release Date: 2020-02-20 // about 4 years ago

  • ⚡️ SQL Optimizer

    • 🛠 Fix the incorrect time zone results when the unixtimestamp expression calculates the time zone of the table partitions #14476
    • 🛠 Fix the system panic issue caused by incorrect processing logic during CM-Sketch statistics initialization #14470
    • 🛠 Fix the issue that the default database name of the SQL statement in SQL bindings is set incorrectly #14548
    • 🛠 Fix the issue that json_key is not compatible with MySQL #14561
    • ➕ Add the feature of automatically updating the statistics of partitioned tables #14566
    • 🛠 Fix the issue that the plan ID changes when the PointGet operation is executed (the plan ID is expected to be 1 always) #14595
    • 🛠 Fix the system panic issue caused by incorrect processing logic when SQL bindings do not match exactly #14263
    • 🛠 Fix the issue that characters in JSON such as &, < and > are incorrectly escaped #14637
    • 🛠 Fix the panic issue caused by incorrect processing logic when an SQL binding processes illegal records #14645
    • 🛠 Fix a MySQL incompatibility issue by adding Truncated error detection to decimal division calculation #14673
    • SQL Execution Engine
    • 🛠 Fix wrong Join results when IndexLookUpJoin uses OtherCondition to construct InnerRange #14599
    • Correct the expression name of the IsTrue function #14516
    • 🛠 Fix the system panic issue caused by excessive memory usage when the HashJoin operation is building a hash table #14642

    Transaction

    • 🛠 Fix the issue that data visibility does not meet expectations due to transaction timeout when executing PointGet operations #14480
    • 🔄 Change the timing of pessimistic transaction activation to delayed activation, consistent with the optimistic transaction mode #14474

    Server

    • Delete the tidb_pprof_sql_cpu configuration item and add the tidb_pprof_sql_cpu variable #14416
    • 🛠 Fix the issue that users can query all databases only when they have global privileges #14386
    • Add the tidb_session_statement_deadlock_detect_duration_seconds monitoring item to monitor deadlock detection duration #14484
    • 🛠 Fix the system panic issue caused by some logic errors of GC workers #14439
    • 🛠 Fix the issue that some memory usage is counted inaccurately #14533
    • Add the tidb_session_statement_pessimistic_retry_count monitoring item to monitor the number of retries after the failure to lock pessimistic transactions #14619
    • 🛠 Fix the incorrect privilege check for show binding statements #14618
    • 🛠 Fix the issue that the query cannot be killed because the backoff logic does not include checking the killed tag #14614
    • 👌 Improve the performance of statement summary by reducing the time to hold internal locks #14627
    • 🛠 Fix the issue that TiDB's result of parsing strings to time is incompatible with MySQL #14570
    • 🔊 Record the user login failures in audit logs #14620
    • Add the tidb_session_ statement_lock_keys_count monitoring item to monitor the number of lock keys for pessimistic transactions #14634
    • 🛠 Fix the issue of successfully granting users privileges on a table that does not exist #14611