← Back to team overview

linux-traipu team mailing list archive

[Bug 923330] Re: unhex function is giving garbage results

 

Hi Henrik, the "unhex()" function is not giving correct values for any
of the input value i tried. below are some of the trials i made..

drizzle> select unhex(2);
+----------+
| unhex(2) |
+----------+
|         |            <-------------- correct result should be: 2
+----------+
1 row in set (0.000283 sec)

drizzle> select unhex(hex(2));
+---------------+
| unhex(hex(2)) |
+---------------+
|              |             <-------------- correct result should be: 2
+---------------+
1 row in set (0.000245 sec)

drizzle> select unhex("A1");
+-------------+
| unhex("A1") |            <-------------- correct result should be: 161
+-------------+
| �           | 
+-------------+
1 row in set (0.000247 sec)

-- 
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:
  New

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


References