Issue Details (XML | Word | Printable)

Key: CORE-1897
Type: Bug Bug
Status: Closed Closed
Resolution: Duplicate
Priority: Major Major
Assignee: Unassigned
Reporter: Karol Bieniaszewski
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

BETWEEN on subquery result can not be used - error Unsupported field type specified in BETWEEN predicate

Created: 13/May/08 08:36 AM   Updated: 18/Oct/16 06:03 PM
Component/s: None
Affects Version/s: 1.5.5
Fix Version/s: None

Issue Links:
Duplicate
 

QA Status: No test


 Description  « Hide
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

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Ain Valtin added a comment - 13/May/08 09:55 AM
Affects also latest versions (2.1) and is already reported as http://tracker.firebirdsql.org/browse/CORE-1095

BTW engine accepts NOT BETWEEN with subquery!

Karol Bieniaszewski added a comment - 13/May/08 10:04 AM - edited
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)

Dmitry Yemanov added a comment - 13/May/08 10:34 AM
Duplicates CORE-1095.