[teiid-issues] [JBoss JIRA] (TEIID-5924) Salesforce: UPDATE doesn't work when setting null values

Salesforce: UPDATE doesn't work when setting null values -------------------------------------------------------- Key: TEIID-5924 URL: https://issues.redhat.com/browse/TEIID-5924 Project: Teiid Issue Type: Bug Components: Salesforce Connector Affects Versions: 13.1 Reporter: Dmitrii Pogorelov Assignee: Steven Hawkins Priority: Blocker Fix For: 14.0, 13.0.3, 13.1.1 Original Estimate: 4 hours Remaining Estimate: 4 hours UPDATE command doesn't work when setting null values: {code:sql} select w.* from (call sf34.native('update;type=Contact;attributes=id, OwnerId, LastName, Birthdate', '0031Y000062bY4aQAE', '005i0000002dtHTAAY', 'test_updates_null', null)) as w ;; update sf34.Contact set Birthdate = null where LastName = 'test_updates_null' ;; {code} queries do nothing. The query: {code:sql} select OwnerId, LastName, Birthdate from sf34.Contact where LastName = 'test_updates_null' ;; {code} will return the same result as before running these UPDATE commands.