Add test case for JOIN, update Changelog and AUTHORS.