phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Heather <james.heat...@mendeley.com>
Subject Re: insert dynamic columns. Number of columns upserting must match number of values
Date Mon, 31 Aug 2015 05:37:46 GMT
You had an extra comma in your upsert statement. There are two commas
between id1 and id2, so you do in fact have four columns, even though one
of them is empty.

James
On 30 Aug 2015 21:38, "Serega Sheypak" <serega.sheypak@gmail.com> wrote:

> Hi, Getting error which confuses me.
> Here is DDL:
> CREATE TABLE IF NOT EXISTS cross_id_attributes
> (
>    crossId        VARCHAR   NOT NULL
>    CONSTRAINT cross_id_reference_pk  PRIMARY KEY (crossId)
> )
>
> Here is upsert query:
> upsert into cross_id_attributes(crossId VARCHAR, id1 VARCHAR, ,id2
> VARCHAR)values('crossIdvalue','id1Value','id2Value')
>
> And exception is:
> Number of columns upserting must match number of values. Numbers of
> columns: 4. Number of values: 3
>
> What does it mean? I have three cols and 3 values
>

Mime
View raw message