Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
Linux n.a.
Description
CREATE TABLE ... LIKE creates the new table in a specific non expected way:
"The copy is created using the same version of the table storage format as the original table. "
https://dev.mysql.com/doc/refman/8.0/en/create-table-like.html
This can also be seen in the comment from Elena dated 2014-12-09 18:07
https://jira.mariadb.org/browse/MDEV-7268
This means that if the original table is in an old format with old data types the old format remains and now new data types are used.
This is IMHO fundamentally important to know as an administrator. Please add this documentation here:
https://mariadb.com/kb/en/create-table/#create-table-like
I have the impression that ALTER TABLE ... FORCE behaves the same but I did not investigate further...
Attachments
Issue Links
- blocks
-
MDEV-7268 Column of table cannot be converted from type 'decimal(0,?)' to type ' 'decimal(10,7)'
- Closed