Re: Two questions about R integration

Hi Roberto,

On 21 Sep 2015, at 19:25, Roberto Cornacchia wrote: I have 2 questions about R integration.

1) I see that missing packages are automatically installed when invoked by library() calls. That is really cool. The question: if I need a library in a function, will this actually be loaded at every function call? It should not. library() checks the search() output and will only load packages not present there.

2) How is a SQL type date translated to R? Apparently not "Date", because I tried to use it as such in the declared procedure and I got a complaint. So far, they are not treated correctly. I hope to fix this before the next release. So cast them to strings or so before passing to R.

I tried to figure the type myself with this:

sql> create function dt(d date) returns string language R { class(d) }; sql> select dt( cast('2015-09-21' as date) );

but unfortunately this triggered a server assertion :/

mserver5: .../src/monetdb5/mal/mal_interpreter.c:648: runMALsequence: Assertion `t == stk->stk[a].vtype' failed.

Will make a test case out of this. Thanks! Hannes