I try to run a sql-file with phpstorm (could be done with any other JB-IDE) that contains functions and views. While the views are droped and created without any problems, the functions won't run. I tried a number of things so far. The point is, that the IDE seems to ignore the DELIMITER-statement. So before I start a new bug-report, it would be nice to know, if anyone had this problem before and was able to solve it. Here is an simplified example code:
CREATE DEFINER=root@localhost FUNCTION testfunc(arg_a INT, arg_b INT) RETURNS int(11)
SQL SECURITY INVOKER
RETURN a + b;
DBMS is MySQL. I tried `//`, `|` and `?` as a delimiter...