Bug #78207 | create table whose primary key had an identifier shouldn't be allowed | ||
---|---|---|---|
Submitted: | 25 Aug 2015 11:13 | Modified: | 25 Aug 2015 18:05 |
Reporter: | July July | Email Updates: | |
Status: | Verified | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S3 (Non-critical) |
Version: | 5.6.22 MySQL Community Server (GPL) | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[25 Aug 2015 11:13]
July July
[25 Aug 2015 18:05]
MySQL Verification Team
You are correct regarding naming the primary key. However, there is a restriction that it works for create_definition, and not for column_definition. It is an extension to SQL Standard, but it needs to be documented, for which reason I am verifying the bug.
[25 Aug 2015 18:12]
MySQL Verification Team
This turns out to be a bug, hence a category is changed.
[26 Aug 2020 10:52]
Jon Stephens
Still exists in MySQL 8.0.22 source build.