[IGNITE-12887] Node stops on type mismatch error between index type and type of value from searched row

• Type: Task
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 2.8
• Fix Version/s: 2.8.1
• Component/s: sql
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Taras Ledkov
• Reporter: Taras Ledkov
• Created: 10/Apr/20 11:13
• Updated: 20/Apr/20 07:30
• Resolved: 20/Apr/20 07:30

Description

Steps to reproduce:
1. Create table with value fields types: (INT, OTHER) and create indexes for the fields:

CREATE TABLE TEST (ID INT PRIMARY KEY, val_int INT, VAL_OBJ OTHER)
CREATE INDEX TEST_VAL_INT ON TEST(VAL_INT)
CREATE INDEX TEST_VAL_OBJ ON TEST(VAL_OBJ)

2. Add any data to the table:

INSERT INTO TEST VALUES (0, 0, ?)

3. Any of the query below crushes and node stops:
SELECT * FROM TEST WHERE VAL_OBJ < CURRENT_TIMESTAMP()
SELECT * FROM TEST WHERE VAL_INT < CURRENT_TIMESTAMP()

Root cause: all runtime exception inside Index.find is converted to CorruptedTreeException and stops the node,

Issue Links

• links to: GitHub Pull Request #7659
• links to: TCBot