[feature] Support for Stored Procedure Execution

[jchrys]

Is your feature request related to a problem? Please describe. Currently, there is no support for executing stored procedures in our application, which limits our ability to interact with databases efficiently.

Describe the solution you'd like

• Implement related specs.

Additional context

• io.r2dbc.spi.OutParameters
• https://stackoverflow.com/questions/77606420/spring-data-r2dbc-mysql-stored-procedure-execution

[mirromutth]

It is already supported, but MySqlResult emit wrong type, see also my answer.

It should be OutSegment instead of RowSegment, it can be checked by ServerStatus.PS_OUT_PARAMETERS. Unfortunately, if we set Capability.DEPRECATE_EOF on initialization, it seems that ServerStatus.PS_OUT_PARAMETERS is not returned until after the row packet has ended.

So there we should do 3 things:

• Unset Capability.DEPRECATE_EOF on initialization
• Check ConnectionContext.getServerStatuses() for each row packet, if ServerStatus.PS_OUT_PARAMETERS is set, the current row packet should be converted to OutSegment instead of RowSegment
• Add wiki for Stored Procedure