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)

Reply via email to