| Bug #64192 | func is the problem of ascii meta-characters | ||
|---|---|---|---|
| Submitted: | 1 Feb 2012 11:54 | Modified: | 1 Feb 2012 12:39 |
| Reporter: | c0daman boy | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: General | Severity: | S3 (Non-critical) |
| Version: | 5.1.58 | OS: | Linux (Ubuntu) |
| Assigned to: | CPU Architecture: | Any | |
[1 Feb 2012 12:39]
MySQL Verification Team
Thank you for the bug report.
h:\dbs>h:\dbs\5.1\bin\mysql -uroot --port=3510 --prompt="mysql 5.1 >"
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.62-Win X64-log Source distribution
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql 5.1 >select ascii('\'');
+-------------+
| ascii('\'') |
+-------------+
| 39 |
+-------------+
1 row in set (0.00 sec)
mysql 5.1 >select ascii("\"");
+-------------+
| ascii("\"") |
+-------------+
| 34 |
+-------------+
1 row in set (0.00 sec)
mysql 5.1 >
Description: ascii the problem of the function; mysql> select asci('''); '> ; '> ; '> ; '> ; '> ; '> ; '> ... ";" Do not want to end. or mysql> select asci("""); "> ; "> ; "> ; "> ; "> ; "> ; "> ... ";" Do not want to end. How to repeat: mysql> select asci('''); '> ; '> ; '> ; '> ; '> ; '> ; '> ... ";" Do not want to end. Suggested fix: meta