I am experiencing incorrect query result with SQLite 3.25.2 and 3.28.
The database and the queries have been reduced to the minimum, so they
are not really relevant, but demonstrates better where is the problem.
Also note that the result is correct using SQLite 3.15.2.
Using the following table:
CREATE TABLE generated_ITI (
id INTEGER PRIMARY KEY,