Home > database >  The shrink space and the trigger
The shrink space and the trigger

Time:09-25

I am doing the shrink space, confirm the rowid part line changed, but the table triggers are not performed, that is why,
Official documentation mentioned the rowid - -based trigger is what meaning, for each row is based on the rowid trigger, network expert explain,

CodePudding user response:

For each row is not based on the rowid of trigger,

CodePudding user response:

The shrink the table or move the table, the data itself does not change, just the rowid change, all will not trigger the DML trigger,

CodePudding user response:

For each row is the change of the data, and the shrink space is row movement, storage location changes, the data did not change, so will not trigger a trigger you wrote
  • Related