Bug #8248 QUOTE() returns bad results
Submitted: 1 Feb 2005 23:30 Modified: 3 Feb 2005 5:39
Reporter: Dean Ellis Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.0.24 OS:
Assigned to: Jim Winstead CPU Architecture:Any

[1 Feb 2005 23:30] Dean Ellis
Description:
QUOTE() returns bad results.

How to repeat:
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 SELECT 1 UNION SELECT 2 UNION SELECT 3;
SELECT QUOTE('A') FROM t1;

+-----------------+
| QUOTE('A')      |
+-----------------+
| 'A'             |
| '\'A\''         |
| '\'\\\'A\\\'\'' |
+-----------------+

Suggested fix:
n/a
[2 Feb 2005 17:45] Jim Winstead
Pushed to 4.0.
[3 Feb 2005 5:39] Paul Dubois
Mentioned in 4.0.24 change notes.