We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
Submitted by: @livius2
Duplicates CORE1095
BETWEEN on subquery result can not be used
example
select * from RDB$DATABASE R WHERE (SELECT COUNT(*) FROM RDB$DATABASE) BETWEEN 1 AND 5
- error Unsupported field type specified in BETWEEN predicate
The text was updated successfully, but these errors were encountered:
Commented by: Ain Valtin (ain)
Affects also latest versions (2.1) and is already reported as CORE1095
BTW engine accepts NOT BETWEEN with subquery!
Sorry, something went wrong.
Commented by: @livius2
I saw this post but i supposed that was only for View becaouse of that i write this post
BTW you wrote this work select * from RDB$DATABASE R WHERE (SELECT COUNT(*) FROM RDB$DATABASE) NOT BETWEEN 1 AND 5
but i do not understand why this also :) i know that - this is the same result but ...
select * from RDB$DATABASE R WHERE NOT ((SELECT COUNT(*) FROM RDB$DATABASE) BETWEEN 1 AND 5)
Link: This issue duplicates CORE1095 [ CORE1095 ]
Commented by: @dyemanov
Duplicates CORE1095.
status: Open [ 1 ] => Resolved [ 5 ]
resolution: Duplicate [ 3 ]
status: Resolved [ 5 ] => Closed [ 6 ]
QA Status: No test
No branches or pull requests
Submitted by: @livius2
Duplicates CORE1095
BETWEEN on subquery result can not be used
example
select
*
from
RDB$DATABASE R
WHERE
(SELECT COUNT(*) FROM RDB$DATABASE) BETWEEN 1 AND 5
- error Unsupported field type specified in BETWEEN predicate
The text was updated successfully, but these errors were encountered: