You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/06/09 07:15:27 UTC
[GitHub] [shardingsphere] sswanv opened a new issue, #18259: Mysql stored procedure call with parameters
sswanv opened a new issue, #18259:
URL: https://github.com/apache/shardingsphere/issues/18259
- product used: **shardingsphere-proxy:5.1.1**
- go version: **go1.18 darwin/amd64**
- sql:
```sql
DELIMITER //
CREATE PROCEDURE TransferInviteUser (IN source_user_id bigint, IN target_user_id bigint)
BEGIN
# ...
end //
DELIMITER ;
```
- code segment:
```golang
result, err := db.Exec("CALL TransferInviteUser(?, ?)", sourceUserId, targetUserId)
if err != nil {
// sql: expected 0 arguments, got 2
panic(err)
}
```
> The **num_params** received in the **COM_STMT_PREPARE** Response packet do not match the actual input parameters.
https://dev.mysql.com/doc/internals/en/com-stmt-prepare-response.html
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu commented on issue #18259: Mysql stored procedure call with parameters
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #18259:
URL: https://github.com/apache/shardingsphere/issues/18259#issuecomment-1159476738
Sorry, no plan to support store procedure
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] terrymanu closed issue #18259: Mysql stored procedure call with parameters
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #18259: Mysql stored procedure call with parameters
URL: https://github.com/apache/shardingsphere/issues/18259
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org