ClickHouse / ClickHouse/ClickHouse.EntityFrameworkCore
Code 47 UNKNOWN_IDENTIFIER: Identifier 's.id' cannot be resolved from subquery with name s ... Maybe you meant: ['s.id1']
- Dominant language
- C#
- Stars
- 23
- Forks
- 7
- Avg merge
- 14d 3h
- Merged PRs (30d)
- 1
Description
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))
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.