]
Steven Hawkins logged work on TEIID-5924:
-----------------------------------------
Author: Steven Hawkins
Created on: 31/Mar/20 3:29 PM
Start Date: 31/Mar/20 3:29 PM
Worklog Time Spent: 4 hours
Issue Time Tracking
-------------------
Remaining Estimate: 0 minutes (was: 4 hours)
Time Spent: 4 hours
Worklog Id: (was: 12450697)
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
Time Spent: 4 hours
Remaining Estimate: 0 minutes
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.