locked
Bug in SSMA for MySql RRS feed

  • Question

  • Following storedprocedure during first phase generates no concerns, but at the time of synchronizing to SQL fails to create the routine because of syntax error

    SET `Column1` =

    during the first phase is converted to the exact same phrase whiteout apostrophes being removed from the statement.

    CREATE DEFINER=`root`@`localhost` PROCEDURE `Test`(IN `In_Row_No` INT)
    BEGIN
    Declare V_Test_No Int Default 0;
    UPDATE TestTable SET `Column1` = Column1*(-1) WHERE Row_No = In_Row_No;    
    END

    Wednesday, July 26, 2017 7:21 PM

All replies

  •  

    Hi mikebroojeni,

     

    Which version of SSMA for MySQL did you use? We tested it with SSMA 7.4 and did not meet a similar problem. Besides, where do you get this problem, could you please share a screenshot to us? Then we can report it to the product team.

     

    Best Regards,

    Teige

     



    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, July 27, 2017 6:01 AM