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