Not sure how to report this, but I've discovered the following bug using SQL Developer 4.2 when connected to Hive. It is also present on other versions.
The same query works correctly in other tools.
When using an OR condition as listed below, data is not returned correctly.
Specifically, when the line "AND fname = 'Fred'" is commented out, the query works correctly. When the line is uncommented, the query returns too many rows.
Is this a known issue?
Steps to replicate the issue....
CREATE TABLE dev.rt_verify (
INSERT INTO dev.rt_verify VALUES (2015, 3, 'Fred', 'Flintstone', 'Quarry');
INSERT INTO dev.rt_verify VALUES (2016, 1, 'George', 'Jetson', 'Engineering');
INSERT INTO dev.rt_verify VALUES (2016, 5, 'Barney', 'Rubble', 'Quarry');
INSERT INTO dev.rt_verify VALUES (2016, 1, 'Betty', 'Rubble', 'Engineering');
WHERE dept = 'Quarry'
-- AND fname = 'Fred'
(hire_yr = 2016 AND hire_mnth <= 1)
OR (hire_yr = 2015 AND hire_mnth >= 1)
Results when commented
Results when un commented
we're just sending the query over the driver...the bug could be with the driver or with the source system itself
if you want to report a bug, you would need to open an SR with My Oracle Support