Uploaded image for project: 'Ignite'
  1. Ignite
  2. IGNITE-12887

Node stops on type mismatch error between index type and type of value from searched row

    XMLWordPrintableJSON

    Details

    • Type: Task
    • Status: Resolved
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 2.8
    • Fix Version/s: 2.8.1
    • Component/s: sql
    • Labels:
      None
    • Ignite Flags:
      Docs Required, Release Notes Required

      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,

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                tledkov-gridgain Taras Ledkov
                Reporter:
                tledkov-gridgain Taras Ledkov
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 10m
                  10m