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";<[email protected]>;
发送时间: 2015年1月16日(星期五) 中午12:09
收件人: "[email protected]"<[email protected]>;
主题: 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 <[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
