SQL query is not created properly if foreignKey is reference to a table with multiple primaryKey
punnyaannjoy opened this issue · 3 comments
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"
@agrosner any suggestion on the above issue?