Issue Details (XML | Word | Printable)

Key: CORE-1095
Type: Improvement Improvement
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Pavel Cisar
Votes: 5
Watchers: 3

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

Support BETWEEN predicate for select expressions

Created: 17/Jan/07 01:56 PM   Updated: 22/Nov/17 05:50 AM
Component/s: Engine
Affects Version/s: 1.5.2, 1.5.3, 2.0.0
Fix Version/s: 3.0.2, 4.0 Alpha 1

File Attachments: 1. Text File CRE_DB.SQL.txt (3 kB)

Environment: confirmed on Windows, but it should be platform independent.
Issue Links:

QA Status: Done successfully
Test Details: See also CORE-5596

 Description  « Hide
View that uses select expressions from selectable stored procedure fails to execute with error:
Unsuccessful execution caused by an unavailable resource.
Unsupported field type specified in BETWEEN predicate.

for select from view that uses BETWEEN predicate applied to select expression. See attached script for reproducible test case.
It executes correctly when equivalent construct X >= val1 and X <= val2 is used.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.