Phoenix Subqueries with ‘IN’

[【小郭】]

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