]
Barry LaFond updated TEIIDDES-68:
---------------------------------
Component/s: Transformations
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: