Fix sharding on oc_files_metadata in getMetadataFromFileIds and properly test it

[CarlSchwan]

came up in #54277 when trying to do a select * from oc_files_metadata where file_id in [ ...... ]

As the oc_files_metadata will continue growing, it likely makes sense to do that