Support list (columns) partition table

[crazycs520]

Development Task

feature development

• [P1] Support create list partition table ddl: support create list partition table #20279
• [P1] Support DML(insert/update/delete) on list partition table ddl: support create list partition table #20279
  • add more test executor: add test for insert/update/delete list [columns] partition #20635
• [P1] Support add/drop partition DDL on list partition table ddl: support add/drop list (columns) partition #20631
• [P1] Support show create table on list partition table *: make explain result more clearly. #2063
• [P1] Disable list partition by default. config: disable list partition by default since it's an experimental feature #22045
• [P2] Support default partition for list (columns) partition table (need discuss first) Support default partition for list (columns) partition table #20679

Performance optimization

• [P1] Implement partition pruner for list partition, this is used to speed up query list partition table. planner: add partition pruner for list (columns) partition #20740
• [P1] optimize the list columns partition pruner optimize the list columns partition pruner #21383 planner: add special partition pruner for list columns partition #21577
• [P1] optimize the list partition pruner performance in huge partitions optimize the list partition pruner performance in huge partitions #21778 planner: add special partition pruner for list columns partition #21577
• [P2] optimize the list partition pruner for range query, such the query condition is a > 0 and a < 10 optimize the list partition pruner for range query, #22144

Test

• [P1] Port partition list test from mysql https://github.com/pingcap/tidb-test/pull/1095
• [P1] Add more unit/integration test and fix the found bug:
  • [P1] add more ddl test and fix tiny bugs ddl: fix create list partition bug and add more test #21398
  • [P1] add more dml(insert/delete/update/replace) test *: fix tiny bug and add more DML test for list partition table #21423
  • [P1] create columns partition table failed when contain SQL key word create columns partition table failed when contain SQL key word  #21574
  • [P1] add more test case from QA. ddl: add more ddl test for list partition #21693
  • [P1] add test for plan cache for query on list partition test: add test for plan cache for query on list partition #21698
  • [P1] executor: add auto_random, auto_increment, generated column, global index test for list (columns) partition executor: add auto_random, auto_increment, generated column, global index test for list (columns) partition #21725
• [P1] add more test with other component
  • TiCDC https://github.com/pingcap/ticdc/pull/1229

Document

• [P1] english: https://docs.pingcap.com/tidb/stable/partitioned-table#partition-selection
• [P1] chinese: Add doc for List partition and List columns partition docs-cn#5132

[mjonss]

/component tablepartition

[shiyuhang0]

Does list columns with multi-column supports partition pruning?

[bb7133]

@crazycs520 @mjonss Could we close this issue now?

[mjonss]

List Columns partitioning is GA since v6.5, so closing this.