hi, i continued narrowing down my example for this issue.  i attempted to reproduce it on an empty dataset and also on a different dataset, but neither triggered the error.

the query is just two left joins stacked 33 times with UNION ALLs.  if i remove even one of the 33 stacks (many are duplicated), the error disappears.

this error did not occur on Jun2016_SP2, it appears to have been introduced with Dec2016

here is the condensed (easier to read) code that displays the core commands:  https://drive.google.com/file/d/0B3LuuP081KDYMXU1SWtjbGp6Q1k/view

here's the PLAN:  https://drive.google.com/file/d/0B3LuuP081KDYMnJ5bFh2Zi1yTUk/view

here's the full query:  https://drive.google.com/file/d/0B3LuuP081KDYWV9kQkxzbllUTE0/view

i am confused how calc.isnil or calc.> could not be defined?  they are both defined for "any" type here:  https://github.com/MonetDB/MonetDB/blob/b40c1c1a33feece365fa6655802b6577df04af62/sql/common/sql_types.c#L1408-L1409

please help?  thanks all

On Mon, Jan 30, 2017 at 6:39 PM, Anthony Damico <ajdamico@gmail.com> wrote:

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