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

BETWEEN on subquery result can not be used - error Unsupported field type specified in BETWEEN predicate [CORE1897] #2329

Closed
firebird-automations opened this issue May 13, 2008 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

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

@firebird-automations
Copy link
Collaborator Author

Commented by: Ain Valtin (ain)

Affects also latest versions (2.1) and is already reported as CORE1095

BTW engine accepts NOT BETWEEN with subquery!

@firebird-automations
Copy link
Collaborator Author

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)

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue duplicates CORE1095 [ CORE1095 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Duplicates CORE1095.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

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