adding type cast operator produces different results for redshift dialect

[robertmatthewcook]

>>> from sqllineage.runner import LineageRunner

>>> sql_1="insert into new_names SELECT (((fname) || ' ') || (lname)) AS full_name FROM names;"

>>> sql_2="insert into new_names SELECT (((fname)::text || ' '::text) || (lname)::text) AS full_name FROM names;"

>>> LineageRunner(sql_1, 'redshift').print_column_lineage()

<default>.new_names.full_name <- <default>.names.fname

<default>.new_names.full_name <- <default>.names.lname

>>> LineageRunner(sql_2, 'redshift').print_column_lineage()

<default>.new_names.full_name <- <default>.names.fname

>>> 

[reata]

Thanks for reporting it. Bug confirmed. It's triggered when type cast used together with parenthesis.

I tried removing all parenthesis and it's working fine.

insert into new_names SELECT fname::text || ' '::text || lname::text AS full_name FROM names;

$ sqllineage -f test.sql --dialect=redshift -l column
<default>.new_names.full_name <- <default>.names.fname
<default>.new_names.full_name <- <default>.names.lname

[reata]

This issue is fixed as a result of 6c646a5, where we fixed a separate issue while also optimize the column-from-parenthesis handling.