It actually looks like the star operator in the select clause is causing the issue to happen, if I pick a specific attribute it works.  If I do foo.* then it fails, or if I do a global star it fails.

On Tue, Apr 8, 2014 at 11:05 PM, Dan Di Spaltro <dan.dispaltro@gmail.com> wrote:

I am using a pretty recent version of 4.0 and running into a weird problem that is probably a bug.  If I create a simple table

create foo (

 id bigint not null primary key,

 attr varchar)

create foo_bar (

 id bigint not null primary key,

 foo_id bigint,

 bar_id bigint

)

create bar (

 id bigint not null primary key,

 attr2 varchar

)

And try to run select * from foo inner join foo_bar on foo_bar.foo_id = foo.id

I get a type mismatch "type mismatch. expected: LONG but was: VARCHAR at column:" is this some compiler issue?  Have you successfully joined on a LONG?

Thanks,

-Dan

--
Dan Di Spaltro

--
Dan Di Spaltro