[JBoss JIRA] Updated: (TEIIDDES-68) In Procedure, once an alias is established, must use alias, not fully qualified name
by Barry LaFond (JIRA)
[ https://jira.jboss.org/jira/browse/TEIIDDES-68?page=com.atlassian.jira.pl... ]
Barry LaFond updated TEIIDDES-68:
---------------------------------
Fix Version/s: 6.1.0
Affects Version/s: 6.0.0
> 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
> Affects Versions: 6.0.0
> Reporter: Paul Nittel
> Fix For: 6.1.0
>
>
> 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: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
16 years, 8 months