"Commands out of sync", "Malformed packet" or client hang up on unique key violation

revno: 3711

revision-id: psergey@askmonty.org-20131007132951-lhe4earylf5m2vmp

message:

  MDEV-3798: EXPLAIN UPDATE/DELETE

  - Add support for EXPLAIN INSERT.

bzr version-info

revision-id: psergey@askmonty.org-20131009090746-6zfqg47elbhnquac

revno: 3715

branch-nick: 10.0-base-explain-slowquerylog

BUILD/compile-pentium-debug-max-no-ndb

drop database if exists federated;

drop table if exists test.t1;

create database federated;

create table federated.t1 (a int primary key, b varchar(64))   DEFAULT CHARSET=utf8;

create table test.t1 (a int primary key, b varchar(64))  ENGINE=FEDERATED connection='mysql://root@127.0.0.1:3306/federated/t1' DEFAULT CHARSET=utf8;

insert into test.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe") on duplicate key update a=a+100;

select * from t1;

MariaDB [test]> insert into test.t1 values (1,"Larry"), (2,"Curly"), (1,"Moe") on duplicate key update a=a+100;

Query OK, 3 rows affected (0.02 sec)

Records: 3  Duplicates: 0  Warnings: 0

MariaDB [test]> select * from t1;

ERROR 2014 (HY000): Received error: 2014 : Commands out of sync; you can't run this command now

drop table if exists t1;

drop function if exists fn1;

create table t1 (a int, unique(a));

delimiter |;

create function fn1(x int)

  returns int

begin

  insert into t1 values(x),(x);

  return 10;

end|

delimiter ;|

do fn1(100);

MariaDB [test]> select fn1(100);

ERROR 2027 (HY000): Malformed packet