Open delphisharp opened 5 months ago
There're two issues we need to solve.
- when sql is upper(), column lineage bbb is error
Looks like we have some issue with upper case alias used together with UNION. A minimal example with same issue:
INSERT OVERWRITE TABLE TARGET
SELECT MSISDN, BUSI_ID
FROM SOURCE1
UNION ALL
SELECT CONCAT(A.MSISDN,'20230826') MSISDN, A.MUSIC_BUSI_CODE
FROM SOURCE2 A
Change alias A
to lower case a
generate correct output.
- column lineage aaa is error. should be is source3
Right we we say we don't know if aaa is from subquery a or table source3. But actually we can be smarter, because a is subquery contains only one column named msisdn, which makes table source3 the only possibility. But this "smart logic" is not in our code yet.
Describe the bug For example:
but if sql is lower():
Expected behavior
bbb
is erroraaa
is error. should be is source3Python version (available via
python --version
)SQLLineage version (available via
sqllineage --version
):