List:Bugs« Previous MessageNext Message »
From:Michael Widenius Date:February 24 2000 12:41pm
Subject:large hexdecimal constant dosen't work on WHERE
View as plain text  
Hi!

>Description:
large hexdecimal constant dosen't work on WHERE

<cut>

It seams that this works on in the development version of MySQL
3.23.12:

mysql> create table SAMPLE (ID int(8) unsigned zerofill not null auto_increment,UNIQ
> bigint(21) unsigned zerofill not null,primary key (ID),unique (UNIQ) );
Query OK, 0 rows affected (1.62 sec)

mysql> insert into SAMPLE set UNIQ=0x38afba1d73e6a18a;
Query OK, 1 row affected (0.12 sec)

mysql> insert into SAMPLE set UNIQ=123;
Query OK, 1 row affected (0.00 sec)

mysql> explain select * from SAMPLE where UNIQ=0x38afba1d73e6a18a;
+--------+-------+---------------+------+---------+-------+------+-------+
| table  | type  | possible_keys | key  | key_len | ref   | rows | Extra |
+--------+-------+---------------+------+---------+-------+------+-------+
| SAMPLE | const | UNIQ          | UNIQ |       8 | const |    1 |       |
+--------+-------+---------------+------+---------+-------+------+-------+
1 row in set (0.30 sec)

mysql> select * from SAMPLE where UNIQ=0x38afba1d73e6a18a;
+----------+-----------------------+
| ID       | UNIQ                  |
+----------+-----------------------+
| 00000001 | 004084688022709641610 |
+----------+-----------------------+
1 row in set (0.00 sec)


Could you please verify this when 3.23.12 is out (hopefully today or
tomorrow).

Regards,
Monty
Thread
large hexdecimal constant dosen't work on WHEREMichael Widenius24 Feb