[MDEV-32987] CREATE TABLE ... LIKE is not documented completely Created: 2023-12-11 Updated: 2024-01-18 Resolved: 2024-01-16 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Data Definition - Create Table, Documentation |
| Affects Version/s: | N/A |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Oli Sennhauser | Assignee: | Ian Gilfillan |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | documentation | ||
| Environment: |
Linux n.a. |
||
| Issue Links: |
|
||||||||
| 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. " This can also be seen in the comment from Elena dated 2014-12-09 18:07 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: I have the impression that ALTER TABLE ... FORCE behaves the same but I did not investigate further... |