| If we create an Entity Account with primary key as Id. In @SqlDelete, if someone writes a query like "@SQLDelete(sql="Update account set \"Type\" = null where amount=? and version= ? ")" where amount is not a primary key column, it should throw an error whereas it substitutes amount value with id column value and executes the query. In my db, I have a row with id as 1 and amount as 3743. Though the query is written to check for amount as 3743, it executes it as amount = 1, which is not valid. Either, there should be no where clause allowed in @SqlDelete statement and it should automatically set primary key value and versioned column else if someone is writing some other column name in where condition, it should throw an error for it does what user does not expect or intend. |