[Feature Request]: select ... for update support join tables

[dengn]

Is there an existing issue for the same feature request?

• [X] I have checked the existing issues.

Is your feature request related to a problem?

Example like below cannot work in MatrixOne as MO doesn's support select for join table update. 

SELECT t1.id, bill_no, stock_num, cur_position, in_time FROM t1 INNER JOIN t2 ON t1.reel_id = t2.reel_id WHERE t2.task_id IN (1739144656174305282)
AND t2.is_deleted = 0
AND t2.tenant_id = '000000'
AND t1.is_deleted = 0
AND t1.tenant_id = '000000' GROUP BY t1.id,bill_no,stock_num,cur_position,in_time FOR UPDATE

-- internal error: not support select from join table for update

Describe the feature you'd like

Follow mysql syntax and behavior.

Describe implementation you've considered

No response

Documentation, Adoption, Use Case, Migration Strategy

No response

Additional information

No response

[allengaoo]

暂未投入