[teiid-issues] [JBoss JIRA] (TEIID-5135) REPEAT function truncates strings to 4000 characters

[Steven Hawkins (JIRA)]

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

Steven Hawkins updated TEIID-5135:
----------------------------------
    Issue Type: Quality Risk  (was: Bug)
      Priority: Minor  (was: Critical)


The system has a max length for the string data type.  That affects all functions evaluated in Teiid.  You may adjust this with a system property if you have a different need org.teiid.maxStringLength - https://teiid.gitbooks.io/documents/content/admin/System_Properties.html

You should still keep it as constrained as possible as the string type for a live batch is always fully held in memory.

> REPEAT function truncates strings to 4000 characters
> ----------------------------------------------------
>
>                 Key: TEIID-5135
>                 URL: https://issues.jboss.org/browse/TEIID-5135
>             Project: Teiid
>          Issue Type: Quality Risk
>          Components: Query Engine
>    Affects Versions: 9.3.4
>         Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final)
>            Reporter: dalex dalex
>            Assignee: Steven Hawkins
>            Priority: Minor
>
> Probably it's not bug. When running the following queries:
> {code:sql}
> Select Length(Repeat('abcde', 9000));; /* 4000 chars */
> Select Length(Repeat('a', 9000));; /* 4000 chars */
> {code}
> Teiid returns 4000 instead of 9000. Can the internal truncation be avoided (maybe in some cases) or not?



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)