Make TiDB output of show create table simpler and allow to break MySQL compatibility
Open
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
Working on #35683 the need of allowing non-compatible MySQL syntax is clear. But it would also remove non-needed MySQL compatibility syntax that is not used in TiDB, like `ENGINE = InnoDB`
This Feature request is to create `tidb_extension_non_mysql_compatible` system variable to allow TiDB extensions that are not compatible with MySQL, and remove MySQL specific syntax that is not used by TiDB.
Contributor guide
Assessment
This issue has not been assessed yet.