[MDEV-28644] Unexpected error on ALTER TABLE t1 CONVERT TO CHARACTER SET utf8mb3, DEFAULT CHARACTER SET utf8mb4 Created: 2022-05-23 Updated: 2022-06-03 Resolved: 2022-05-24 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Character Sets |
| Affects Version/s: | 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9 |
| Fix Version/s: | 10.9.2 |
| Type: | Bug | Priority: | Major |
| Reporter: | Alexander Barkov | Assignee: | Alexander Barkov |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||
| Description |
|
It's impossible to convert a table to some character set, but at the same time set the DEFAULT character set to another character set:
The problem happens because the code handling both clauses uses HA_CREATE_INFO::default_table_charset to check conflicting declarations. The test for conflicts was added by
ignored the utf8 part and just use the latin1 part for both conversion and DEFAULT. It should be fixed to allow any combinations of cs1/cl1 and cs2/cs2 in:
|
| Comments |
| Comment by Alexander Barkov [ 2022-05-24 ] |
|
Pushed in a joint patch together with |