Bug #113778 | Encoding problem in xpath comparision | ||
---|---|---|---|
Submitted: | 26 Jan 15:40 | Modified: | 28 Aug 16:56 |
Reporter: | Stefano Valsecchi | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: XML functions | Severity: | S3 (Non-critical) |
Version: | 8.0 | OS: | Any |
Assigned to: | CPU Architecture: | Any |
[26 Jan 15:40]
Stefano Valsecchi
[26 Jan 16:02]
Stefano Valsecchi
Bug verified also on x86 architecture (db.m6i.large instance on AWS RDS)
[29 Jan 11:05]
MySQL Verification Team
Hi Mr. Valsecchi, Thank you for your bug report. We have managed to repeat the problem with 8.0.36: mysql> SELECT EXTRACTVALUE('<A><B>ee</B><C>AA</C></A>', '/A[B = "ee"]/C'); +-------------------------------------------------------------+ | EXTRACTVALUE('<A><B>ee</B><C>AA</C></A>', '/A[B = "ee"]/C') | +-------------------------------------------------------------+ | AA | +-------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT EXTRACTVALUE('<A><B>èè</B><C>AA</C></A>', '/A[B = "èè"]/C'); +-----------------------------------------------------------------+ | EXTRACTVALUE('<A><B>èè</B><C>AA</C></A>', '/A[B = "èè"]/C') | +-----------------------------------------------------------------+ | | +-----------------------------------------------------------------+ 1 row in set (0.00 sec) This is now a verified bug report.
[28 Aug 16:56]
Jon Stephens
Documented fix as follows in the MySQL 8.4.3 and 9.1.0 changelogs: ExtractValue() did not handle arguments containing accented characters correctly. Closed.
[16 Sep 9:36]
MySQL Verification Team
Thank you, Jon.