[teiid-issues] [JBoss JIRA] (TEIID-5924) Salesforce: UPDATE doesn't work when setting null values
Steven Hawkins (Jira)
issues at jboss.org
Tue Mar 31 12:17:40 EDT 2020
[ https://issues.redhat.com/browse/TEIID-5924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins updated TEIID-5924:
----------------------------------
Fix Version/s: 14.0
13.0.3
13.1.1
Original Estimate: 4 hours
Remaining Estimate: 4 hours
Story Points: 0.5
Sprint: DV Sprint 59
Priority: Blocker (was: Critical)
There is nuance to the salesforce api that requires null values to be handled via a special fieldsToNull that was unaccounted for.
> 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.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
More information about the teiid-issues
mailing list