Unusual: Mysql, partitioning

### Partitioning:

mysql>ALTER TABLE `els_clipping_tester_err` ADD FOREIGN KEY (`clipping_id`) REFERENCES `inf_clipping3`(`CLIP_ID`) ON DELETE RESTRICT ON UPDATE RESTRICT;
ERROR 1005 (HY000): Can't create table 'inforia.#sql-7f30_17f4dd0' (errno: 150)
Cannot resolve table name close to ....
mysql>alter table clipping3 remove partitioing;
mysql>ALTER TABLE `els_clipping_tester_err` ADD FOREIGN KEY (`clipping_id`) REFERENCES `inf_clipping3`(`CLIP_ID`) ON DELETE RESTRICT ON UPDATE RESTRICT;
Query OK, 0 rows affected (0.04 sec)
Records: 0 Duplicates: 0 Warnings: 0

The explaination is the limitation for innodb.

  1. No comments yet.

  1. No trackbacks yet.