Skip to content

Inconsistant result in -f and -g -f commands #665

@nameless0704

Description

@nameless0704

Describe the bug
Different parsing results when processing same input file.

SQL
After activating the virtualenv, run
sqllineage -f filename.sql
sqllineage -g -f filename.sql
getting two different results.

To Reproduce

  • if CLI (Command Line Interface): provide the command you're calling and the output.
    For example:
sqllineage -f filename.sql
Statements(#): 1
Source Tables:
    <default>.c_pb_exch_rate_info
    <default>.c_pb_std_inter_org
    <default>.c_pt_corp_cust_fin_index
    <default>.m_1io_inter_org
    <default>.m_1io_prtcptr_bank_no_info
    <default>.m_1pt_ccms_cust_basic_info_tab
    <default>.m_1pt_ccms_cust_rat_role_info
    <default>.m_1pt_ccms_incls_fin_label_info
    <default>.m_1pt_core_cust_grp_basic_info
    <default>.m_1pt_corp_partic
    <default>.m_1pt_corp_partic_catgr_hst
    <default>.m_1pt_corp_partic_cotx_info_hst
    <default>.m_1pt_corp_partic_expand_info
    <default>.m_1pt_corp_partic_inslt_hst
    <default>.m_1pt_corp_partic_oper_info
    <default>.m_1pt_corp_partic_oper_survey_info
    <default>.m_1pt_corp_partic_org_catgr_hst
    <default>.m_1pt_corp_partic_other_info
    <default>.m_1pt_corp_partic_qlf_info_hst
    <default>.m_1pt_corp_partic_reg_info
    <default>.m_1pt_fin_org_cust_expand_info
    <default>.m_1pt_fin_org_cust_org_expand_info
    <default>.m_1pt_inter_rat_reslt
    <default>.m_1pt_partic
    <default>.m_1pt_partic_aml_idtfy_info_hst
    <default>.m_1pt_partic_corp_annuity_info_hst
    <default>.m_1pt_partic_doc_info_hst
    <default>.m_1pt_partic_fix_tel_addr_hst
    <default>.m_1pt_partic_imp_label_hst
    <default>.m_1pt_partic_mobile_tel_addr_hst
    <default>.m_1pt_partic_name_hst
    <default>.m_1pt_partic_phys_addr_hst
    <default>.m_1pt_partic_rela_hst
    <default>.m_1pt_partic_syn_statmt_info_hst
    <default>.m_2pd_core_dpsit_prod
    <default>.m_3ag_clrhs_bil_info
    <default>.m_3ag_cntrc_limi_cntrct
    <default>.m_3ag_cntrc_limi_prod_subopt_cntrct
    <default>.m_3ag_cntrct
    <default>.m_3ag_cntrct_imp_dt_hst
    <default>.m_3ag_cntrct_relat_pty_info_hst
    <default>.m_3ag_cust_total_cnt_subopt
    <default>.m_3ag_dom_lc_buyer_estb_cntrct
    <default>.m_3ag_dom_lc_buyer_fin_cntrct
    <default>.m_3ag_dom_lc_buyer_income_bil_cntrct
    <default>.m_3ag_dom_lc_seller_fin_cntrct
    <default>.m_3ag_dpsit_accnt
    <default>.m_3ag_exp_col_fin_cntrct
    <default>.m_3ag_exp_dbl_fact_invoice_cntrct
    <default>.m_3ag_exp_lc_cntrct
    <default>.m_3ag_exp_lc_fin_cntrct
    <default>.m_3ag_fft_cntrct
    <default>.m_3ag_flexi_fin_cntrct
    <default>.m_3ag_guar_letter_estb_cntrct
    <default>.m_3ag_imp_agcol_fin_cntrct
    <default>.m_3ag_imp_exp_reim_refn_cntrct
    <default>.m_3ag_imp_lc_arr_of_cntrct
    <default>.m_3ag_imp_lc_cntrct
    <default>.m_3ag_imp_lc_fin_cntrct
    <default>.m_3ag_imp_pick_goods_guar_cntrct
    <default>.m_3ag_lnacct
    <default>.m_3ag_obank_elec_acpt_bil_cntrct
    <default>.m_3ag_obank_paper_acptbil_cntrct
    <default>.m_3ag_order_fin_fin_cntrct
    <default>.m_3ag_pool_fin_crdt_line_deg_sub_cont
    <default>.m_5ev_fact_busi_pst_fin_event
    <default>.m_9rf_quot_para_tab
    <default>.m_pb_pub_cd
    <default>.m_pb_pub_cd_map
    <default>.t_md_cbs_para_trans
Target Tables:
    <default>.c_pt_corp_cust
  • elif Web UI (Web User Interface): provide the lineage graph which could be downloaded from the page, or screenshots if there're components other than the lineage graph that's related to this bug.
    C_PT_CORP_CUST_combined sql

Expected behavior
Getting same results in different format but same tables parsed

Python version (available via python --version)

  • 3.10.11

SQLLineage version (available via sqllineage --version):

  • 1.5.3

Metadata

Metadata

Assignees

No one assigned

    Labels

    questionFurther information is requested

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions