You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When we try to rename a table in a mode other than RT, we get no understandable error. It would be nice if the error would indicate that we are using the wrong table type.
MRE
mysql -v -h0 -P9306 -e "CREATE TABLE index1(f text, s string); CREATE TABLE dist_table type='distributed' local='index1'; CREATE TABLE products(title text, meta json) type='pq'; ALTER TABLE dist_table RENAME new_dist_table; ALTER TABLE products RENAME new_products;"
--------------
CREATE TABLE index1(f text, s string)
--------------
--------------
CREATE TABLE dist_table type='distributed' local='index1'
--------------
--------------
CREATE TABLE products(title text, meta json) type='pq'
--------------
--------------
ALTER TABLE dist_table RENAME new_dist_table
--------------
ERROR 1064 (42000) at line 1: Source table dist_table not exists
--------------
ALTER TABLE products RENAME new_products;
--------------
ERROR 1064 (42000) at line 1: Source table products not exists
--------------
The text was updated successfully, but these errors were encountered:
sanikolaev
changed the title
Improvement of errors when renaming a distributed table different from RT mode
Improvement of errors when renaming a distributed table different from RT
May 20, 2024
djklim87
changed the title
Improvement of errors when renaming a distributed table different from RT
Improvement of errors when renaming a RT table
May 20, 2024
When we try to rename a table in a mode other than RT, we get no understandable error. It would be nice if the error would indicate that we are using the wrong table type.
MRE
The text was updated successfully, but these errors were encountered: