Bug #795 HANDLER doesn't work with variables
Submitted: 5 Jul 2003 12:16 Modified: 5 Jul 2003 13:14
Reporter: Georg Richter Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1 OS:Linux (Linux)
Assigned to: CPU Architecture:Any

[5 Jul 2003 12:16] Georg Richter
when you specify a user defined variable for an index value in HANDLER READ an empty resultset will be returned..

How to repeat:
mysql> create table a (a int, index(a));
Query OK, 0 rows affected (0.00 sec)

mysql> insert into a values (1),(2),(3);
Query OK, 3 rows affected (0.00 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> handler a open;
Query OK, 0 rows affected (0.01 sec)

mysql> handler a read a=(2);
| a    |
|    2 |
1 row in set (0.00 sec)

mysql> set @a:=2;
Query OK, 0 rows affected (0.00 sec)

mysql> handler a read a=(@a);
Empty set (0.00 sec)
[5 Jul 2003 13:14] Sergei Golubchik
Please do not submit the same bug more than once. An existing
bug report already describes this very problem. Even if you feel
that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments
to the original bug instead.

Thank you for your interest in MySQL.

same as #751 (even if it does not look so :)) - but fixed with the fix of #751.
That is - fixed in 4.0.14