WL#9826: Allow RENAME TABLES under LOCK TABLES

Affects: Server-8.0   —   Status: Complete

There is a need to do:

LOCK TABLES tbl WRITE;
RENAME TABLE tbl TO tbl_del, new_tabl TO tbl;

The semantics of this operation should be similar to ALTER TABLE RENAME.