[ 
https://issues.apache.org/jira/browse/PHOENIX-1776?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Dave Hacker updated PHOENIX-1776:
---------------------------------
    Description: 
CREATE TABLE test (
    id VARCHAR not null primary key,
    name VARCHAR,
    lat FLOAT
);

UPSERT INTO test(id,name,lat) VALUES ('testid', 'testname', -1.00);

Error: ERROR 203 (22005): Type mismatch. FLOAT and BIGINT for -1

> The literal -1.0 (floating point) should not be converted to -1 (Integer)
> -------------------------------------------------------------------------
>
>                 Key: PHOENIX-1776
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-1776
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Dave Hacker
>            Assignee: Dave Hacker
>         Attachments: Phoenix-1776.patch
>
>
> CREATE TABLE test (
>     id VARCHAR not null primary key,
>     name VARCHAR,
>     lat FLOAT
> );
> UPSERT INTO test(id,name,lat) VALUES ('testid', 'testname', -1.00);
> Error: ERROR 203 (22005): Type mismatch. FLOAT and BIGINT for -1



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

Reply via email to