empty resultset if UDF in select throws exception $rc=100

[Alexey Gaidukov]

create table gis.test2 (
   resid varchar(10) UNICODE
)
//
create function GIS.ret_test
   returns varchar AS
VAR
   f varchar(10);
begin
   try
       select resid into :f from gis.test2;
       return f;
   CATCH
   STOP($rc, $errmsg);
end;
//
create table temp.test (
   resid varchar(10) UNICODE
)
//
insert into temp.test values (null)
//
insert into temp.test values ('1000')
//
select resid,GIS.ret_test() from temp.test


returns empty resultset. Is it by design?



--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]