Swaroopa Kadam created PHOENIX-5322: ---------------------------------------
Summary: Upsert on a view with indexed table fails with ArrayIndexOutOfBound Exception Key: PHOENIX-5322 URL: https://issues.apache.org/jira/browse/PHOENIX-5322 Project: Phoenix Issue Type: Bug Affects Versions: 4.14.2 Reporter: Swaroopa Kadam {code:java} // code placeholder public void testUpstertOnViewWithIndexedTable() throws SQLException { Properties prop = new Properties(); Connection conn = DriverManager.getConnection(getUrl(), prop); conn.setAutoCommit(true); conn.createStatement().execute("CREATE TABLE IF NOT EXISTS us_population (\n" + " state CHAR(2) NOT NULL,\n" + " city VARCHAR NOT NULL,\n" + " population BIGINT,\n" + " CONSTRAINT my_pk PRIMARY KEY (state, city)) COLUMN_ENCODED_BYTES=0"); PreparedStatement ps = conn.prepareStatement("UPSERT INTO us_population VALUES('NY','New York',8143197)"); ps.executeUpdate(); ps = conn.prepareStatement("UPSERT INTO us_population VALUES('CA','Los Angeles',3844829)"); ps.executeUpdate(); ps = conn.prepareStatement("UPSERT INTO us_population VALUES('IL','Chicago',2842518)"); ps.executeUpdate(); ps = conn.prepareStatement("UPSERT INTO us_population VALUES('TX','Houston',2016582)"); ps.executeUpdate(); ps = conn.prepareStatement("UPSERT INTO us_population VALUES('PA','Philadelphia',1463281)"); ps.executeUpdate(); ps = conn.prepareStatement("UPSERT INTO us_population VALUES('AZ','Phoenix',1461575)"); ps.executeUpdate(); ps = conn.prepareStatement("UPSERT INTO us_population VALUES('TX','San Antonio',1256509)"); ps.executeUpdate(); ps = conn.prepareStatement("UPSERT INTO us_population VALUES('CA','San Diego',1255540)"); ps.executeUpdate(); ps = conn.prepareStatement("UPSERT INTO us_population VALUES('TX','Dallas',1213825)"); ps.executeUpdate(); ps = conn.prepareStatement("UPSERT INTO us_population VALUES('CA','San Jose',912332)"); ps.executeUpdate(); conn.createStatement().execute("CREATE VIEW IF NOT EXISTS us_population_gv" + "(city_area INTEGER, avg_fam_size INTEGER) AS " + "SELECT * FROM us_population WHERE state = 'CA'"); conn.createStatement().execute("CREATE INDEX IF NOT EXISTS us_population_gv_gi ON " + "us_population_gv (city_area) INCLUDE (population)"); conn.createStatement().execute("CREATE INDEX IF NOT EXISTS us_population_gi ON " + "us_population (population)"); ps = conn.prepareStatement("UPSERT INTO us_population_gv(state,city,population,city_area,avg_fam_size) " + "VALUES('CA','Santa Barbara',912332,1300,4)"); ps.executeUpdate(); } {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)