Unit test for ALTER TABLE RENAME TO on cached tables.