[teiid-issues] [JBoss JIRA] (TEIID-4460) A view field defined as clob, on a google spreadsheeet model, returns data truncated to string type length

[Steven Hawkins (JIRA)]

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

Steven Hawkins resolved TEIID-4460.
-----------------------------------
    Resolution: Done


Updated the importValue logic to make sure that the truncation is applied only when bring in something typed as string, not just an object value.

> A view field defined as clob, on a google spreadsheeet model, returns data truncated to string type length
> ----------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-4460
>                 URL: https://issues.jboss.org/browse/TEIID-4460
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.4
>            Reporter: Marco Ardito
>            Assignee: Steven Hawkins
>             Fix For: 9.1, 9.0.5
>
>
> A google spreadsheet model text cell can contain way more data than the string type, and even if it is identified by teiid as string (4000 chars), the returned data is the whole original text, ie: it could be more than 4000 chars.
> A view that selects from the "native" method of the model, and defines the field as clob, though, returns only first 4000 chars, so it appears to be truncated.
> As you can find in the forum reference, where  you'll find more descriptive infos, examples and pictures, it seems that "It looks like the issue is that the implicit array_get operation is truncating the string - but it should not be"



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)