agrosner / agrosner/DBFlow

Ambiguous columns use the last ambiguous column value as the value

Aperta
#1,592 2 commenti 0 reazioni 0 assegnatari Vedi su GitHub
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.

Ricevi le nuove issue nella tua casella

Un breve riepilogo di issue GitHub adatte ai principianti.