Problem with ALTER TABLE ... RENAME TO

Help
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.

3

I have the same problem please help

4

This issue was fixed in MemSQL 7.

5

I can confirm that this works.

1 Like