Error calling PROCEDURE in SQL Fiddle

Question

When making a call PROCEDURE in SQL Fiddle, the following error is displayed:

DDL and DML statements are not allowed in the query panel for Mysql; only SELECT statements are allowed. Put DDL and DML in the schema panel.

In the schema construction tab, I use the following query:

CREATE TABLE TEST( COD NUMERIC PRIMARY KEY UNIQUE,
                     DATESTART DATETIME,
                     DATEEND DATETIME);

  INSERT INTO TEST
  VALUES (1, '2019-03-29 10:20:57', '2019-04-29 10:20:57');

  CREATE PROCEDURE PROC_TEST()
  BEGIN
    SELECT * FROM TEST;
  END//

In the SQL execution tab:

CALL PROC_TEST()

Follows the fiddle used in the creation and call of PROCEDURE.

Answer 1

SQL Fiddle, maybe for security, won’t let you run the Procedure call in the execution tab.

the message is exactly this; DDL and DML statements are not allowed in the query panel for Mysql; only SELECT statements are allowed. Put DDL and DML in the schema panel.

Translating DDL and DML instructions are not allowed in the Mysql query panel; only SELECT instructions are allowed. Place DDL and DML in the schematic panel.

Answer 2

André, this looks like a SQL Fiddle BUG in Mysql 5.6.

Another thread has already been answered with this in english. I asked the konerak to take a look at the Issue 5 on Github and the thread in english.

I noticed you’re using the delimiter char as // , but the code uses ; , keep everyone using // example: http://sqlfiddle.com/#! 9/e63b9c/2/0.

However to enrich the discussion and continue the idea of Bruno, the commands sequintes could be used for you to better understand your environment:

Display current user permissions:

SHOW GRANTS FOR CURRENT_USER()//

Reference materials:

https://dev.mysql.com/doc/refman/5.6/en/grant.html

https://dev.mysql.com/doc/refman/5.6/en/privileges-provided.html#priv_execute

As a suggestion to test your code and know if Sqlfiddle is interpreting your commands use a select before and after:

select * from TEST//
call PROC_TEST()//
select * from TEST//

Example: http://sqlfiddle.com/#! 9/e63b9c/2/0

As next steps I suggest that you create a Mysql database on a Docker and test locally because in this case Sqlfiddle is not meeting what it promises. Add how it is a project on Github open an Issue for the project. As I did for you here: https://github.com/zzzprojects/sqlfiddle3/issues/5