cannot create table with a name which is occupied before

[waynexia]

What type of bug is this?

Incorrect result

What subsystems are affected?

Standalone mode

What happened?

For the following queries

CREATE TABLE t(i INTEGER, j BIGINT TIME INDEX);

ALTER TABLE t RENAME new_table;

SELECT * FROM t;

CREATE TABLE t(i INTEGER, j BIGINT TIME INDEX);

the third SELECT clause will report the table doesn't exist, but the fourth CREATE clause will fill due to table already exist

What operating system did you use?

M1 Mac

Relevant log output and stack trace

No response

How can we reproduce the bug?

By running the provided queries

[waynexia]

cc @e1ijah1 who has made a great contribution to RENAME TABLE feature

[e1ijah1]

cc @e1ijah1 who has made a great contribution to RENAME TABLE feature

I have already submitted my PR and PTAL