Hello, We recently updated from version 3.26.0 to version 3.28.0. Now we're seeing different (incorrect) results for the following query. Our database is available here: https://github.com/aspnet/EntityFrameworkCore/raw/f386095005e46ea3aa4d677e4439cdac113dbfb1/test/EFCore.Sqlite.FunctionalTests/northwind.db
SELECT ( SELECT "t"."CustomerID" FROM ( SELECT "o"."CustomerID", "o"."OrderDate" FROM "Orders" AS "o" WHERE ("c"."CustomerID" = "o"."CustomerID") AND "o"."CustomerID" IS NOT NULL ORDER BY "o"."CustomerID", "o"."OrderDate" DESC LIMIT 2 ) AS "t" ORDER BY "t"."CustomerID", "t"."OrderDate" DESC LIMIT 1) FROM "Customers" AS "c"; Results in 3.26.0: ALFKI ANATR ANTON AROUT ... Results in 3.28.0: ALFKI (NULL) (NULL) (NULL) ... Thanks! -- Brice Lambson Senior Software Engineer Microsoft _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users