• State Not Answered
  • Replies 10 replies
  • Subscribers 7 subscribers
  • Views 2715 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Comments not getting displayed while executing MySQL Script in Higher Environment

jaishankarj
I have a MySQL Query with my comments in it. I executed the same in higher environment and found that comments are not available and it shows blank space. Any thoughts why it is behaving like this. This happened with me for a stored procedure.

OriginalPostID-235935

  Discussion posts and replies are publicly visible

  • 0
    Certified Lead Developer
    How are you attempting to view those comments? Are you using SHOW CREATE PROCEDURE or trying to see them in a different way?
  • 0
    @philb: I have provided my comments in BEGIN - END block only in the Definition area of the stored procedure. Sample one is as follows:
    Begin

    /* =============================================*/
    /* Author: Jai Joshi */
    /* Date Created: 19/09/2016 */
    /* Description: */
    /* =============================================*/

    SELECT , from where = CONSTANT;
    END
  • 0
    Certified Lead Developer
    Ok - how are you attempting to view the comments after creation?
  • 0
    @philb: I clicked on the Stored Proc name and the window appears which is not showing me the comments
  • 0
    Certified Lead Developer
    In... phpMyAdmin? MySQL workbench? which software?
  • 0
    Certified Lead Developer
    It looks like this is a phpMyAdmin issue - see here: github.com/.../11717
  • 0
    @philb: Is there any alternate to retain the comments? Is there any support case raised for the same? In absence of seeing these comments we loose the audit of any changes which are being done to the MySQL object
  • 0
    Certified Lead Developer
    Not that I'm aware of, it's probably worth raising a support case. I'd also question the validity of using comments as an audit trail; you should be using a version control system to track such changes.

    • © 2024 Appian. All rights reserved.