[PHOENIX-3991] ROW_TIMESTAMP on TIMESTAMP column type throws ArrayOutOfBound when upserting without providing a value.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 4.10.0
• Fix Version/s: 4.15.0, 5.1.0, 4.14.2
• Assignee: Sergey Soldatov
• Reporter: Eric Belanger
• Created: 04/Jul/17 14:48
• Updated: 30/May/19 18:40
• Resolved: 26/Jul/18 20:45

Description

CREATE TABLE TEST (
  CREATED TIMESTAMP NOT NULL,
  ID CHAR(36) NOT NULL,
  DEFINITION VARCHAR,
  CONSTRAINT TEST_PK PRIMARY KEY (CREATED ROW_TIMESTAMP, ID)
)

-- WORKS
UPSERT INTO TEST (CREATED, ID, DEFINITION) VALUES (NOW(), 'A', 'DEFINITION A');

-- ArrayOutOfBoundException
UPSERT INTO TEST (ID, DEFINITION) VALUES ('A', 'DEFINITION A');

Stack Trace:

java.lang.ArrayIndexOutOfBoundsException: 8

	at org.apache.phoenix.execute.MutationState.getNewRowKeyWithRowTimestamp(MutationState.java:554)
	at org.apache.phoenix.execute.MutationState.generateMutations(MutationState.java:640)
	at org.apache.phoenix.execute.MutationState.addRowMutations(MutationState.java:572)
	at org.apache.phoenix.execute.MutationState.send(MutationState.java:1003)
	at org.apache.phoenix.execute.MutationState.send(MutationState.java:1469)
	at org.apache.phoenix.execute.MutationState.commit(MutationState.java:1301)
	at org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:539)
	at org.apache.phoenix.jdbc.PhoenixConnection$3.call(PhoenixConnection.java:536)
	at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
	at org.apache.phoenix.jdbc.PhoenixConnection.commit(PhoenixConnection.java:536)

Issue Links

• is duplicated by: PHOENIX-4369 ArrayIndexOutOfBounds when upserting to table using ROW_TIMESTAMP