ql/src/test/queries/clientnegative/temp_table_rename.q

create temporary table tmp1 (c1 string);
create temporary table tmp2 (d1 string);
alter table tmp2 rename to tmp1;