sqllineage icon indicating copy to clipboard operation
sqllineage copied to clipboard

Incorrect source table recognition when two CTEs share the same query

Open minzhang2110 opened this issue 1 year ago • 1 comments

sqllineage version: 1.4.3

sql:

with t1 as(
select * from t
), t2 as(
select * from t
)

select * from t1
union all
select * from t2

output:

Statements(#): 1
Source Tables:
    <default>.t
    <default>.t2
Target Tables:

expect:

Statements(#): 1
Source Tables:
    <default>.t
Target Tables:

"t2" should not appear in source tables.

minzhang2110 avatar Jun 02 '23 09:06 minzhang2110