Search code examples
ignite

Simple select query missing rows in Ignite


Selecting by ID over a table with 2 entries results in a single output result.

Here's the example table:

    CREATE TABLE IF NOT EXISTS Person(
      id int,
      city_id int,
      name varchar,
      age int,
      company varchar,
      PRIMARY KEY (id, city_id)
    );
    INSERT INTO Person (id, name, city_id) VALUES (1, 'John Doe', 3);
    INSERT INTO Person (id, name, city_id) VALUES (1, 'John Dean', 4);

The following queries were executed in the same order:

"SELECT * FROM Person" returns both rows - expected
"SELECT * FROM Person WHERE age is null" returns both rows - expected
"SELECT * FROM Person WHERE id = 1" returns only the first row, when it was expected to return both rows.

Would you be able to help me understand what is going on here? Thanks!


Edit

This is an active critical issue being tracked here: https://issues.apache.org/jira/browse/IGNITE-12068


Solution

  • The issue has been fixed by the community and will be available in the upcoming release shortly: https://issues.apache.org/jira/browse/IGNITE-12068

    Thanks for reporting.