Mattias Jonsson

ddl: Reorganize Partition failure/rollback tests and fixes

8

### What problem does this PR solve? Issue Number: ref #45133 Problem Summary: Added tests, with failpoints for onReorganizePartition and fixes for found issues. Follow up of #53277 Will see...

planner: Optimized EXTRACT(<UNIT> FROM <partition_column>) for partition pruning.

3

### What problem does this PR solve? Issue Number: close #54210 Problem Summary: ### What changed and how does it work? ### Check List Tests - [x] Unit test -...

## Bug Report Please answer these questions before submitting your issue. Thanks! ### 1. Minimal reproduce step (Required) ```mysql create table t (a datetime, b varchar(255)) partition by range (extract(year...

ALTER TABLE t ADD PARTITION needs 'PARTITIONS n' for KEY and HASH partitioning, just a number is not parsed.

1

## Change Request Please answer the following questions before submitting your issue. Thanks! 1. Describe what you find is inappropriate or missing in the existing docs. In https://docs.pingcap.com/tidb/stable/partitioned-table it says:...

Add column descriptions for INFORMATION_SCHEMA.PARTITIONS

3

## Change Request Please answer the following questions before submitting your issue. Thanks! 1. Describe what you find is inappropriate or missing in the existing docs. https://docs.pingcap.com/tidb/stable/information-schema-partitions only shows the...

Have our own reference pages instead of links.

3

## Change Request Please answer the following questions before submitting your issue. Thanks! 1. Describe what you find is inappropriate or missing in the existing docs. In the functions-and-operators directory,...

## Error Report Please answer the following questions before submitting your issue. Thanks! 1. What is the URL/path of the document related to this issue? https://docs.pingcap.com/tidb/stable/explain-indexes 2. How would you...

ddl: Enable modify column on partitioned table

5

### What problem does this PR solve? Issue Number: close #38297 ref #39915 Similar to #39922 Problem Summary: There were an issue (#39915) with modify column on partitioned tables, which...

planner: Removed check for prepared stmt during partition pruning

6

### What problem does this PR solve? Issue Number: close #55630 Problem Summary: Prepared statements would always fail partition pruning due to being a prepared statement and parameters not being...

Prepared statements results fails partition pruning if not PointGet

1

## Bug Report Please answer these questions before submitting your issue. Thanks! ### 1. Minimal reproduce step (Required) Create a sysbench table ```sh sysbench /opt/homebrew/share/sysbench/select_random_ranges.lua --mysql-host=127.0.0.1 --mysql-port=4000 --mysql-user=root --mysql-db=test --tables=1...