Rename a non exist table report wrong error message

[xiongjiwei]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create database db;
use db;
rename table tb1 to tb2;

2. What did you expect to see? (Required)

MySQL 5.7
ERROR 1017 (HY000): Can't find file: './db_optimistic/tb1.frm' (errno: 2 - No such file or directory)

MySQL 8.0
ERROR 1146 (42S02): Table 'db_optimistic.tb1' doesn't exist

3. What did you see instead (Required)

TiDB 4.0.11
ERROR 1017 (HY000): Can't find file: 'db_optimistic' (errno: {%!d(string=tb1) %!d(string=tb1)} - %!s(MISSING))

[yashpadwalkar]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create database db;
use db;
rename table tb1 to tb2;

2. What did you expect to see? (Required)

MySQL 5.7
ERROR 1017 (HY000): Can't find file: './db_optimistic/tb1.frm' (errno: 2 - No such file or directory)

MySQL 8.0
ERROR 1146 (42S02): Table 'db_optimistic.tb1' doesn't exist

3. What did you see instead (Required)

TiDB 4.0.11
ERROR 1017 (HY000): Can't find file: 'db_optimistic' (errno: {%!d(string=tb1) %!d(string=tb1)} - %!s(MISSING))

1. Minimal reproduce step
   ALTER TABLE table_name
   RENAME TO new_table_name;

[Abhilash-03]

alter table tb1 rename to tb2;

[fanrenhoo]

/assign [email protected]