Attribute dependency not captured for complex plans

[uday1409]

We observed that when there are multiple nested queries along with window functions involved, attribute dependency not properly tracked. For example, avg_monthly_purhcase dependency should point to customer_id and purchase_amount but the link is completely broken. Attaching test queries and generated plan..

SampleQueryWithNestedWindowFunction.txt
customerprocess_plan.txt

[uday1409]

I will check if I can fix this when I get time. Able to reproduce and have a test query as well

[wajda]

thank you @uday1409, your contribution is highly appreciated!