Similar to issue #296 - When using alias.* in sub-query a column reference in parent query fails @ parser.columns

[anandupad]

The sql below works as expected

select q.hx_id
, q.text
from ( select prod_code, s.*
from testdb.test_table s
inner join testdb.test_table2 p on
s.s1_fk=p.p1_sk
) q

But the following SQL errors out when calling parser.columns

with x as ( select d.nbr, d.af_pk
from test_db.test_table3 d
)
select q.hx_id
, q.text
from ( select prod_code, s.*
from testdb.test_table s
inner join testdb.test_table2 p on
s.s1_fk=p.p1_sk
) q
inner join x on
q.s2_fk=x.af_pk

Traceback (most recent call last):
File "", line 1, in
File "C:\workspace\vrt_python37\lib\site-packages\sql_metadata\parser.py", line 214, in columns
self._handle_column_save(token=token, columns=columns)
File "C:\workspace\vrt_python37\lib\site-packages\sql_metadata\parser.py", line 647, in _handle_column_save
column = self._resolve_sub_queries(column)
File "C:\workspace\vrt_python37\lib\site-packages\sql_metadata\parser.py", line 786, in _resolve_sub_queries
already_parsed=self._subqueries_parsers,
File "C:\workspace\vrt_python37\lib\site-packages\sql_metadata\parser.py", line 834, in _resolve_nested_query
raise exc # pragma: no cover
File "C:\workspace\vrt_python37\lib\site-packages\sql_metadata\parser.py", line 828, in _resolve_nested_query
column_name
ValueError: 's2_fk' is not in list

Sample code

from sql_metadata import Parser
str="""with x as ( select d.nbr, d.af_pk
from test_db.test_table3 d
)
select src.hx_id
, src.text
from ( select prod_code, s.*
from testdb.test_table s
inner join testdb.test_table2 p on
s.s1_fk=p.p1_sk
) q
inner join x on
q.s2_fk=x.af_pk"""
parser=Parser(str)
parser.columns