MySQL Partition by String ColumnNovember 15, 2015December 15, 2022You might have known that LIST, RANGE, and HASH partitions all refuse to accept VARACHAR column as the native partition key. mysql> alter table locations… Read More »MySQL Partition by String Column
How to Resolve ERROR 1564 (HY000): This partition function is not allowedSeptember 2, 2013December 30, 2022ERROR 1564 (HY000) When we used round() function for the partition key, we got ERROR 1564 (HY000). mysql> alter table sales partition by range(unix_timestamp(order_time)) partitions… Read More »How to Resolve ERROR 1564 (HY000): This partition function is not allowed