[teiid-designer-issues] [JBoss JIRA] Updated: (TEIIDDES-68) In Procedure, once an alias is established, must use alias, not fully qualified name

In Procedure, once an alias is established, must use alias, not fully qualified name ------------------------------------------------------------------------------------ Key: TEIIDDES-68 URL: https://jira.jboss.org/jira/browse/TEIIDDES-68 Project: Teiid Designer Issue Type: Bug Components: Transformations Reporter: Paul Nittel I was using the Northwind DB (for a change) and created a procedure that returns the orders where the quantity ordered is more than the available units in stock. I started by creating the criteria using the Criteria Builder, added aliases to the FROM, then defined the specific columns (was '*' before that). I wound up with: CREATE VIRTUAL PROCEDURE BEGIN SELECT od.OrderID, p.ProductName, od.Quantity, p.UnitsInStock FROM NWind.Order_Details AS od, NWind.Products AS p WHERE (NWind.Order_Details.ProductID = NWind.Products.ProductID) AND (NWind.Order_Details.Quantity > NWind.Products.UnitsInStock); END This won't validate, because, "Resolver Error: Symbol NWind.Order_Details.ProductID is specified with an unknown group context". If I change the criteria to use the 'od' and 'p' aliases, it'll validate. Seems like the use of fully qualified names should be valid.