[Bug] 1.1 version Column prune incorrect result

[wangbo]

Search before asking

• [X] I had searched in the issues and found no similar issues.

Version

1.1

select t1.l_orderkey,
       t2.s_phone
  from (
        select l_suppkey,
               l_orderkey
          from lineitem
       )t1 left join(
        select s_suppkey,
               s_phone
          from supplier
       ) t2
    on t1.l_suppkey=t2.s_suppkey
 group by t1.l_orderkey,
          t2.s_phone

For this sql, when FE generate a HashNode, its output expr could contains TupleIsNullPredicate. The tupleId is 2, it stands for left table.

In Doris be, s_suppkey column couldn't be insert value because it's pruned. But s_suppkey could be used to eval TupleIsNullPredicate, then the output value isn't true; Here is my temporary solution, #12404. But we need to solve it in FE finally.

Are you willing to submit PR?

• [X] Yes I am willing to submit a PR!

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[wangbo]

Solution

1 generate a _column_to_check for HashJoinNode, by using HashJoinNode's _row_desc_for_other_join_conjunt or _row_descriptor. 2 We fill column by