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.

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

mysql connection pool call select * query specific column value throw column not found exception #100

Closed
lzbjut opened this issue Jun 16, 2022 · 2 comments
Assignees
Labels
app:pisa-proxy Pisa-Proxy related changes in:protocol Protocol related changes type:bug Misbehavior
Milestone

Comments

@lzbjut
Copy link

lzbjut commented Jun 16, 2022

Bug Report

java.sql.SQLException: Column 'order_code' not found.

What version of Pisanix are you using?

0.1.0

What operating system and CPU are you using?

Linux,Kubernetes1.19.4

Steps to reproduce

using multiple thread to trigger the query method
using hikari 3.3.0 to init conn pool and execute select *
using preparedStatement and call getString method on a specific column

What did you expect?

return the value of the specific column

What did happened?

java.sql.SQLException: Column 'order_code' not found.

@xuanyuan300 xuanyuan300 added type:bug Misbehavior app:pisa-proxy Pisa-Proxy related changes in:deploy Deployment related changes in:protocol Protocol related changes labels Jun 17, 2022
@xuanyuan300
Copy link
Contributor

Currently, pisa-proxy will transparently transmit sql statements to the backend database, could you please provide us with captured packet using tcpdump.

@xuanyuan300 xuanyuan300 removed the in:deploy Deployment related changes label Jun 17, 2022
@xuanyuan300 xuanyuan300 self-assigned this Jun 17, 2022
@mlycore mlycore added this to the v0.1.1 milestone Jun 17, 2022
@wbtlb
Copy link
Contributor

wbtlb commented Jun 30, 2022

fix in #73

@wbtlb wbtlb closed this as completed Jun 30, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
app:pisa-proxy Pisa-Proxy related changes in:protocol Protocol related changes type:bug Misbehavior
Projects
None yet
Development

Successfully merging a pull request may close this issue.

4 participants