I would say a bug, because we allowed simple predicates, ie without subqueries. As for the next release, it's not certain yet. I would say at least in 1-2 months from now.

Best regards,

Pedro

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 <pedro.ferreira@monetdbsolutions.com> 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 list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list