phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "N Campbell (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-3630) between predicate using BIGINT and FLOAT cause Type mismatch. FLOAT and BIGINT
Date Wed, 25 Jan 2017 03:58:26 GMT
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)

Mime
View raw message