Joins work fine from withing an actor, however, if you make a non syntactical error in your query the error is not very descriptive:
actordb> actor story(clientA); select e.id, e.title from entry e where e.id NOT IN(select THIS_ALIAS_DOES_NOT_EXISTS.entry_id from read THIS_IS_THE_REAL_ALIAS__OOPS);
actordb (1)> c
Error: {error,{sql_error,<<>>}}
actordb>
Error message should say that THIS_ALIAS_DOES_NOT_EXISTS is not a known alias inside the given scope.
Yeah for certain errors we make a poor job of returning the actual error string. I will look into it for next version. Something should be logged to error log however.
Joins work fine from withing an actor, however, if you make a non syntactical error in your query the error is not very descriptive:
Error message should say that
THIS_ALIAS_DOES_NOT_EXISTS
is not a known alias inside the given scope.