For multi equalities we try to add selectivity estimates using EITS but currently this does not work
In the function table_multi_eq_cond_selectivity
So as we see here the comparision
eq_fld_sel is set to 1, so eq_fld_sel would always remain 1 as we try to update the value in the cases curr_eq_fld_sel < 1.
This needs to be corrected.
What I understand the code it does here is it takes the highest selectivity estimate for fields inside the multiple equality which makes sense as
we want to keep our estimates pessimistic
After discussing with Igor he mentioned that the intention for the function was to take into account selectivity of equalities for condition on the same table like tbl.col1 = tbl.col2 .