[JBoss JIRA] (TEIIDDES-2782) Copy paste sql to the transformation editor is not parsable
- First Post
- Replies
- Stats
-
Go to
- ----- 2026 -----
- May
- April
- March
- February
- January
- ----- 2025 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- 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/TEIIDDES-2782?page=com.atlassian.jira.plu...
]
Barry LaFond updated TEIIDDES-2782:
-----------------------------------
Steps to Reproduce:
# import project from the attachment
# open transformation editor in the producer (SchemaModel/ResultSetDocument)
# copy the query from this
{code:java}
SELECT
convert(ID, double) AS producerID, NAME
FROM
TvGuideStaging.PRODUCTION_HOUSES
{code}
# Validate SQL
Alternate SQL
{code:java}
SELECT
'A' as x
{code}
was:
# import project from the attachment
# open transformation editor in the producer (SchemaModel/ResultSetDocument)
# copy the query from this
{code:java}
SELECT
convert(ID, double) AS producerID, NAME
FROM
TvGuideStaging.PRODUCTION_HOUSES
{code}
# Validate SQL
Copy paste sql to the transformation editor is not parsable
-----------------------------------------------------------
Key: TEIIDDES-2782
URL: https://issues.jboss.org/browse/TEIIDDES-2782
Project: Teiid Designer
Issue Type: Bug
Components: Editors, Transformations
Affects Versions: 10.0.1
Environment: Windows 10 Pro N
Windows 7 Enterprise
Reporter: Matej Kralik
Assignee: Ted Jones
Priority: Critical
Fix For: 11.1.3
Attachments: XmlStagingProject.zip, endOfFile.mkv
When I copy a sql query from any source (notepad, web browser ...) and paste it to the
transformation editor show me that "The query is not parsable.Error in parsing of sql
- null ."
When I deleted all newlines from sql query or I wrote it myself to the editor, sql query
was validated.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
2936
days inactive
2936
days old
teiid-designer-issues@lists.jboss.org
0 comments
1 participants
tags (0)
participants (1)
-
Barry LaFond (JIRA)