| Bug #118249 | Cannot convert string '\xF0\x9F\x98\xA6\xF0\x9F...' from utf8mb4 to latin1 | ||
|---|---|---|---|
| Submitted: | 22 May 9:51 | Modified: | 24 Jul 12:27 |
| Reporter: | fent allen | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Charsets | Severity: | S3 (Non-critical) |
| Version: | 8.0.41 | OS: | Linux |
| Assigned to: | CPU Architecture: | Any | |
[22 May 10:37]
MySQL Verification Team
Hello Fent Allen, Thank you for the bug report. Could you please provide test case(create table and sample data) to reproduce this issue at our end? Thanks. Regards, Ashwini Patil
[24 Jul 12:27]
MySQL Verification Team
Hello Fent Allen, Thank you for the bug report. Imho this is duplicate of Bug #118400, please see Bug #118400. Regards, Ashwini Patil
Description: When the Select Operation Is Executed: ERROR 3854 (HY000): Cannot convert string '\xF0\x9F\x98\xA6\xF0\x9F...' from utf8mb4 to latin1 Is Displayed How to repeat: For details about tbl_1_all_type2index_desc.sql/tbl_1_all_type2index.sql. see the attachment. source tbl_1_all_type2index_desc.sql source tbl_1_all_type2index.sql select col1, col2, ifnull(col2,col3) as col3, col4, col3+col4 col5,if(strcmp(col1,col2),col1,col2) as col6,case when strcmp(col1,col3) then col1 else col3 end as col7 from (select char_col col1, varbinary_col col2, timestamp_col col3, max(id_col) col4 from (select 1 order by 1) b inner join tbl_1_all_type2index c on 0=1 or c.varbinary_col < c.timestamp_col where 0=0 xor c.timestamp_col is null group by 1,2,3 order by 1,2,3,4) a group by 1,2,3,4,5,6,7 having 0=0 xor col1 in ('aaa2', 'aaaa', 'aabb', 'aacd', 'ab', 'null') order by 1,2,3,4,5,6,7 limit 10;