1 -- source include/have_ucs2.inc
6 # BUG#17615: problem with character set
9 drop function if exists bug17615|
12 create table t3 (a varchar(256) unicode)|
14 create function bug17615() returns varchar(256) unicode
16 declare tmp_res varchar(256) unicode;
17 set tmp_res= 'foo string';
21 insert into t3 values(bug17615())|
24 drop function bug17615|
31 # Bug#48766 SHOW CREATE FUNCTION returns extra data in return clause
35 DROP FUNCTION IF EXISTS bug48766;
38 # Test that Latin letters are not prepended with extra '\0'.
40 CREATE FUNCTION bug48766 ()
41 RETURNS ENUM( 'w' ) CHARACTER SET ucs2
43 SHOW CREATE FUNCTION bug48766;
44 SELECT DTD_IDENTIFIER FROM INFORMATION_SCHEMA.ROUTINES
45 WHERE ROUTINE_NAME='bug48766';
46 DROP FUNCTION bug48766;
48 # Test non-Latin characters
50 CREATE FUNCTION bug48766 ()
51 RETURNS ENUM('а','б','в','г') CHARACTER SET ucs2
53 SHOW CREATE FUNCTION bug48766;
54 SELECT DTD_IDENTIFIER FROM INFORMATION_SCHEMA.ROUTINES
55 WHERE ROUTINE_NAME='bug48766';
57 DROP FUNCTION bug48766;