]
Barry LaFond commented on TEIIDDES-2868:
----------------------------------------
[~virtualdatabase] Since you can type in the SQL by hand and make it work... I'm
assuming it's a weird Windows character that's getting in the way.
>>> can you paste the SQL (from clipboard) into a txt file
and attach it? I can then try load/debug the file to look for chars not on linux and add
those during debug to replicate it then provide a fix
texttable parsing error
-----------------------
Key: TEIIDDES-2868
URL:
https://issues.jboss.org/browse/TEIIDDES-2868
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 10.0
Environment: Teiid
Designer 10.0.0.Final-v20160413-1817-B4094 org.teiid.designer.feature.feature.group JBoss
by Red Hat
Reporter: Tom Johnston
Attachments: marketdata-price.txt, QuickStartSource.xmi, QuickStartViewModel.xmi,
screenshot-1.png, screenshot-2.png, screenshot-3.png, TeiiDDes2868.zip
I successfully created a physical table and view using texttable.
I can query it.
I then manually created another view to a different file and it kept failing with a very
ambiguous error when I tried validating.
ERROR: Error in parsing of sql - null
I then created another view with a diff name of the 1st view using the same copy/pasted
transformation.. it too resulting with the same error:
The auto-generated view verbiage that was created and that I re-used was:
SELECT
A.OldWAC, A.NewWAC
FROM
(EXEC SourceModel.getTextFiles('wac.txt')) AS f, TEXTTABLE(f.file COLUMNS
OldWAC string, NewWAC string DELIMITER '|') AS A
You can also clone the automatically created object, copy the transformation, clear the
transformation, paste back the transformation and it too fails with the same error.
ALSO if I deploy the 1st physical and view models to a vdb I can execute the view
transformation that fails in designer fine from squirrel getting data returned.