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

Steven Hawkins commented on TEIID-5135:
---------------------------------------

A possibility would be to add a sql warning for this.  Otherwise could this just be resolved?

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