[PHOENIX-3727] Upserts into salted table are failing in Phoenix-Calcite

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.10.0
• Labels: calcite
• Assignee: Rajeshbabu Chintaguntla
• Reporter: Rajeshbabu Chintaguntla
• Created: 09/Mar/17 13:49
• Updated: 05/Jul/17 15:51
• Resolved: 05/Jul/17 15:51

Description

testMutableTableIndexMaintanenceSaltedSalted(org.apache.phoenix.end2end.index.SaltedIndexIT)  Time elapsed: 4.607 sec  <<< ERROR!
java.sql.SQLException: 2
	at org.apache.phoenix.end2end.index.SaltedIndexIT.testMutableTableIndexMaintanence(SaltedIndexIT.java:123)
	at org.apache.phoenix.end2end.index.SaltedIndexIT.testMutableTableIndexMaintanenceSaltedSalted(SaltedIndexIT.java:74)
Caused by: java.lang.ArrayIndexOutOfBoundsException: 2
	at org.apache.phoenix.end2end.index.SaltedIndexIT.testMutableTableIndexMaintanence(SaltedIndexIT.java:123)
	at org.apache.phoenix.end2end.index.SaltedIndexIT.testMutableTableIndexMaintanenceSaltedSalted(SaltedIndexIT.java:74)

This is because for salted tables we are changing column indexes within UpsertCompiler#upsertSelect so with preparedStatements we increment columnindexes by 1 so at some point of time we get ArrayIndexOutOfBoundsException.