[JBoss JIRA] (TEIIDDES-2741) Concatenation operator || incompatible with import SQL
- First Post
- Replies
- Stats
-
Go to
- ----- 2024 -----
- 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/TEIIDDES-2741?page=com.atlassian.jira.plu...
]
Jean-Pierre Matsumoto commented on TEIIDDES-2741:
-------------------------------------------------
I'm interested to have this bug fixed because it would help me in my work. Does
someone can suggest on how to fix ?
My understanding is:
- Concat operator shortcut is double-pipe '||'
- But in export / import SQL, pipe char is also field separator
- Import operation doesn't read well the full SQL query containing double-pipe
because it think badly that double-pipe is field separator.
Concatenation operator || incompatible with import SQL
------------------------------------------------------
Key: TEIIDDES-2741
URL: https://issues.jboss.org/browse/TEIIDDES-2741
Project: Teiid Designer
Issue Type: Bug
Components: Transformations
Affects Versions: 9.0.3
Environment: Windows 7 64-bit
JBoss Studio 8.1.0
Teiid Designer 9.0.3
Reporter: Jean-Pierre Matsumoto
Attachments: 2015-12-01_14-19-28.png
When an SQL transformation contains concatenation operator ||, it cannot be imported.
Error raised is: Problem importing the transformation SQL from a file. 2
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
2986
days inactive
2986
days old
teiid-designer-issues@lists.jboss.org
0 comments
1 participants
tags (0)
participants (1)
-
Jean-Pierre Matsumoto (JIRA)