Taras Ledkov created IGNITE-12887: ------------------------------------- Summary: Node stops on type mismatch error between index type and type of value from searched row Key: IGNITE-12887 URL: https://issues.apache.org/jira/browse/IGNITE-12887 Project: Ignite Issue Type: Task Components: sql Affects Versions: 2.8 Reporter: Taras Ledkov Assignee: Taras Ledkov Fix For: 2.8.1
Steps to reproduce: 1. Create table with value fields types: (INT, OTHER) and create indexes for the fields: {code} 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) {code} 2. Add any data to the table: {code} INSERT INTO TEST VALUES (0, 0, ?) {code} 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, -- This message was sent by Atlassian Jira (v8.3.4#803005)