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

Alter View Invalid Syntax Generated

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Alter View Invalid Syntax Generated

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • January 20, 2016 at 2:36 pm #13480
      Mitch
      Participant

      In some cases, the SQL generated by Alter View is incorrect. 

       

      The generated SQL is

      ALTER ALGORITHM=TEMPTABLE DEFINER=user@% SQL SECURITY DEFINER VIEW `vwOrderdetail` AS (…

       

      but should be

      ALTER ALGORITHM=TEMPTABLE DEFINER=user@`%` SQL SECURITY DEFINER VIEW `vwOrderdetail` AS (…

       

      It is missing the quotes around the %

    • January 20, 2016 at 2:46 pm #35629
      peterlaursen
      Participant

      This could be a server issue (ie. server returning the user@host -strng unquoted).

       

      What is the server version? Can you provide a simple example where it happes and one where it does not? 

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