Re: MYSQL_FDW trigger BEFORE UPDATE changes to NEW on a col not in the update statement don't go through

Hi Francois, On Wed, Apr 22, 2020 at 8:09 AM Francois Payette wrote: > I create a trigger on an imported foreign table. In the procedure, I change > the value of a column that is not in the triggering update statement. This > change does not make it to the mysql side. I'm not an expert on

MYSQL_FDW trigger BEFORE UPDATE changes to NEW on a col not in the update statement don't go through

Hi All, I was pleasantly surprised to see that triggers can be created on FDW tables. I'm running into a problem. I create a trigger on an imported foreign table. In the procedure, I change the value of a column that is not in the triggering update statement. This change does not make it to