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 <[email protected]> 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, 【小郭】 <[email protected]> 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 >> >> >> >> >> > >
