You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Ankit Singhal (JIRA)" <ji...@apache.org> on 2016/12/08 12:12:59 UTC

[jira] [Created] (PHOENIX-3528) Rowtimestamp column value is added twice when the upsert statement is compiled twice.

Ankit Singhal created PHOENIX-3528:
--------------------------------------

             Summary: Rowtimestamp column value is added twice when the upsert statement is compiled twice.
                 Key: PHOENIX-3528
                 URL: https://issues.apache.org/jira/browse/PHOENIX-3528
             Project: Phoenix
          Issue Type: Bug
            Reporter: Ankit Singhal
            Assignee: Ankit Singhal



{code}
java.sql.SQLException: ERROR 1020 (42Y60): Number of columns upserting must match number of values. Numbers of columns: 4. Number of values: 5
	at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:464)
	at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150)
	at org.apache.phoenix.compile.UpsertCompiler.compile(UpsertCompiler.java:559)
	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:608)
	at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableUpsertStatement.compilePlan(PhoenixStatement.java:1)
	at org.apache.phoenix.jdbc.PhoenixStatement$3.call(PhoenixStatement.java:348)
	at org.apache.phoenix.jdbc.PhoenixStatement$3.call(PhoenixStatement.java:1)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:337)
	at org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeUpdate(PhoenixPreparedStatement.java:199)
	at org.apache.phoenix.end2end.UpsertValuesIT.testAutomaticallySettingRowtimestamp(UpsertValuesIT.java:789)
	at org.apache.phoenix.end2end.UpsertValuesIT.testAutomaticallySettingRowtimestamp_asc(UpsertValuesIT.java:766)
	
{code}





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