[JBoss JIRA] (TEIID-5135) REPEAT function truncates strings to 4000 characters
- First Post
- Replies
- Stats
-
Go to
- ----- 2025 -----
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-5135?page=com.atlassian.jira.plugin...
]
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)
2624
days inactive
2624
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)