[Tech Request]: optimize composite key pushdown filter exprs

[XuPeng-SH]

Is there an existing issue for the same tech request?

• I have checked the existing issues.

Does this tech request not affect user experience?

• This tech request doesn't affect user experience.

What would you like to be added ?

(a,b,c) are composite keys

a=? and b in (?,?...) ==> __mo_cpkey_col prefix_in (?,?...)
a=? and b = ? and c in (?,?...) ==> __mo_cpkey_col in (?,?...)

Why is this needed ?

No response

Additional information

No response

[XuPeng-SH]

SELECT count(*) AS low_stock FROM ( SELECT s_w_id, s_i_id, s_quantity FROM bmsql_stock WHERE s_w_id = ? AND s_quantity < ? AND s_i_id IN ( SELECT ol_i_id FROM bmsql_district JOIN bmsql_order_line ON ol_w_id = d_w_id AND ol_d_id = d_id AND ol_o_id >= d_next_o_id - 20 AND ol_o_id < d_next_o_id WHERE d_w_id = ? AND d_id = ? ) ) AS L

s_w_id and s_i_id are composite primary keys.

[aunjgr]

feature is implemented.