phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Joining with a bigint
Date Wed, 09 Apr 2014 14:58:11 GMT
Definitely a bug - please file a JIRA and we'll get this fixed up in our
next point release.

Thanks,
James


On Wed, Apr 9, 2014 at 12:24 AM, Dan Di Spaltro <dan.dispaltro@gmail.com>wrote:

> 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