error 1032 : cannot find record when updating a view

[Hugo T.]

Hi,

I had this (updatable) view working until I partitioned some tables involved in the view definition:

delimiter $$

CREATE ALGORITHM=MERGE DEFINER=`root`@`%` SQL SECURITY DEFINER 
VIEW `v_productUpdatePriceStockByCombination` AS 
select `p`.`id_product` AS `id_product`,
`pl`.`name` AS `name`,
`m`.`name` AS `Fabricante`,
`pa`.`id_product_attribute` AS `id_product_attribute`,
`pef_product_attribute`(`pa`.`id_product_attribute`) AS `Desc_combinacion`,
`pa`.`supplier_reference` AS `supplier_reference`,
`pa`.`ean13` AS `CodigoBarra`,
`p`.`quantity` AS `ProdCantidad`,
`p`.`price` AS `ProdPrice`,
`pa`.`quantity` AS `CombCantidad`,
`pa`.`price` AS `CombPrice`,
`pa`.`default_on` AS `default_on`,
`p`.`location` AS `ubicacion`,
`pa`.`stock_minimo` AS `Stk_Min` 
from (((`ps_product` `p` join `ps_product_attribute` `pa` on((`p`.`id_product` = `pa`.`id_product`))) 
join `ps_product_lang` `pl` on((`pl`.`id_product` = `p`.`id_product`))) 
join `ps_manufacturer` `m` on((`p`.`id_manufacturer` = `m`.`id_manufacturer`)))
 where ((`pl`.`id_lang` = 1) and (`p`.`active` = 1)) WITH CASCADED CHECK OPTION$$

are updatable views allowed to update the base tables when they are partitioned ?
is this a limitation ?

thanks for any help

Hugh

Ps. Centos 5.5
Mysql 5.1.54



Edited 2 time(s). Last edit at 02/07/2011 08:51PM by Hugo T..