Call For Participation: SIG-DDL 2020/Q1 Plan

[zimulala]

We have listed the 2020 development plans for DDL and parsers.
If you are interested in some features, you can join #sig-ddl on slack in your spare time to discuss and get help with others.

Some of these issues are still in their early stages and any discussion is welcome.
We are waiting for you!

O1: Compatibility && New Feature

DDL KRs：

• Auto_increment is not compatible with MySQL Auto_increment is not compatible with MySQL #13032 Difficulty: easy assignee: @Rustin-Liu
• Fix "drop table if exists" no warning info DROP TABLE IF EXISTS behavior difference #7867 Difficulty: easy
• Support temporary table Support temporary table #1248
• Support ascending or descending index Support ascending or descending index  #2519
• Support invisible Indexes UCP: Support Invisible Indexes #9246
• Increase the priority of DDL in bootstrap Increase the priority of DDL in bootstrap #7024
• Dropping a column isn't reducing the disk size Dropping a column isn't reducing the disk size #8673

Support the operation of adding multi-schema change in one statement #14766

• Support multiple table rename (swap table use case) Support multiple table rename (swap table use case) #9384
• Support the operation of adding multi-columns UCP: Support the operation of adding multi-columns  #5092
• ropping column with index covered isn't fully compatible with mysql dropping column with index covered isn't fully compatible with mysql #3364
• Support the operation of dropping multi-indexes in one statement Support the operation of dropping multi-indexes in one statement #14765

Parser KRs：

• Support syntax: SELECT ... INTO OUTFILE Support the SELECT ... INTO OUTFILE syntax parser#722 Difficulty: easy
• Support syntax: AND NO CHAIN NO RELEASE Make TiDB accept 'AND NO CHAIN NO RELEASE' in SQL syntax parser#649 Difficulty: easy
• Support syntax: ANALYZE TABLE .. UPDATE HISTOGRAM Support ANALYZE TABLE .. UPDATE HISTOGRAM syntax parser#361 Difficulty: easy
• Support WHERE / GROUP BY clauses in a SELECT statement without a FROM table Failed to parse WHERE / GROUP BY clauses in a SELECT statement without a FROM table parser#115 Difficulty: easy
• Support syntax: hex & bit literals follows UNDERSCORE_CHARSET hex & bit literals are not allowed to follow with UNDERSCORE_CHARSET parser#451 Difficulty: easy
• Support syntax: CTEs Support CTEs (WITH statement) parser#289

O2: Bugfix

DDL KRs：

• Partition name is not quoted in the output of "SHOW CREATE TABLE" command assignee: @Rustin-Liu
• The "varchar" type column flags are not compatible with MySQL The "varchar" type column flags are not compatible with MySQL #13992
• After executing "modify column", its flag has changed After executing "modify column", its flag has changed #11850 Difficulty: easy
• Should not add an index of length 0 to columns of type Blob, text, etc Should not add an index of length 0 to columns of type Blob, text, etc. #11049 Difficulty: easy

O3: Code optimization && Test

DDL KRs：

• Verify that the DDL leases of all TiDBs in the cluster are consistent Verify that the DDL leases of all TiDBs in the cluster are consistent #14760 Difficulty: easy
• Improve the processing speed of general DDL jobs Improve the processing speed of general DDL jobs #14770
• Improve the performance of CREATE INDEX statement Improve the performance of CREATE INDEX statement #12963
• Migrate the infoschema's retrieving data logic for sys table to executor infoschema: Migrate the infoschema's retrieving data logic for sys table to executor #14828. There are some other func of retrieving data in infoschema/tables.go ：
  dataForTables()
  dataForIndexes()
  dataForColumns()
  dataForStatistics()
  ...

Parser KRs：

• Add incompatible syntax error or warning Call for participation: fix TiDB behaviors for incompatible statements parser#598 Difficulty: easy
• Fix static check Staticcheck report parser#714 Difficulty: easy

[Rustin170506]

pick up #11049 .
@zimulala Fixed , PTAL~

[Rustin170506]

pick up #13992 and #11850

[Rustin170506]

puck up #7867
@zimulala Fixed, it seems CI broken because my code changes. PTAL~

[Deardrops]

Pick up Support invisible Indexes #9246

[chanme]

pick up #14765

[wangggong]

I'll pickup pingcap/parser#925 & pingcap/parser#451. Thx.