COMPAT: provide compat tests and better error messages for multiple file opening on PyTables >= 3.1 (GH6047)

close #6047