Bug #110747 alter table drops trigger from other sql nodes

• Submitted: 20 Apr 2023 9:31
• Modified: 25 Apr 2023 17:09
• Reporter: Hendrik Woltersdorf
• Status: Verified
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S3 (Non-critical)
• Version: 8.0.32
• OS: Any
• CPU Architecture: Any

[20 Apr 2023 9:31] Hendrik Woltersdorf

Description:
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 2023 9:31] Hendrik Woltersdorf

test case

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

[25 Apr 2023 17:09] MySQL Verification Team

Hi,

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