reason of can not insert rows into myisam table using HandlerSocktet

[林晓斌]

I try to insert one row into a myisam table, use perl client written as
"my $res = $hs->open_index(0, 'test', 'sbtest', 'PRIMARY', 'id,k,c,pad');
$res = $hs->execute_single(0, '+', ["1", "100", "a", "b"], 1, 0);"

After run the script, the row can not be shown when "select * from sbtest", but the primary key is occupied.

It seems that when HandlerSocket call the "ha_myisam::write_row(buf)", the first byte of buff is not set correctly (set as 0).

If I change it to 0xff, the row can be insert into the table.

[Raghavendra D Prabhu (raghavendra-prabhu)]

Can you provide the script you used to test handlersocket?

Also, myisam table with fixed format seems to have issues, dynamic format seems to work well (http://www.pablowe.net/2011/03/handlersocket-edge-cases/). So, provide us your table structure as well.

[Launchpad Janitor (janitor)]

[Expired for Percona Server because there has been no activity for 60 days.]

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-491