| 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: | |
| Category: | MySQL Server | Severity: | S1 (Critical) |
| Version: | 4.0.24 | OS: | |
| Assigned to: | Jim Winstead | CPU Architecture: | Any |
[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.
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