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 03:43:12 GMT
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