[teiid-issues] [JBoss JIRA] (TEIID-5924) Salesforce: UPDATE doesn't work when setting null values
Dmitrii Pogorelov (Jira)
issues at jboss.org
Tue Mar 31 09:58:10 EDT 2020
Dmitrii Pogorelov created TEIID-5924:
----------------------------------------
Summary: 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
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