[jira] [Created] (HIVE-21066) unexpected schematic exception

[Ravi Shetye (JIRA)]

Ravi Shetye created HIVE-21066:
----------------------------------

             Summary: unexpected schematic exception
                 Key: HIVE-21066
                 URL: https://issues.apache.org/jira/browse/HIVE-21066
             Project: Hive
          Issue Type: Bug
    Affects Versions: 3.0.0
         Environment: 
{noformat}
*no* further _formatting_ is done here
{noformat}

            Reporter: Ravi Shetye


*WORKS*

{noformat}
0: jdbc:hive2://localhost:10000> select c1=c1  from (select "a" as c1) t1;
+-------+
|  _c0  |
+-------+
| true  |
+-------+
{noformat}


{noformat}
0: jdbc:hive2://localhost:10000> select c1 in ("a","b") a from (select "a" c1 
)t1 ;
+-------+
|   a   |
+-------+
| true  |
+-------+
{noformat}


{noformat}
0: jdbc:hive2://localhost:10000> select true in (true) a from (select "a" c1 
)t1;
+-------+
|   a   |
+-------+
| true  |
+-------+
{noformat}

*DOES NOT WORK*

{noformat}
0: jdbc:hive2://localhost:10000> select c1=c1 in (true) a from (select "a" c1 
)t1 ;
Error: Error while compiling statement: FAILED: SemanticException Line 0:-1 
Wrong arguments 'true': The arguments for IN should be the same type! Types 
are: {string IN (boolean)} (state=42000,code=40000)
{noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)