sql-metadata icon indicating copy to clipboard operation
sql-metadata copied to clipboard

Library fails to parse inline function correctly while identifying columns

Open sunilrenukaiah opened this issue 2 years ago • 0 comments

Example : output to identify columns is not correct for below query

SELECT

Calendar_year_lookup.Yr,

{fn concat('Q',Calendar_year_lookup.Qtr)},

Outlet_Lookup.State,

Article_lookup.Family_name,

sum(Shop_facts.Amount_sold),

sum(Shop_facts.Quantity_sold),

sum(Shop_facts.Margin) FROM Calendar_year_lookup, Outlet_Lookup, Article_lookup, Shop_facts WHERE ( Outlet_Lookup.Shop_id=Shop_facts.Shop_id ) AND ( Article_lookup.Article_id=Shop_facts.Article_id ) AND ( Shop_facts.Week_id=Calendar_year_lookup.Week_id ) GROUP BY

Calendar_year_lookup.Yr,

{fn concat('Q',Calendar_year_lookup.Qtr)},

Outlet_Lookup.State,

Article_lookup.Family_name

sunilrenukaiah avatar May 03 '23 09:05 sunilrenukaiah