[MDEV-21181] Automatic invisible primary key Created: 2019-11-29 Updated: 2023-11-30 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Fix Version/s: | None |
| Type: | New Feature | Priority: | Major |
| Reporter: | MG | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 2 |
| Labels: | beginner-friendly | ||
| Issue Links: |
|
||||||||||||||||||||||||||||||||
| Description |
|
Feature request - new option innodb_automatic_pk (default off, global/session) During CREATE TABLE for InnoDB, automatically translate -- FROM:
-- TO:
-- FROM:
-- TO:
It might be a good idea to modify or suppress warning "Can't DROP COLUMN `_inv_PK`" and to issue a warning that _inv_PK was created. |
| Comments |
| Comment by Daniel Black [ 2022-06-02 ] |
|
This would really help app frameworks that aren't good at doing it all at once. |
| Comment by Marko Mäkelä [ 2022-07-26 ] |
|
MySQL 8.0.30 includes WL#13784 - Create auto_increment PK on table creation when no PK is specified. |