Ambiguous columns use the last ambiguous column value as the value
- Lingua principale
- Kotlin
- Stelle
- 4.8k
- Fork
- 593
- Merge medio
- 1m
- PR unite (30g)
- 1
Descrizione
**DBFlow Version:** 4.2.4
**Bug or Feature Request:** Bug
**Description:**
When attempting to query a double inner join, the last column "id" is the value no matter which table you are selecting from.
For example:
Table 1 is a pivot table:
```
id, storeId, storeId2
```
and Table 2 has extra information:
```
id, store_name, store_coords
```
So if I want to do a join to combine these two records into one row into a list I would use `FlowCursorList`
```
FlowCursorList.Builder(SQLite.select()
.from(Table1::class.java)
.innerJoin(Table2::class.java).on(Table2_Table.id).eq(Table1_Table.storeId)
.innerJoin(Table2::class.java).on(Table2_Table.id).eq(Table1_Table.storeId2))
// ...where/orderBy cut for brevity
.build()
```
This always results in storeId2's Id being selected when using `Table1.id` in my adapter. I've tried using aliases, and selecting the columns manually, but nothing seems to fix it.
Guida per i contributori
Nessuna guida per i contributori indicizzata per questo repository
Valutazione
Questa issue non è ancora stata valutata.