[teiid-issues] [JBoss JIRA] (TEIID-4853) Google translator does not allow update of empty String type cell

[Lucie Fabrikova (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-4853?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lucie Fabrikova updated TEIID-4853:
-----------------------------------
    Comment: was deleted

(was: I found another usecase which leads to this issue:
- if there is a view (CRUD.SmallA_Direct) which defines only a subset of columns defined in foreign table (Source.SmallA), update of such view throws the exception 'String values cannot be set to null'
if any of the other cells of type String (not defined in the view) is empty.

Workaround: if a trigger for update of SmallA_Direct is defined, translator behaves as expected.
See attached vdb.)


> Google translator does not allow update of empty String type cell 
> ------------------------------------------------------------------
>
>                 Key: TEIID-4853
>                 URL: https://issues.jboss.org/browse/TEIID-4853
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 9.3, 8.12.10.6_3
>            Reporter: Lucie Fabrikova
>            Assignee: Steven Hawkins
>         Attachments: gs-update-empty-cell.log
>
>
> Google translator allows to be inserted null value into column of type String, but subsequent update of any cell in such row throws exception "Spreadsheet translator error: String values cannot be set to null".



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)