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, 23 Jan 2015 02:50:09 GMT
Thank you,Maryann.
And I hit another bug.
for example:‍
	Query1:
	‍select count(1) from (
		SELECT * FROM SYS_USER WHERE ID IN (800000502,800000604)
			) as tmp_count;
	return1:+------------------------------------------+
		      |                 COUNT(1)                    |
		     +------------------------------------------+
		      | 2                                                |
		     +------------------------------------------+




	Query2:
	‍select count(1) from (
		SELECT * FROM SYS_USER WHERE ID IN (
			SELECT ID FROM SYS_USER WHERE ID IN (800000502,800000604))
			) as tmp_count;
	return2:+------------------------------------------+
		      |                 COUNT(1)                    |
		     +------------------------------------------+
		      | 0                                                |
		      | 0                                                |
		     +------------------------------------------+


The "Query2" return not right,it should return as same as the "Query1"‍





------------------ 原始邮件 ------------------
发件人: "Maryann Xue";<maryann.xue@gmail.com>;
发送时间: 2015年1月16日(星期五) 中午12:09
收件人: "user@phoenix.apache.org"<user@phoenix.apache.org>; 

主题: Re: Phoenix Subqueries with ‘IN’



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 <maryann.xue@gmail.com> 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, 【小郭】 <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