Bug #105257 prepare statement return result is different from execute it directly
Submitted: 19 Oct 2021 3:58 Modified: 19 Oct 2021 7:03
Reporter: x j Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Prepared statements Severity:S3 (Non-critical)
Version:8.0, 5.7.35, 8.0.26 OS:Any
Assigned to: CPU Architecture:Any

[19 Oct 2021 3:58] x j 
Description:
prepare statement return hard to understand result

How to repeat:
set names utf8mb4;
prepare p1 from "select '😂';";
mysql> execute p1;
+---+
| ? |
+---+
| ? |
+---+
1 row in set (0.00 sec)
[19 Oct 2021 3:59] x j 
if execute the query directly
mysql> select '😂';
+------+
| ?    |
+------+
| 😂     |
+------+
1 row in set (0.00 sec)
[19 Oct 2021 5:29] MySQL Verification Team 
Hello x j,

Thank you for the report and test case.

regards,
Umesh