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;