When I upgraded from MySQL Client 8.0.20 to 8.0.21 in a .net-core 3.1 application, I get this strange error when trying to call a stored procedure in AWS Aurora.
MySql.Data.MySqlClient.MySqlException (0x80004005): same name are not supported.
at MySql.Data.MySqlClient.ProcedureCache.GetProcData(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.AddNew(MySqlConnection connection, String spName)
at MySql.Data.MySqlClient.ProcedureCache.GetProcedure(MySqlConnection conn, String spName, String cacheKey)
at MySql.Data.MySqlClient.StoredProcedure.CheckParameters(String spName)
at MySql.Data.MySqlClient.StoredProcedure.Resolve(Boolean preparing)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
In 8.0.20 (and several previous versions), it worked without any complaint. I can find nothing on the InterTubes about this error.
Procedure (very simple search proc):
CREATE DEFINER=`cdapoe`@`%` PROCEDURE `find_oeauthorizationassigned`(
IN p_username VARCHAR(120),
IN p_active_utc DATETIME
)
READS SQL DATA
select * from oeauthorization.oeauthorizationassigned
where username=p_username and (p_active_utc < expiration_utc or expiration_utc is null)
Downgrading from MySQL Client 8.0.21 to 8.0.20 is a known-good workaround.
The bug has been reported to and acknowledged by Oracle.
Oracle has released MySQL Client 8.0.22 which appears to have fixed the problem. The release notes don't mention my bug report - but there is another similar sounding bug. So maybe it was fixed incidentally.
MySQL has closed my bug report and claims it was fixed in 8.0.22. I'm currently on 8.0.23 and it seems fine.
User contributions licensed under CC BY-SA 3.0