Matteo Gattoni wrote: > > Hello, > I'm using MaxDb version 7.5.01.00. > I have a function TO_CHAR2 owned by user PPORTAL that receives a float and > give me back a char value. > > The function is created like this in Oracle mode (the grant in Internal > mode because they don't work in oracle mode) > > DROP FUNCTION TO_CHAR2 > // > CREATE FUNCTION TO_CHAR2(VAL FLOAT) RETURNS VARCHAR AS > BEGIN > RETURN TO_CHAR(FLOOR(VAL)); > END; > // > > GRANT EXECUTE ON PPORTAL.TO_CHAR2 TO PSF > // > GRANT EXECUTE ON PPORTAL.TO_CHAR2 TO PPORTAL_PERMISSION > // > > > Calling it in this way > SELECT PPORTAL.TO_CHAR2(Max(TO_NUMBER(K_KEY) +1)) pluto FROM REGISTRY_TREE > > the database crashes everytime.
SELECT TO_CHAR2(Max(TO_NUMBER(K_KEY) +1)) pluto FROM REGISTRY_TREE Would do, too. It is the problem of a select-column-check not having taken the owner in front of the functionname into account. As a workaround you may create a public function TO_CHAR2 not needing the ownername in front CREATE PUBLIC FUNCTION <functionname without owner> ... ... (as usual) We will describe this feature in the next version of the docs, too where it is missing so far. And we will fix the bug, of course. Elke SAP Labs Berlin > > Note that writing this (swapping the call of the TO_CHAR2 function with > max), > > SELECT Max(PPORTAL.TO_CHAR2(TO_NUMBER(K_KEY) +1)) pluto FROM REGISTRY_TREE > > it doesn't happened (but the result isn't what I need). > > In the database error log I've found only rows like this > 2004-06-16 15:08:16 32057 ERR 54111 MOVE VAK05.4: 32768[32552]->1[8192000] > len:0 > > What's wrong with it? -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
