[C++][Acero] record_batch_reader_source does not support `select * limit 3`

[egolearner]

Describe the bug, including details regarding any error messages, version, and platform.

    auto table = GetTable();
    auto reader = std::make_shared<arrow::TableBatchReader>(table.ValueOrDie());
    ac::Declaration plan = ac::Declaration::Sequence({
        {"record_batch_reader_source",
         ac::RecordBatchReaderSourceNodeOptions{reader}},
        {"fetch", ac::FetchNodeOptions{0, 3}},
    });
    return ExecutePlanAndCollectAsTableByBatchReader(std::move(plan));

error message:

Running Err:Invalid: Fetch node's input has no meaningful ordering and so limit/offset will be non-deterministic.  Please establish order in some way (e.g. by inserting an order_by node)%             

Component(s)

C++

[zanmato1984]

Issue resolved by pull request 47482
#47482