[
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)
