Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
10 replies
Subscribers
8 subscribers
Views
2890 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Comments not getting displayed while executing MySQL Script in Higher Environment
jaishankarj
over 7 years ago
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
PhilB
A Score Level 1
over 7 years ago
How are you attempting to view those comments? Are you using SHOW CREATE PROCEDURE or trying to see them in a different way?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
A Score Level 1
over 7 years ago
...because this may answer your question:
stackoverflow.com/.../how-to-comment-sp-mysql
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
jaishankarj
over 7 years ago
@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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
A Score Level 1
over 7 years ago
Ok - how are you attempting to view the comments after creation?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
jaishankarj
over 7 years ago
@philb: I clicked on the Stored Proc name and the window appears which is not showing me the comments
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
A Score Level 1
over 7 years ago
In... phpMyAdmin? MySQL workbench? which software?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
jaishankarj
over 7 years ago
@philb: In phpMyAdmin, version information 4.6.4
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
A Score Level 1
over 7 years ago
It looks like this is a phpMyAdmin issue - see here:
github.com/.../11717
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
jaishankarj
over 7 years ago
@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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
A Score Level 1
over 7 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel