[jira] [Resolved] (PHOENIX-664) UPSERT statement is not validating parameters count based on the table schema

["Gabriel Reid (JIRA)" <ji...@apache.org>]

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

Gabriel Reid resolved PHOENIX-664.
----------------------------------

    Resolution: Fixed

Bulk resolve of closed issues imported from GitHub. This status was reached by first re-opening all closed imported issues and then resolving them in bulk.

> UPSERT statement is not validating parameters count based on the table schema
> -----------------------------------------------------------------------------
>
>                 Key: PHOENIX-664
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-664
>             Project: Phoenix
>          Issue Type: Task
>    Affects Versions: 2.1.1
>            Reporter: Pankaj Kumar
>            Assignee: Samarth Jain
>
> SQL statements executed,
> 0: jdbc:phoenix:10.18.40.94> create table temp(id varchar not null primary key, name varchar,address varchar);
> 0: jdbc:phoenix:10.18.40.94> upsert into temp values('ID1','Pankaj','Bangalore');
> 0: jdbc:phoenix:10.18.40.94> upsert into temp values('ID2','Rajesh','Bangalore','Hyderabad','Domlur');
> 0: jdbc:phoenix:10.18.40.94> select * from temp;
> +------------+------------+------------+
> |     ID     |    NAME    |  ADDRESS   |
> +------------+------------+------------+
> | Domlur     | Rajesh     | Bangalore  |
> | ID1        | Pankaj     | Bangalore  |
> +------------+------------+------------+
> 0: jdbc:phoenix:10.18.40.94>
> In the above case, "TEMP" table has three columns only. But while inserting the records five parameters are allowed. Error message should be thrown.



--
This message was sent by Atlassian JIRA
(v6.2#6252)