Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
ERROR 1903 (HY000): Primary key cannot be defined upon a computed column .
Virtual column was a nice way to remove stuff like
PRIMARY KEY (`COD_INV`, `COD_FAM`, `COD_MAG`, `COD_FIL`, `COD_ID_INV`)
- It's a bad practice to use triggers
- It's a bad practice to use hidden primary key ,
- It's a bad practice to use virtual column .
What could we advice that can be transparent to the application layer to fixe such bad design for InnoDB.
Rewrite the application is not always a political correct answer.
Attachments
Issue Links
- duplicates
-
MDEV-8135 Support primary keys on virtual columns
- Closed
- is part of
-
MDEV-10137 Providing compatibility to other databases
- Open