Call for participation: fix TiDB behaviors for incompatible statements

[tangenta]

The event on improving parser compatibility has been well attended by a lot of contributors, and most of the compatibility issues have been solved.

However, there are statements that are supported syntactically by parser but not functionally by TiDB. To avoid unexpected behaviors in TiDB, we have analyzed each type of statement to decide whether TiDB should throw an error, a warning, or just ignore it.

The final implementation work is assigned to the interested contributors.

Here are some issues:

• DATABASE ENCRYPTIONFix TiDB behavior: database encryption #599 @zhaox1n Parser: Database and Table encryption (#599 #600) #717
• TABLE ENCRYPTION Fix TiDB behavior: table encryption #600 @zhaox1n Parser: Database and Table encryption (#599 #600) #717
• CONSTRAINT CHECK Fix TiDB behavior: constraint check #601 @chanme ddl: remove warning for constraint and check clause #888
• UNION Fix TiDB behavior: union #602
• REMOVE PARTITIONING Fix TiDB behavior: remove partitioning #603 @wangggong parser: remove partitioning #914
• REBUILD/CHECK/OPTIMIZE/REPAIR PARTITION Fix TiDB behavior: rebuild/check/optimize/repair partition #604
• REORGANIZE PARTITION Fix TiDB behavior: reorganize partition #605
• WITH VALIDATION Fix TiDB behavior: with validation #606
• RENAME COLUMN Fix TiDB behavior: rename column #607 @tangenta ddl: add support for renaming columns tidb#14281
• ALTER TABLE ORDER BY Fix TiDB behavior: alter table order by #608 @yuanjize ddl: throw warning when ALTER TABLE ORDER BY on table with primary key tidb#14324
• TEMPORARY TABLE Fix TiDB behavior: temporary table #609 @ffutop ddl, planner, config: report unsupported for create/drop temporary table tidb#14452 planner: include "CREATE/DROP TEMPORARY TABLE" to noop functions (##609) tidb#22860

[bb7133]

How about the TEMPORARY VIEW?

[kennytm]

@bb7133 You could edit the description to add items.

[morgo]

How about the TEMPORARY VIEW?

MySQL doesn't support such a feature. It supports global scope or statement-scoped views (aka CTEs) but not session-scoped.