CREATE PROCEDURE p () WITH cte AS ( SELECT 1 ) SELECT * FROM cte;

CALL p();

mysqltest: At line 2: query 'CALL p()' failed: 1457: Failed to load routine test.p. The table mysql.proc is missing, corrupt, or contains bad data (internal code -6)

select * from mysql.proc where name = 'p';

db	test

name	p

type	PROCEDURE

specific_name	p

language	SQL

sql_data_access	CONTAINS_SQL

is_deterministic	NO

security_type	DEFINER

param_list	

returns	

body	cte AS ( SELECT 1 ) SELECT * FROM cte

definer	root@localhost

created	2019-08-23 02:50:38

modified	2019-08-23 02:50:38

sql_mode	STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

comment	

character_set_client	latin1

collation_connection	latin1_swedish_ci

db_collation	latin1_swedish_ci

body_utf8	cte AS ( SELECT 1 ) SELECT * FROM cte