Bug #1868 Error in QUOTE() function
Submitted: 18 Nov 2003 5:07 Modified: 12 Dec 2003 4:43
Reporter: [ name withheld ] Email Updates:
Status: Closed Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:4.0.16-nt OS:Windows (Windows 2000)
Assigned to: Bugs System CPU Architecture:Any

[18 Nov 2003 5:07] [ name withheld ]
If parameter contains symbols with a code more than 127 - function will return value with leading dust.

How to repeat:
select hex(quote(concat(char(224),char(227),char(230),char(231),char(232),char(234),char(235))))


must be


Suggested fix:
File: sql\item_strfunc.cpp
Function: String *Item_func_quote::val_str(String *str)

instead declaration
  char *from, *to, *end, *start;

must be
  uchar *from, *to, *end, *start;
[18 Nov 2003 14:42] Dean Ellis
Verified in 4.0.16 on Windows.  Does not occur in 4.0.17/Linux.

Thank you.
[12 Dec 2003 4:37] Michael Widenius
Thanks for the exellent bug report.
The fix will be in 4.0.17
[12 Dec 2003 4:43] Victor Vagin
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at