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

support intersection -vs- union definitions of input variable types #50

Open
uladkasach opened this issue Dec 14, 2021 · 0 comments
Open

Comments

@uladkasach
Copy link
Member

this one is a more intensive and likely less useful feature, but technically the type of an input variable can be definied as a union (e.g., :token = x OR :token = y) or an intersection (e.g., :token = x AND :token = y)

we should support both explicitly

currently, as of #49, we only support unions

but supporting intersections will allow this tool to pre-emptively warn users that the query that they have defined can not be satisfied:

  • e.g., a value can not be both a string and a number at the same time

note: this is probably not as relevant in mysql, where mysql will actually typecast for you - but is relevant in postgres for sure.

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