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

["Taras Ledkov (Jira)" <ji...@apache.org>]

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)