Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The second and subsequent case when subqueries in the select_clause are not correctly recognized #559

Closed
maoxingda opened this issue Jan 19, 2024 · 0 comments
Labels
bug Something isn't working

Comments

@maoxingda
Copy link
Contributor

SQL

select
    1,
    case
        when 1 = ( select count(*) from tab1 where col1 = 'tab2' )
            then ( select count(*) from tab2 )
        else 0
    end as cnt

To Reproduce

Note here we refer to SQL provided in prior step as stored in a file named test.sql

from sqllineage.runner import LineageRunner

with open("test.sql") as f:
    sql = f.read()

lr = LineageRunner(sql, dialect="redshift")

print(lr.source_tables)

Actual behavior

[]

Expected behavior

[Table: <default>.tab1, Table: <default>.tab2]

Python version (available via python --version)

  • 3.10

SQLLineage version (available via sqllineage --version):

  • 1.5.0

Additional context

@maoxingda maoxingda added the bug Something isn't working label Jan 19, 2024
maoxingda added a commit to maoxingda/sqllineage that referenced this issue Jan 19, 2024
@reata reata closed this as completed Jan 20, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

2 participants