Crash when pasting text
CREATE DEFINER = 'camskpn'@'%'
PROCEDURE cams_kpn.proctest(operation int, PID int, CID int, DID int, UID int, ct varchar(50), CLID int)
BEGIN
/*
operations - Properties
1 = Contract Select - PID ProjectID
2 = Doc List - CID ContractID
3 = Linked Documents - DID DocID
4 = Ball in Court - DID DocID
5 = Change Issues - DID DocID
6 = Change Sources - DID DocID
7 = Change Items - DID DocID
8 = Filters - UID UserID
9 = DocumentDetail - DID DocID
10 = DocTypes
11 = Stati
12 = Change Categories
13 = Approval Type
14 = Funding Source - CID ContractID, CT ChangeType
15 = Change Proposals
16 = Final Change Proposal
17 = Other Documents
18 = CA_Source
*/
END
Create a proc with the following body, now copy the row marked as number 5 in the comment, and paste this below the comment section as though this were actually being used in the proc, the memory usage skyrockets and the app pretty much dies, losing anything done previously.
I have this quite often, but this simple proc will show the problem, hopefully your devs can fix this, as the memory leak comes up quite often.
This issue is fixed in version 7.2 https://www.devart.com/dbforge/mysql/studio/download.html