Bug #110747 alter table drops trigger from other sql nodes
Submitted: 20 Apr 9:31 Modified: 25 Apr 17:09
Reporter: Hendrik Woltersdorf Email Updates:
Status: Verified Impact on me:
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:8.0.32 OS:Any
Assigned to: CPU Architecture:Any

[20 Apr 9:31] Hendrik Woltersdorf
After doing an "alter table", to modify a columns datatype, a existing trigger on the table vanished from the _other_ sql node(s). On the sql node, where I issue the "alter table" the trigger is still there.

How to repeat:
see the attached file
[20 Apr 9:31] Hendrik Woltersdorf
test case

Attachment: test_alter_table_with_trigger.txt (text/plain), 2.11 KiB.

[25 Apr 17:09] MySQL Verification Team

Thanks for the report and test case. Verified as described.