--echo # MyISAM would be harmless SET SESSION storage_engine='InnoDB'; --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings CREATE TABLE t1 (f_date DATE, f_varchar VARCHAR(30)) PARTITION BY HASH(CAST(YEAR(f_date) AS SIGNED INTEGER)); --echo # This statement crashes the server. --echo # CREATE partitioned table with three partitions in one step --echo # would be harmless. ALTER TABLE t1 ADD PARTITION PARTITIONS 1;