ClickHouse / ClickHouse/ClickHouse.EntityFrameworkCore
Code 47 UNKNOWN_IDENTIFIER: Identifier 's.id' cannot be resolved from subquery with name s ... Maybe you meant: ['s.id1']
- Lingua principale
- C#
- Stelle
- 23
- Fork
- 7
- Merge medio
- 14g 3h
- PR unite (30g)
- 1
Descrizione
When querying with LINQ and adding nested navigation props with Include or ThenInclude e.g.:
```
var parent = await ctx.Parents
.Where(p => p.Id == 1L)
.Include(p => p.Children)
.ThenInclude(c => c.GrandChildren)
.SingleOrDefaultAsync();
```
an error occurs:
ClickHouse.Driver.ClickHouseServerException (0x0000002F): Code: 47. DB::Exception: Identifier 's.id' cannot be resolved from subquery with name s. In scope SELECT c0.id, ..., s.id AS id0, .... Maybe you meant: ['s.id1']. (UNKNOWN_IDENTIFIER) (version 25.8.29.51 (official build))
Guida per i contributori
Nessuna guida per i contributori indicizzata per questo repository
Direzione di ricerca
Start by reproducing the reported LINQ query with Include and ThenInclude against ClickHouse, then inspect the generated query around the unresolved s.id and s.id1 identifiers. Done means the nested navigation query executes successfully without the Code 47 UNKNOWN_IDENTIFIER error.
Scritto dal modello di indicizzazione a partire dal testo della issue.
Valutazione
- Stack tecnologico
- clickhouse, csharp
- Ambito
- database
- Tipo di issue
- Bug
- Difficoltà
- 3/5
- Tempo stimato
- 1-2 giorni
- Stato di attività
- Attiva
- Chiarezza
- Abbastanza chiara
- Idoneità per principianti
- 50/100