TST: Use tempfiles in all tests.

Includes @jreback's commits from #5422 and hdf_temp:
* TST: make pytables tests go thru a temporary dir and file
* TST/BUG: incorrect way of testing for r+ modes

TST: fix temporary files by using mktemp (rather than mkstemp) which opens them
BUG: not clearing the cache when reindexing issue when partial setting (GH5424)
TST: provide temporary file creation inside of io/pytables.py directly w/o
     opening a named temporary file
TST: named temporary file creation back to mkstemp in utils/testing.py/ensure_clean
Merge pull request #5426 from jreback/indexing_cache

BUG: not clearing the cache when reindexing issue when partial setting (GH5424)
Merge pull request #5425 from jreback/temp_file

TST: Use tempfiles in all tests.
BUG: to_timedelta of a scalar returns a scalar, closes #5410.
Merge pull request #5415 from danielballan/to-timedelta-scalar

BUG: to_timedelta of a scalar returns a scalar, closes #5410.
BUG/TST: bug in the test apparatus when dtypes are equal in a Series but the
         values are not equal
Merge pull request #5434 from jreback/test_fix

BUG/TST: bug in the test apparatus when dtypes are equal in a Series but the values are not equal