[sqlite] COALESCE() ignores LIMIT 0 clause in subquery?

Is this the appropriate place to discuss this? The below examples are expected to return 3. The first example returns 4, the second returns 3. It seems like LIMIT 0 is ignored by COALESCE(). https://www.db-fiddle.com/f/7YWZ5naLUfAHgNmh93Yo44/0 CREATE TABLE "myTable" ( "myColumn" INT PRIMARY KEY

Re: [sqlite] COALESCE() ignores LIMIT 0 clause in subquery?

Fix checked in at https://sqlite.org/src/info/82e5dcf5c1d500ed On 9/22/19, Justin Ng wrote: > Is this the appropriate place to discuss this? > > The below examples are expected to return 3. > The first example returns 4, the second returns 3. > > It seems like LIMIT 0 is ignored by COALESCE(). >