Misidentify Binary Operator * As Wildcard

[maoxingda]

insert into
    public.tgt_tbl1
(
    id
)
select
    nvl(src_tbl1.id, 0) * 1 as id
from
    public.src_tbl1 as src_tbl1
;

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

with open(sql_file, 'r') as f:
    sql = f.read()

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

lr.print_column_lineage()

public.tgt_tbl1.id <- public.src_tbl1.*
public.tgt_tbl1.id <- public.src_tbl1.id

Expected behavior

public.tgt_tbl1.id <- public.src_tbl1.id

Python version (available via python --version)

• 3.11.5

SQLLineage version (available via sqllineage --version):

• 1.4.8

The lineage of the two variants of SQL is also incorrect.

insert into
    public.tgt_tbl1
(
    id
)
select
    coalesce(src_tbl1.id, 0) * 1 as id
from
    public.src_tbl1 as src_tbl1
;

insert into
    public.tgt_tbl1
(
    id
)
select
    case when src_tbl1.id is not null then src_tbl1.id else 0 end * 1 as id
from
    public.src_tbl1 as src_tbl1
;

[reata]

Yes this is a bug when binary operator * is misidentified as wildcard. We should get it fixed.