SwitchYard SQL binding does not work well with update queries run on MS-SQL database

Issue

• While using SQL Binding in reference of a SwitchYard application to UPDATE a record in MS-SQL database it seems that UPDATE does not reflect records in the database table. Also, there are no errors received in the log as well. The following is the parameterised query for quick reference.

update greetingbackup set receiver= #,sender= # where id= #;

• Interestingly, the same code is working fine (able to see the update record) in other databases like MySQL database without any change.
• Please note that if users use the hard-code SQL statement such as the one below then there is no issue as users could see the update in the record even in MS-SQL database.

update greetingbackup set receiver= 'Simple',sender= 'User' where id= 'I897Q';

• How to fix this issue?