Add missing test ensuring no subqueries for whole table batching

[fatkodima]

Follow up to #45414.
As discussed in #45414 (comment).

cc @byroot

[simi]

Thanks for the followup @fatkodima. I did quick check locally and commenting out except part in batching logic makes this test failing. 💪

[byroot]

Thanks!