agrosner / agrosner/DBFlow

SQL query is not created properly if foreignKey is reference to a table with multiple primaryKey

Aperta
#1,739 3 commenti 0 reazioni 0 assegnatari Vedi su GitHub
Lingua principale
Kotlin
Stelle
4.8k
Fork
593
Merge medio
1m
PR unite (30g)
1

Descrizione

Wrong SQL query is generated when parent table having more than one primary key is referenced through foreign key in the child table

DBFlow Version: 4.2.4

Bug or Feature Request:
Fix the logic for creating SQL query when Parent table with more than 1 primary key is referenced through foreignKey in the child table

Description:

When a child table reference a parent table (having more than one primaryKey) through Foreign Key, the SQL query generated for the child table is wrong

Here is the example of the query generated for UPDATE operation.

@Override
public final String getUpdateStatementQuery() {
 return "UPDATE `ContactPhoneMapping` SET `contact_primaryId`=?,`contact_secondaryId`=?,`phoneNo`=?,`type`=? WHERE `contact_primaryId`=?,`contact_secondaryId`=? AND `phoneNo`=?";
}


Notice that "AND" is missing in the where condition for "contact_primaryId" and "contact_secondaryId"

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.