Stored Procedure Source Editor: Procedure Characteristics Missing

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.

2 comments

Sorry, this problem occurs (at least) on MySQL v5.6.40 and v5.7.12.

Btw, the JDBC driver version is 8.0.15

0

Please sign in to leave a comment.