Constant, random or timezone-dependent expressions in (sub)partitioning

[Carlo Rossetti]

Good morning,
i have this strange trouble.

MySQL VERSION: 5.5.15-LOG on window xp 32 bit.

CREATE TABLE `t_test` (
`marca_id` CHAR(5) NOT NULL DEFAULT '000'
) ENGINE=MYISAM DEFAULT CHARSET=utf8

INSERT INTO t_test
(marca_id)
VALUES ('001'),('002'),('002'),('003'),('003'),('004'),('006'),('009');

DROP FUNCTION IF EXISTS `IdToHash`;

DELIMITER $$

CREATE
FUNCTION `IdToHash`(stringid CHAR(6))
RETURNS INT DETERMINISTIC
BEGIN

RETURN CAST(stringid AS SIGNED);

END$$

DELIMITER;

this is all good, but when i add a partition:

ALTER TABLE t_test
PARTITION BY HASH(`IdToHash`(marca_id));

I obtain this error:

Query : ALTER TABLE t_test PARTITION BY HASH(`ru2a_daticase`.`IdToHash`(marca_id))

Error Code : 1064
Constant, random or timezone-dependent expressions in (sub)partitioning function are not allowed near ')

I don't understand this kind of error. Any idea?

Thank to everyone for your patience.

C.



Edited 1 time(s). Last edit at 09/18/2011 03:23AM by Carlo Rossetti.