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

Invalid Sql When Altering Trigger

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Invalid Sql When Altering Trigger

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • October 10, 2006 at 7:25 pm #9959
      Scott Wagner
      Member

      When you right-click on a trigger and choose the option to alter the trigger, the SQL that is generated is not executable without first editing the text.

      The SQL that is generated looks like:

      create trigger `` BEFORE INSERT on `

      `

      for each rowBEGIN

      Because there is no space between the row and BEGIN words, attempting to execute the generated statement to rebuild the trigger results in an error when inserting the new trigger, but only after successfully dropping the existing trigger.

    • October 11, 2006 at 7:01 am #22772
      Manoj
      Member

      Hello,

      This is a known issue with MySQL 5.1.x servers(There is no issue with 5.0.x servers), and it is already fixed in the latest beta(5.2 Beta 5).

      Manoj

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