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)