[IGNITE-12567] H2Tree goes into illegal state when non-indexed columns are dropped

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.9, 2.8.1
• Component/s: sql
• Release Note: Fixed an issue where lookup over index is crashed with "General error: java.lang.ArrayIndexOutOfBoundsException" when some column prior to the indexed ones were dropped.
• Ignite Flags: Release Notes Required
• Assignee: Konstantin Orlov
• Reporter: Konstantin Orlov
• Reviewer: Ivan Pavlukhin
• Created: 22/Jan/20 13:40
• Updated: 17/Apr/20 07:47
• Resolved: 23/Jan/20 11:46

Description

How to reproduce:

• CREATE TABLE tbl (f0 INT, f1 INT, f2 INT, f3 INT, f4 INT, PRIMARY KEY (f3, f4))
• populate table with some data
• ALTER TABLE tbl DROP COLUMN f1, f2
• try to execute query which will use pk index: SELECT * FROM tbl WHERE f3 = 1 AND f4 = 1

Expected:

• Query returns result set

Actual:

• Query fails with General error: "java.lang.ArrayIndexOutOfBoundsException: 5";

Issue Links

• links to: GitHub Pull Request #7290