Bug #795 HANDLER doesn't work with variables

• Submitted: 5 Jul 2003 12:16
• Modified: 5 Jul 2003 13:14
• Reporter: Georg Richter
• Status: Not a Bug
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1
• OS: Linux (Linux)
• CPU Architecture: Any

[5 Jul 2003 12:16] Georg Richter

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