You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
We encountered a minor issue with a query where some with_name is incorrectly marked as a table. I built this minimal example:
import sql_metadata
query = """
with
A as (
with intermediate_query as (
select
id,
some_column
from table_one
)
select
id,
some_column
from intermediate_query
),
B as (
select
id,
other_column
from table_two
)
select
A.id,
some_column,
other_column
from A
inner join B
on A.id = B.id
"""
parser = sql_metadata.Parser(query)
parser.tables, parser.with_names
With version 2.8.0 I get (['table_one', 'B', 'table_two'], ['A', 'intermediate_table'])
The text was updated successfully, but these errors were encountered:
Hi! Thank you, your package is very useful to us!
We encountered a minor issue with a query where some
with_name
is incorrectly marked as atable
. I built this minimal example:With version 2.8.0 I get
(['table_one', 'B', 'table_two'], ['A', 'intermediate_table'])
The text was updated successfully, but these errors were encountered: