function won't work :-(

Hi,

why does this

CREATE FUNCTION normal_like (s1 varchar, s2 varchar) RETURNS BOOLEAN AS
SET s1 = LOWER(s1);
SET s2 = LOWER(s2);
IF LENGTH(s1) > LENGTH(REPLACE(s1, s2)) THEN RETURN TRUE
ELSE RETURN FALSE;
//
SELECT normal_like('abc', 'b') FROM sysdba.dual

fail with the error

General error;-2010 POS(8) Assignment impossible, char value too long
SELECT normal_like('abc', 'b') FROM sysdba.dual

Well, which assignment is impossible? which char value is too long? I 
can't imagine any reason :-(

In case s1 and s2 aren't writable: well, assigning LOWER(s1) and 
LOWER(s2) to other vars named s3 and s4 doesn't help either :-(


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx