Roberto Cornacchia
Roberto Cornacchia
Oh! If I remove `inline` from the scalar MAL function, then the bulk version is chosen, as expected. Does this behaviour make sense? BTW, an `explain` did not show the...
@mlkersten that makes sense. However, the inline optimizer was the very first one also in 11.35, and this didn't happen. The big difference between 11.35 and the current releases is...
@njnes to be sure I understand well your answer: the ambiguity is resolved by knowing that the target list (thus the alias) is the last one being evaluated, so in...
I remember MonetDB used not to allow to use aliases in the `GROUP BY` clause, and I think it was more correct (as you say, aliases are not known yet...
@njnes you are right about that, I didn't even notice. I came to that function while debugging. But the same happens with a proper function. The simplest: ``` CREATE OR...
Hi @PedroTadim , do you have any update on this?
I didn't point that out before: does it make sense to you that this happens only if that expression is in a SQL function? If I skip the function and...
FYI, for now I solved my problem by implementing the function (which was similar to the one in the examples) as an `inline` MAL function for scalar values. Then all...
Thanks Jennie. Good to know you are aware of it. Just a thought, wouldn't it be useful to make the workaround automatic, and then inform the user that tables x,y,w...
Maybe it's not much, but something else I noticed: - the problem occurs quite frequently on Oct2020 - it seems to happen regularly after the database has filled up the...