linux-traipu team mailing list archive

[Henrik Ingo <henrik.ingo@xxxxxxxxxxxxx>]

Let's look at the manual a little:

http://dev.mysql.com/doc/refman/5.1/en/string-
functions.html#function_unhex

"The return value is a binary string."

So the return value of UNHEX might very well be 2, but it is not of a
numeric type, rather a string. Since the value 2 in UTF-8 (or ASCII, see
http://www.asciitable.com/) doesn't map to any visible character, it
seems the output is correct.

In fact, you can see the number 2 by using the ASCII() function:

drizzle> SELECT ASCII(UNHEX(2));
+-----------------+
| ASCII(UNHEX(2)) |
+-----------------+
|               2 | 
+-----------------+
1 row in set (0.005334 sec)


Otoh, if you tried UNHEX('41') you should see 'A'.

drizzle> SELECT ASCII('A');
+------------+
| ASCII('A') |
+------------+
|         65 | 
+------------+
1 row in set (0.00017 sec)

drizzle> SELECT HEX('A');
+----------+
| HEX('A') |
+----------+
| 41       | 
+----------+
1 row in set (0.000176 sec)

drizzle> SELECT UNHEX(41);
+-----------+
| UNHEX(41) |
+-----------+
| A         | 
+-----------+
1 row in set (0.000165 sec)

drizzle>


(Where 65 in decimal is 41 in hex.)

I'm closing this bug then.

** Changed in: drizzle
       Status: New => Invalid

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/923330

Title:
  unhex function is giving garbage results

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  Invalid

Bug description:
  "unhex()" function is not working properly and is returning garbage
  values.

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/923330/+subscriptions