[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:comment-tabpanel&focusedCommentId=13395980#comment-13395980 ] 

Lucie Fabrikova commented on TEIID-4853:
----------------------------------------

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 behaves unexpectedly if any of the other cells of type String (not defined in the view) is empty: 
* sometimes (not deterministically) it throws instead of update the exception 'String values cannot be set to null' 

> 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)