phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maryann Xue <maryann....@gmail.com>
Subject Re: Joining with a bigint
Date Wed, 09 Apr 2014 20:05:45 GMT
Hi Dan,

Which version did you check out? I could not reproduce this problem, either
with master branch or 4.0 branch. Could you please check it again?


Thanks,
Maryann


On Wed, Apr 9, 2014 at 10:58 AM, James Taylor <jamestaylor@apache.org>wrote:

> 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
>>
>
>


-- 
Thanks,
Maryann

Mime
View raw message