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

[dalex dalex (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5135?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13490014#comment-13490014 ] 

dalex dalex commented on TEIID-5135:
------------------------------------

Do you mean to warn a client when running queries with functions? You can hold on the issue to add the warning, no rush here from my side.

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