From: Michael Widenius
Date: February 24 2000 12:41pm
Subject: large hexdecimal constant dosen't work on WHERE
List-Archive: http://lists.mysql.com/bugs/23
Message-Id: <14517.9961.619667.925979@monty.pp.sci.fi>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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