dotnet / dotnet/efcore

SQLite: Querying on byte[] JSON property doesn't work

Open
#33,522 3 comments 0 reactions 0 assignees View on GitHub
area-json area-primitive-collections area-query area-sqlite customer-reported
Dominant language
C#
Stars
14.8k
Forks
3.4k
PR merge metrics
PR metrics pending

Description

See test JsonQuerySqliteTest.Json_predicate_on_byte_array.

Contributor guide

Open the contributing guide

Research direction

Start with the test named JsonQuerySqliteTest.Json_predicate_on_byte_array and run it to reproduce the SQLite JSON query failure. Read the surrounding test and its expected behavior, then trace the relevant EF Core query path. Done means the test passes for a JSON property backed by byte[].

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sqlite
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.