Bug #751 Server crash with HANDLER
Submitted: 29 Jun 2003 23:27 Modified: 3 Jul 2003 10:39
Reporter: Georg Richter Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S1 (Critical)
Version:4.0 + 4.1 OS:Linux (Linux)
Assigned to: Alexey Botchkov CPU Architecture:Any

[29 Jun 2003 23:27] Georg Richter
Description:
it's a little bit crazy: I made a typo in a handler statement (W instead 2) and this crashes the server :)

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

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

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

mysql> handler a read a=(W);
ERROR 2013 (HY000): Lost connection to MySQL server during query
[30 Jun 2003 4:23] MySQL Verification Team
Thank you for the bug report. I was be able to repeat on
4.0.13 Windows release.

Back trace:

>	mysqld.exe!Field::is_null(unsigned int row_offset=0)  Line 107 + 0xf C++
 	mysqld.exe!Item_field::save_in_field(Field * to=0x0113d9c8, int no_conversions=1)  Line 445 + 0xd	C++
 	mysqld.exe!mysql_ha_read(THD * thd=0x01139f48, st_table_list * tables=0x0112c0e8, enum_ha_read_modes mode=RKEY, char * keyname=0x0112c140, List<Item> * key_expr=0x0112c148, ha_rkey_function ha_rkey_mode=HA_READ_KEY_EXACT, Item * cond=0x00000000, unsigned long select_limit=1, unsigned long offset_limit=0)  Line 197	C++
 	mysqld.exe!mysql_execute_command()  Line 2465 + 0x4a	C++
 	mysqld.exe!mysql_parse(THD * thd=0x01139f48, char * inBuf=0x0112c0a8, unsigned int length=20)  Line 2888	C++
 	mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x01139f48, char * packet=0x0113a7c1, unsigned int packet_length=20)  Line 1049 + 0x17	C++
 	mysqld.exe!do_command(THD * thd=0x01139f48)  Line 924 + 0x37	C++
 	mysqld.exe!handle_one_connection(void * arg=0x01139f48)  Line 714 + 0x9	C++
 	mysqld.exe!pthread_start(void * param=0x01129f80)  Line 63 + 0x7	C
 	mysqld.exe!_threadstart(void * ptd=0x011312c0)  Line 173 + 0xd	C
 	KERNEL32.DLL!77e8b2d8()
[3 Jul 2003 8:49] Alexey Botchkov
changeset 1.1494 (03.06.03)
[3 Jul 2003 10:39] Alexey Botchkov
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html