phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maryann Xue <maryann....@gmail.com>
Subject Re: Phoenix Subqueries with ‘IN’
Date Fri, 16 Jan 2015 04:09:12 GMT
This has been verified as a bug. Just filed
https://issues.apache.org/jira/browse/PHOENIX-1591 for it.
Thank you very much for reporting this, Xiaoguo! You can expect it to be
fixed in Phoenix 4.3.

On Thu, Jan 15, 2015 at 10:43 PM, Maryann Xue <maryann.xue@gmail.com> wrote:

> Hi Xiaoguo,
>
> Do you mean you have hit a bug in Phoenix? The query is expected to return
> nothing but returns all rows?
>
>
> Thanks,
> Maryann
>
> On Thu, Jan 15, 2015 at 9:02 PM, 【小郭】 <guoqidong@qq.com> wrote:
>
>> Hi guys:
>>      When using the subquery with 'IN',if the subquery return no
>> rows,the query whill find all rows.
>>  for example:‍
>>     Query:‍
>>         SELECT * FROM SYS_USER WHERE ID IN (SELECT USER_ID FROM SYS_ORG
>> WHERE ID = 0);
>>     If the subquery 'SELECT USER_ID FROM SYS_ORG WHERE ID = 0‍'  have no result,the
>> Query will return all rows of table 'SYS_USER'.
>>
>> How could i get the result like oracle if the ‍subquery ‍have no result?‍
>> ‍
>>
>> Hbase 0.98
>> Phoenix 4.2‍
>>
>> Thank you for your help,‍
>> xiaoguo
>>
>>
>>
>>
>>
>
>

Mime
View raw message