phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "【小郭】" <guoqid...@qq.com>
Subject Phoenix Subqueries with ‘IN’
Date Fri, 16 Jan 2015 02:02:47 GMT
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