Skip to content

Parameter_collection_Concat_column_collection fails with latest SQLite #32561

Description

@ajcvickers

See #32369

Query is:

ss.Set<PrimitiveCollectionsEntity>().Where(c => ints.Concat(c.Ints).Count() == 2)

This is expected to return 1 result, but on SQLite it returns 0.

SQL:

.param set @__ints_0 '[11,111]'

SELECT "p"."Id", "p"."Bool", "p"."Bools", "p"."DateTime", "p"."DateTimes", "p"."Enum", "p"."Enums", "p"."Int", "p"."Ints", "p"."NullableInt", "p"."NullableInts", "p"."NullableString", "p"."NullableStrings", "p"."String", "p"."Strings"
FROM "PrimitiveCollectionsEntity" AS "p"
WHERE (
    SELECT COUNT(*)
    FROM (
        SELECT "i"."value"
        FROM json_each(@__ints_0) AS "i"
        UNION ALL
        SELECT "i0"."value"
        FROM json_each("p"."Ints") AS "i0"
    ) AS "t") = 2

Metadata

Metadata

Assignees

No one assigned

    Type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions