Zoltan Haindrich created HIVE-17726:
---------------------------------------
Summary: Using exists may lead to incorrect results
Key: HIVE-17726
URL: https://issues.apache.org/jira/browse/HIVE-17726
Project: Hive
Issue Type: Bug
Affects Versions: 3.0.0
Reporter: Zoltan Haindrich
{code}
drop table if exists tx1;
create table tx1 (a integer,b integer);
insert into tx1 values (1, 1),
(1, 2),
(1, 3);
select count(*) as result,3 as expected from tx1 u
where exists (select * from tx1 v where u.a=v.a and u.b <> v.b);
select count(*) as result,3 as expected from tx1 u
where exists (select * from tx1 v where u.a=v.a and u.b <> v.b limit 1);
{code}
current results are 6 and 2.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
