gh-7044: set TMPDIR to workingdir in tests
Change exception message
Merge pull request #7113 from jdemeyer/test_tmpdir

gh-7044: set TMPDIR to workingdir in tests