dotnet / dotnet/efcore

Parameter_collection_Concat_column_collection fails with latest SQLite

Open
#32,561 0 comments 0 reactions 0 assignees View on GitHub
area-external area-test blocked
Dominant language
C#
Stars
14.8k
Forks
3.4k
PR merge metrics
PR metrics pending

Description

See https://github.com/dotnet/efcore/pull/32369

Query is:

```C#
ss.Set().Where(c => ints.Concat(c.Ints).Count() == 2)
```

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

SQL:

```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
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.