Soumyakanti Das created HIVE-25028:
--------------------------------------
Summary: Hive: Select query with IS operator producing unexpected
result
Key: HIVE-25028
URL: https://issues.apache.org/jira/browse/HIVE-25028
Project: Hive
Issue Type: Bug
Components: Parser
Reporter: Soumyakanti Das
Assignee: Soumyakanti Das
Hive: Select query with IS operator is producing unexpected result.
The following was executed on postgres:
{code:java}
sqlancer=# create table if not exists emp(name text, age int);
CREATE TABLE
sqlancer=# insert into emp values ('a', 5), ('b', 15), ('c', 12);
INSERT 0 3
sqlancer=# select emp.age from emp where emp.age > 10;
age
-----
15
12
(2 rows)sqlancer=# select emp.age > 10 is true from emp;
?column?
----------
f
t
t
(3 rows){code}
This is happening because IS operator has higher precedence than comparison
operators in Hive. In most other databases, comparison operator has higher
precedence. The grammar needs to be changed to fix the precedence.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
