reason of can not insert rows into myisam table using HandlerSocktet
Bug #810356 reported by
林晓斌
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Expired
|
High
|
Unassigned |
Bug Description
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_
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:
If I change it to 0xff, the row can be insert into the table.
Changed in percona-server: | |
importance: | Undecided → High |
Changed in percona-server: | |
assignee: | nobody → Patrick Crews (patrick-crews) |
tags: | added: handlersocket |
Changed in percona-server: | |
assignee: | Patrick Crews (patrick-crews) → nobody |
To post a comment you must log in.
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/handlersocke t-edge- cases/). So, provide us your table structure as well.