Bug #2972 Problem the the CONV() function
Submitted: 26 Feb 2004 7:47 Modified: 15 Mar 2004 23:19
Reporter: Fred Cirera Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.1-alpha OS:FreeBSD (freebsd5.2)
Assigned to: Sergei Glukhov CPU Architecture:Any

[26 Feb 2004 7:47] Fred Cirera
Description:
The conv function doesn't work proprely. 
mysql> select CONV('64', 10, 24);
+--------------------+
| CONV('64', 10, 24) |
+--------------------+
| 2G                 |
+--------------------+
1 row in set (0.00 sec)

mysql> select CONV('2G', 24, 10);
+--------------------+
| CONV('2G', 24, 10) |
+--------------------+
| 2                  |
+--------------------+
1 row in set (0.00 sec)

mysql> Bye

How to repeat:
mysql> select CONV('64', 10, 24);
+--------------------+
| CONV('64', 10, 24) |
+--------------------+
| 2G                 |
+--------------------+
1 row in set (0.00 sec)

mysql> select CONV('2G', 24, 10);
+--------------------+
| CONV('2G', 24, 10) |
+--------------------+
| 2                  |
+--------------------+
[26 Feb 2004 8:52] Dean Ellis
Verified with 4.1.2/Linux.  Does not convert from values containing G-Z properly.

SELECT CONV(16,10,17);
SELECT CONV('G',17,10);
[15 Mar 2004 23:19] Sergei Glukhov
Fixed in 4.1 source tree