`CREATE VIEW IF NOT EXISTS`
Open
compatibility-mysql97
component/ddl
severity/minor
type/bug
type/compatibility
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
MySQL:
```
mysql-9.7.0 [test]> CREATE VIEW IF NOT EXISTS v1 AS (SELECT 1);
Query OK, 0 rows affected (0.002 sec)
```
TiDB v8.5.6:
```
mysql-8.0.11-TiDB-v8.5.6 [test]> CREATE VIEW IF NOT EXISTS v1 AS (SELECT 1);
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 14 near "IF NOT EXISTS v1 AS (SELECT 1)"
```
Contributor guide
Assessment
This issue has not been assessed yet.