Re: Convert non-partitioned -> partitioned

[Luca Ghezzo]

Mikael Ronstrom Wrote:
> You simply write:
> ALTER TABLE table_name
> PARTITION BY ...
>
> followed by exactly the same partitioning syntax
> you would have used
> if you were to create the table.

So please tell me if I'm right: imagine a table ABC having lots of records and stored in file ABC.ibd. If I write something like that, using eight partitions and storing each partition in a different file ABC_n.ibd (in different places, too), what I'm going to see is:

- new files are created
- records are migrated in new partitions according to partitioning criteria
- in the end, old ABC.ibd file is deleted (I don't expect it to survive since it would be useless at this point)

Is it correct? This is a test I'm going to do by myself ASAP, anyway.