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

Parameter values in INSERT #61

Open
danicc097 opened this issue Nov 10, 2022 · 0 comments
Open

Parameter values in INSERT #61

danicc097 opened this issue Nov 10, 2022 · 0 comments

Comments

@danicc097
Copy link
Contributor

Is your enhancement related to a problem? Please describe.

Currently, statement parameters are replaced with null. This is fine for most statements as far as I can tell but will cause issues in INSERTs when inserting into a non-nullable column.

Posting this here in case you have some ideas on the feasibility of either:

  • Sending a (not null) parameter array in syntax analysis based on the type
  • Analyzing without passing any parameter value (pgClient.query(fileText) with parameters errors out)

For now I'm simply ignoring inserts altogether so it's not that big an issue:

image

Describe the solution you would like

Describe alternatives you have considered

Additional context

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

1 participant