Re: Predicates in UDFs

25 Jun 2020

      Hello Pedro,

Thank you for the reply! Could you tell when this release will be available?
Do you know if this is just a bug or it was made like that intentionally?

Best regards,
Oksana

On Wed, 24 Jun 2020 at 19:21, ferreira 
wrote:
...
Hello Oxana,
I noticed the same issue with a fuzzer that I have been experimenting in
the last few weeks. I hope this will be fixed by Jun2020-SP1 release.
Best regards,
Pedro
On 6/24/20 12:09 PM, Oxana Dolmatova wrote:
Hello,
Could you please explain why predicates with subqueries in UDFs do not
work?
For example, I have the following statements:
create table itab (x int, y int);
insert into itab values (1, 0);
insert into itab values (2, 1);
create function test1(n int)
returns int
begin
while (n > 9) do
    set n = n -1;
end while;
return n;
end;
create function test2(n int)
returns int
begin
while (n > (select 9 from itab) ) do
    set n = n -1;
end while;
return n;
end;
create function test3(n int)
returns int
begin
while (exists (select x from itab where x < n)) do
    set n = n -1;
end while;
return n;
end;
The function test1 can be successfully created and executed, but functions
test2 and test3 cannot be created and executed.
Thank you and best regards,
Oksana
_______________________________________________
users-list mailing listusers-list@monetdb.orghttps://www.monetdb.org/mailman/listinfo/users-list