1
drop function if exists bug17615|
2
create table t3 (a varchar(256) unicode)|
3
create function bug17615() returns varchar(256) unicode
5
declare tmp_res varchar(256) unicode;
6
set tmp_res= 'foo string';
9
insert into t3 values(bug17615())|
13
drop function bug17615|
16
DROP FUNCTION IF EXISTS bug48766;
17
CREATE FUNCTION bug48766 ()
18
RETURNS ENUM( 'w' ) CHARACTER SET ucs2
20
SHOW CREATE FUNCTION bug48766;
21
Function sql_mode Create Function character_set_client collation_connection Database Collation
22
bug48766 CREATE DEFINER=`root`@`localhost` FUNCTION `bug48766`() RETURNS enum('w') CHARSET ucs2
23
RETURN 0 utf8 utf8_general_ci latin1_swedish_ci
24
SELECT DTD_IDENTIFIER FROM INFORMATION_SCHEMA.ROUTINES
25
WHERE ROUTINE_NAME='bug48766';
27
enum('w') CHARSET ucs2
28
DROP FUNCTION bug48766;
29
CREATE FUNCTION bug48766 ()
30
RETURNS ENUM('а','б','в','г') CHARACTER SET ucs2
32
SHOW CREATE FUNCTION bug48766;
33
Function sql_mode Create Function character_set_client collation_connection Database Collation
34
bug48766 CREATE DEFINER=`root`@`localhost` FUNCTION `bug48766`() RETURNS enum('а','б','в','г') CHARSET ucs2
35
RETURN 0 utf8 utf8_general_ci latin1_swedish_ci
36
SELECT DTD_IDENTIFIER FROM INFORMATION_SCHEMA.ROUTINES
37
WHERE ROUTINE_NAME='bug48766';
39
enum('а','б','в','г') CHARSET ucs2
40
DROP FUNCTION bug48766;