Bug #2972 Problem the the CONV() function

• Submitted: 26 Feb 2004 7:47
• Modified: 15 Mar 2004 23:19
• Reporter: Fred Cirera
• Status: Closed
• 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