Joining with a bigint

[Dan Di Spaltro]

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