[sqlite] Incorrect results after upgrading to 3.28.0

[Brice Lambson]

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