Problem with ALTER TABLE ... RENAME TO


#1

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

#2

Thanks, yes we don’t properly support that two part name syntax. I’ll open a task to look into whats going on there.