[teiid-designer-issues] [JBoss JIRA] Commented: (TEIIDDES-228) Import transformation SQL fails to do anything

Import transformation SQL fails to do anything ---------------------------------------------- Key: TEIIDDES-228 URL: https://issues.jboss.org/browse/TEIIDDES-228 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 6.2.0 Environment: Fedora 10, Designer 20090922 build (same thing with RC1) Reporter: Paul Nittel Assignee: Barry LaFond Fix For: 7.5 Attachments: VqtExportedTransformationSQL.txt, VqtSqlImport_ModelProjectSet.zip I exported the transformation SQL from the VQT model. When I tried to import the SQL into a new VQT model, it gave the appearance it completed successfully, but none of the tables were defined. There were no errors or exceptions found in the log. Whoa... I just found a warning: Could not parse the following row: Agg3|SELECT|SELECT COUNT(*) FROM BQT1.SmallA. The format of the exported file is not the same as that of the Metadata Text Importer, so to use that route the file must be edited. (The export version takes into account the SELECT, INSERT, UPDATE, DELETE possibilities.) BTW, this had issues as well, but that's another JIRA.