Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Alter Trigger

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Alter Trigger

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • March 25, 2013 at 11:00 am #12958
      Ymhr
      Member

      In the generated “Alter Trigger” statement, there is Drop + Create Trigger.

      This is a MySql limitation, but in a heavy loaded environment, this could cause a data inconsistency.

      The table involved in the trigger should be locked before the drop trigger.

    • March 26, 2013 at 6:16 am #34263
      sathish
      Member

      This would require parsing in order to find out the table name(s). We generally do not parse statements to retrieve data as the syntax could change with server versions. Also this is a very rare case (till now we have had no such reports). If more users have the same or similar requests then we will look into it again at that time.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.