Stored Procedure Source Editor: Procedure Characteristics Missing
Answered
After creating a stored procedure like
CREATE PROCEDURE PROC() DETERMINISTIC MODIFIES SQL DATA
BEGIN ... END
and then using the source editor you only get
CREATE PROCEDURE PROC()
BEGIN ... END
with the characteristics of the procedure missing.
So if you update/copy your procedure using the editor it will lose its characteristics, which is mostly annoying, but may have a consequences if i.e. binary logging is enabled ([NOT] DETERMINISTIC is important in this case).
Since I do not know if this is an upstream error or DataGrip internal, I will simply mention this here.
Please sign in to leave a comment.
Please, tell us the database
Sorry, this problem occurs (at least) on MySQL v5.6.40 and v5.7.12.
Btw, the JDBC driver version is 8.0.15
Is this issue resolved?
Not yet, Xavi https://youtrack.jetbrains.com/issue/DBE-10744