search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
1.03k stars 343 forks source link

[MySQL] Unknown partitioning type KEY, skipping partitioning of table #1516

Closed sanyamsinghal closed 2 years ago

sanyamsinghal commented 2 years ago

Getting this error Unknown partitioning type KEY, skipping partitioning of table while exporting tables and partitions for a table that is key partitioned.

These are DDLs to create the same on MySQL DB


CREATE TABLE key_partition_test (
    a INT,
    b INT primary key,
    c INT
)
PARTITION BY key()
partitions 2;

INSERT INTO key_partition_test VALUES (5,6,1),(3,4,6), (5,11,1), (5,1,2),(5,5,5);

Is there some plan to start supporting KEY partitioning anytime soon in the future? cc @darold

darold commented 2 years ago

Commit 8447e90 might solve this issue.

sanyamsinghal commented 2 years ago

Thanks, @darold for the quick fix. Will try it out and update here.