[teiid-issues] [JBoss JIRA] Moved: (TEIID-975) Materialization can fail when MMX passes back data that exceeds the maximum length, as defined in the materialized model.

[Van Halbert (JIRA)]

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

Van Halbert moved JBEDSP-1162 to TEIID-975:
-------------------------------------------

              Project: Teiid  (was: JBoss Enterprise Data Services Platform)
                  Key: TEIID-975  (was: JBEDSP-1162)
          Component/s: Query Engine
                           (was: Server)
        Fix Version/s:     (was: Westport)
    Affects Version/s: 7.1
                           (was: 5.5)


> Materialization can fail when MMX passes back data that exceeds the maximum length, as defined in the materialized model.
> -------------------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-975
>                 URL: https://jira.jboss.org/jira/browse/TEIID-975
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 7.1
>         Environment: Windows 2003 Server, 5.5 + patch 62
>            Reporter: Michael Walker
>
> When querying data from a source model, MMX allows data to exceed the model's length restrictions. For example, a SalesForce model might have a column called "biography:string(200)". Querying data from this column can sometimes result in a string that exceeds 200 characters, and MMX does not truncate the data.
> This causes problems when you attempt to materialize the model. Since the create table scripts are based on the model definition, the mat view table will not accommodate data that exceeds the length restrictions. Following the previous example, this means that the biography data will raise a "inserted length too large for column" error, causing the rest of the materialization to fail.
> The new materialization process will need to account for this issue, or perhaps MMX should truncate data that exceeds the defined length found within the model.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira