Skip to content
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.

Sign up for GitHub

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

Jump to bottom

Return last_insert_id() as integer #1092

Closed
renecannao opened this issue Jul 13, 2017 · 1 comment
Closed

Return last_insert_id() as integer #1092

renecannao opened this issue Jul 13, 2017 · 1 comment
Assignees
@renecannao
Milestone
1.3.9

Comments

@renecannao
Copy link
Contributor

Currently ProxySQL returns the value of SELECT LAST_INSERT_ID() as string MYSQL_TYPE_VAR_STRING , while should be time MYSQL_TYPE_LONGLONG .

That is ok for a lot of client libraries, but some client libraries do not like that.
Also, default charset should be binary
renecannao added a commit that referenced this issue Jul 14, 2017
@renecannao
Bug fixes related to LAST_INSERT_ID()
56eff07 
* 64 bits LAST_INSERT_ID() #1090
* return LAST_INSERT_ID() as type LONGLONG #1092
* set charset as `binary` #1092
renecannao added a commit that referenced this issue Jul 14, 2017
@renecannao
Bug fixes related to LAST_INSERT_ID()
5389f44 
* 64 bits LAST_INSERT_ID() #1090
* return LAST_INSERT_ID() as type LONGLONG #1092
* set charset as `binary` #1092
@renecannao renecannao self-assigned this Jul 19, 2017
@renecannao renecannao added this to the 1.3.9 milestone Jul 19, 2017
@renecannao
Copy link
Contributor Author

Fixed in 1.3.9 and 1.4.1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@renecannao renecannao

Labels
None yet
Projects
None yet
Milestone
1.3.9
Development

No branches or pull requests
1 participant
@renecannao