phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dan Di Spaltro <dan.dispal...@gmail.com>
Subject Re: Joining with a bigint
Date Wed, 09 Apr 2014 07:24:41 GMT
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

Mime
View raw message