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

Prepare statement with parameters types #700

Closed
vietj opened this issue Jun 30, 2020 · 0 comments
Closed

Prepare statement with parameters types #700

vietj opened this issue Jun 30, 2020 · 0 comments
Assignees
Milestone

Comments

@vietj
Copy link
Member

vietj commented Jun 30, 2020

The creation of prepared statements requires in some cases to provide the type of parameters, e.g PostgreSQL can optionally use them and provide an adequate binding (like the query SELECT CONCAT("hello ", $1)) otherwise it would fail.

We should prepare statements without types and upon specific failures (e.g 42P18 INDETERMINATE DATATYPE) retry with the types.

The preparation/execution flow should be reworked to do this. This affects prepared queries and one shot queries.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant