[teiid-issues] [JBoss JIRA] (TEIID-5135) REPEAT function truncates strings to 4000 characters
Steven Hawkins (JIRA)
issues at jboss.org
Thu Nov 2 13:02:00 EDT 2017
[ 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)
More information about the teiid-issues
mailing list