Skip to content

Support Go MySQL Stored Procedure calls #569

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Closed
ykcadcg opened this issue Apr 19, 2017 · 7 comments
Closed

Support Go MySQL Stored Procedure calls #569

ykcadcg opened this issue Apr 19, 2017 · 7 comments

Comments

@ykcadcg
Copy link

ykcadcg commented Apr 19, 2017

Issue description

Tell us what should happen and what happens instead
Wanted to call my sproc in go, given error

Example code

call mysproc();

Error log

not supported```

### Configuration
*Driver version (or git SHA):*

*Go version:* run `go version` in your console
Go 1.8.1

*Server version:* E.g. MySQL 5.6, MariaDB 10.0.20
MySQL 6

*Server OS:* E.g. Debian 8.1 (Jessie), Windows 10
Windows/ Ubuntu
@pjebs
Copy link

pjebs commented Jun 14, 2017

@arnehormann With multi-read support now implemented, will calling stored procedures now work?

@arnehormann
Copy link
Member

@pjebs honestly, I don't know. I'm a little behind right now and running low on time for open source. I hope that will change soon, but as it is now, it already frustrates me that I can't even finish #302 - which is a priority for me in the driver.
You can always just try it - the pieces should be there 😉

@andizzle
Copy link

andizzle commented Jul 3, 2017

just FYI this is working now.

@ericleb010
Copy link

Is it working? Whenever I call an otherwise-working stored procedure, no error is returned, yet the operation was not completed and a lock was left on the database (preventing me from calling this procedure manually).

@andizzle
Copy link

Is it possible that you have not set autocommit to true?

@ericleb010
Copy link

Looks like that was the case... good call.

@pjebs
Copy link

pjebs commented Sep 5, 2017

@pjebs pjebs mentioned this issue Sep 5, 2017
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

6 participants