]
Barry LaFond resolved TEIIDDES-952.
-----------------------------------
Assignee: Barry LaFond
Fix Version/s: 7.4
Resolution: Done
Fixed error in SqlTransformationMappingRootValidationRule that prevented procedures from
being recognized as a valid source. Fixed in conjunction with TEIIDDES-951
View model transformation with procedure as only source fails
validation with The sql transformation does not have a valid source
---------------------------------------------------------------------------------------------------------------------------------
Key: TEIIDDES-952
URL:
https://issues.jboss.org/browse/TEIIDDES-952
Project: Teiid Designer
Issue Type: Bug
Components: Modeling
Affects Versions: 7.4
Environment: Fedora 14, OpenJDK Runtime Environment (IcedTea6 1.9.7)
(fedora-52.1.9.7.fc14-x86_64)
Reporter: Paul Nittel
Assignee: Barry LaFond
Fix For: 7.4
Attachments: TextSourceTransformError_MPS.zip
I was following the Recursive Text E2E test. This calls for creating a relational source
model with a procedure (getTextFiles) for use in a view model's transformation. With
all this modeled, the transformation fails with the error: The sql transformation does not
have a valid source.
The actual transformation SQL text is:
SELECT * FROM (EXEC text.getTextFiles('EmpData.txt')) AS f, TEXTTABLE(f.file
COLUMNS lastName string, firstName string, middleName string, empId biginteger, department
string, annualSalary double, title string, homePhone string, mgrId biginteger, street
string, city string, state string, ZipCode string HEADER 3) AS emp
In previous versions this passed validation. Model project set is attached.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: