From my point of view this behavior is incorrect because $rc=100 is
correct only in UDF context. In context of select statement this $rc=100
is wrong.
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]
