Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.15
-
None
Description
Both these terms set the default_table_charset attribute internally so whenever used they should be the same value.
Alter table xxx CONVERT TO CHARACTER SET latin1, CHARACTER SET utf8 has protection mechanism that result in an error.
However Alter table xxx CHARACTER SET utf8, CONVERT TO CHARACTER SET latin1 will ignore the utf8 and just use the latin1 for the default charset and conversion.
How to repeat:
Alter table xxx CHARACTER SET utf8, CONVERT TO CHARACTER SET latin1
on any table.
The resting table will have DEFAULT CHARSET=latin1
Attached patch causes and error consistent with Alter table xxx CONVERT TO CHARACTER SET latin1, CHARACTER SET utf8
Attachments
Issue Links
- relates to
-
MDEV-27896 Wrong result upon `COLLATE latin1_bin CHARACTER SET latin1` on the table or the database level
- Closed
- links to