-
Notifications
You must be signed in to change notification settings - Fork 1.2k
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
Semantically wrong query is executed by H2 when LIMIT 0 is used #3999
Comments
This is a side effect of partially implemented optional feature T301, “Functional dependencies” in combination with optimizations for Some applications execute additional queries with |
Thanks @katzyn, again I have learned something! |
With this schema:
The following query is semantically wrong, but executed nonetheless:
It produces an empty result set with column
A
. It should produce the same error as this query:I.e.:
The text was updated successfully, but these errors were encountered: