Control the number of rows returned by child executor

[qw4990]

Feature Request

Is your feature request related to a problem? Please describe:

TiDB uses chunk to carry data from children to parents, but the num of rows returned by children can’t be controlled by parents.
Most of the time, children return 1024 rows, which is the default size.
That is inappropriate in some cases, for example the parent is LimitN, which only needs N rows.

Describe the feature you'd like:

After this PR(#8994), chunk has been replaced to RecordBatch.
So we can add a new field RequiredRows to indicate the number of rows parents want.
And children use it to determine the number of rows returned to parents, which can improve efficiency in some cases.

Describe alternatives you've considered:

No.