[teiid-designer-issues] [JBoss JIRA] (TEIIDDES-1617) Capture view definition from database and apply as transformation query for viewModel table

[ https://issues.jboss.org/browse/TEIIDDES-1617?page=com.atlassian.jira.plu... ] Barry LaFond commented on TEIIDDES-1617: ---------------------------------------- So a MYSQL DB has the following raw DDL {code} *CREATE TABLE product (qty INT, price INT);* *CREATE VIEW product_info (the_quantity INT, the_price INT) AS SELECT qty, price, qty*price AS value FROM product;* {code} User can access this view with : *SELECT * FROM product_info;* Through Teiid IMPORT, the TABLE DDL will look like: {code} *CREATE FOREIGN TABLE product (qty INT, price INT);* {code} What will the "product_info" view be returned as? {code} *CREATE FOREIGN TABLE product_info (the_quantity INT, the_price INT);* {code} -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira