hi, i tried narrowing down the query causing MALException:opt.remap:Function 'calc.isnil' not defined.

i hit a (probably related) separate error that breaks on the greater than operator rather than isnil() ----  MALException:opt.remap:Function 'calc.>' not defined

here's the PLAN for the calc.> not defined error:  https://drive.google.com/file/d/0B3LuuP081KDYOVZaX1dzcnIyUkk/view?usp=sharing

here's a slightly parsed down PLAN for the calc.isnil error: https://drive.google.com/file/d/0B3LuuP081KDYdkExYk1xazlCVjg/view?usp=sharing

do either of these PLAN statements help identify what's going on?  otherwise i'll try to continue reducing this.. thanks



On Mon, Jan 30, 2017 at 6:48 AM, Anthony Damico <ajdamico@gmail.com> wrote:
after rebuilding the database from scratch and using Dec2016, i'm still hitting this calc.isnul error that did not happen in the previous version:  MALException:opt.remap:Function 'calc.isnil' not defined

does anyone have advice about what might be triggering the error?  i've pasted the PLAN here..  https://drive.google.com/file/d/0B3LuuP081KDYdC1QRzRWbHRPUkE/view?usp=drive_web

it does work if i run some subset of the queries being combined with the UNION ALL, just not with the entire UNION ALL, so pretty tough to narrow down (though i will try more if there's no obvious culprit here).

thanks!


On Sat, Jan 28, 2017 at 11:14 AM, Anthony Damico <ajdamico@gmail.com> wrote:
hi, thanks, i am using monetdblite on windows so i think everything would be pre-packaged?  i'm also confused that it looks like there haven't been any changes to isnil recently[1].  i looked at the sql PLAN and it's old enough that there are still VARCHARs in the dataset, so before i kill any more time narrowing down the bug, maybe i should rebuild from scratch on the latest software version..

https://github.com/hannesmuehleisen/MonetDBLite/search?o=desc&q=isnil&s=committer-date&type=Commits&utf8=%E2%9C%93

On Sat, Jan 28, 2017 at 10:31 AM, Brian Hood <brianh6854@googlemail.com> wrote:
When i have seen a message like this in the past it means that calc.isnull requires an external library.

However unsure in this case.

So maybe check your the monetdb binaries with ldd to find any dependencies that are not found.

Regards,

Brian Hood

On Sat, Jan 28, 2017 at 3:13 PM, Anthony Damico <ajdamico@gmail.com> wrote:
hi, i upgraded monetdb and am hitting this error with code that previously worked.  my (giant) query has lots of CAST and IS NULL commands in it..  trying to narrow it down now, but does anyone have ideas about what might've introduced this?  it looks like something is calling IS NULL where it shouldn't be allowed to?  thanks

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list



_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list