Re: problems upgrading 5.7 -> 8.0.15

[Hans Meiser]

Hello,

i recreated db to be able to run show create procedure . This is my output:


*************************** 1. row ***************************
Procedure: procedurename
sql_mode: MYSQL40,HIGH_NOT_PRECEDENCE
Create Procedure: CREATE DEFINER=`myuser`@`%` PROCEDURE `procedurename`(current_fall_back VARCHAR(64))
BEGIN
WHILE current_fall_back != 'root' DO
SELECT capabilities FROM jos_TeraWurflMerge WHERE deviceID = current_fall_back;
SELECT fall_back FROM jos_TeraWurflMerge WHERE deviceID = current_fall_back INTO current_fall_back;
END WHILE;
END
character_set_client: utf8
collation_connection: utf8_general_ci
Database Collation: utf8_general_ci
1 row in set (0.00 sec)

I used db.table just to anonymize this data, i changed nothing in mysql.
Where can i see if parameter is an IN or OUT or both? I find nothing fitting in systemtables.

Thanks,
Hans