GET_LOCK function does not work as expected in a stored program when character_set_database is set to ucs2.

--connection 1

delimiter |

CREATE PROCEDURE p1()

BEGIN

 SELECT GET_LOCK('m1', 10000);

 SELECT 'Query OK';

END;

|

delimiter ;

SET character_set_database=ucs2;

SET CHARACTER SET DEFAULT;

--connection 2

SET character_set_database=ucs2;

SET CHARACTER SET DEFAULT;

SELECT GET_LOCK('m1', 0);

--connection 1

CALL p1();