[jira] [Created] (PHOENIX-3630) between predicate using BIGINT and FLOAT cause Type mismatch. FLOAT and BIGINT

[N Campbell (JIRA)]

N Campbell created PHOENIX-3630:
-----------------------------------

             Summary: between predicate using BIGINT and FLOAT cause Type 
mismatch. FLOAT and BIGINT 
                 Key: PHOENIX-3630
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3630
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.7.0
         Environment: Hortonworks 2.5.3
            Reporter: N Campbell


phoenix-4.7.0.2.5.3.0-37-thin-client

This parses
select 
        TBINT.RNUM, TFLT.RNUM from 
        TBINT , TFLT 
where TBINT.CBINT >= TFLT.CFLT and  TBINT.CBINT <= TFLT.CFLT 

This does not
select 
        TBINT.RNUM, TFLT.RNUM from 
        TBINT , TFLT 
where TBINT.CBINT BETWEEN TFLT.CFLT and   TFLT.CFLT

Type mismatch. FLOAT and BIGINT for TFLT.CFLT <= TBINT.CBINT -> 
TypeMismatchException: ERROR 203 (22005): Type mismatch. FLOAT and BIGINT for 
TFLT.CFLT <= TBINT.CBINT
SQLState:  00000
ErrorCode: -1


create table  if not exists TBINT ( RNUM integer  not null primary key , CBINT 
bigint   );

create table  if not exists TFLT ( RNUM integer  not null primary key, CFLT 
float   );



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)