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

[Dmitrii Pogorelov (Jira)]

    [ https://issues.redhat.com/browse/TEIID-5924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14015611#comment-14015611 ] 

Dmitrii Pogorelov commented on TEIID-5924:
------------------------------------------

[~shawkins] a follow-up ticket for TEIID-5923 issue.

> 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: Critical
>
> 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.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)