
17 Nov
2019
17 Nov
'19
8:54 p.m.
Hi When editing a trigger (and probably also stored procedures), when writing something like SET ctype=REGEXP_REPLACE(REGEXP_REPLACE(ctype,'^enum\\(',''),'\\)$',''); And saving it, it will show as SET ctype=REGEXP_REPLACE(REGEXP_REPLACE(ctype,'^enum\(',''),'\)$',''); when reopening it. When saving that and reopening it, it will show as SET ctype=REGEXP_REPLACE(REGEXP_REPLACE(ctype,'^enum(',''),')$',''); Those backslash character seem to be incorrectly handled. Thanks for fixing. I honestly wonder why nobody found this over all those years. Regards -- Frederic Steinfels F. Steinfels Hard- & Software Seestrasse 110b 8610 Uster 043 544 08 08