When renaming a table using
ALTER TABLE ... RENAME TO ... it reports an error “Leaf Error (127.0.0.1:3307): Feature ‘Cross database ALTER TABLE … RENAME’ is not supported by MemSQL.” whenever the rename target table name is a qualified name. Even if the schema / database is the same as the source table.
So this doesn’t work:
ALTER TABLE TEST.T RENAME TO TEST.T2