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
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.