LP #810356: reason of can not insert rows into myisam table using HandlerSocktet

Description

**Reported in Launchpad by 林晓斌 last update 09-01-2013 04:17:52

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.

Environment

None

Smart Checklist

Activity

Show:

lpjirasync January 20, 2018 at 1:17 PM

**Comment from Launchpad by: Launchpad Janitor on: 09-01-2013 04:17:51

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

lpjirasync January 20, 2018 at 1:17 PM

**Comment from Launchpad by: Raghavendra D Prabhu on: 26-09-2012 11:52:29

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.

Done

Details

Assignee

Reporter

Priority

Smart Checklist

Created January 20, 2018 at 1:16 PM
Updated January 20, 2018 at 1:17 PM
Resolved January 20, 2018 at 1:17 PM