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
Operations

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:
Duplicate
 
Relate
 

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
Pavel Cisar made changes - 17/Jan/07 01:57 PM
Field Original Value New Value
Attachment CRE_DB.SQL.txt [ 10230 ]
Pavel Cisar made changes - 18/Jan/07 09:41 AM
Summary Problem with BETWEEN predicate applied on select expression in view Support BETWEEN predicate for select expressions
Issue Type Bug [ 1 ] Improvement [ 4 ]
Pavel Cisar made changes - 28/Jan/08 01:23 PM
Workflow jira [ 11508 ] Firebird [ 15497 ]
Dmitry Yemanov made changes - 10/Apr/08 02:43 PM
Assignee Dmitry Yemanov [ dimitr ]
Dmitry Yemanov made changes - 13/May/08 10:34 AM
Link This issue is duplicated by CORE-1897 [ CORE-1897 ]
Dmitry Yemanov made changes - 26/May/08 11:20 PM
Link This issue is duplicated by CORE-1915 [ CORE-1915 ]
Dmitry Yemanov made changes - 05/Jan/17 07:27 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 4.0 Alpha 1 [ 10731 ]
Resolution Fixed [ 1 ]
Dmitry Yemanov made changes - 07/Jan/17 12:48 PM
Fix Version/s 3.0.2 [ 10785 ]
Pavel Zotov made changes - 19/Jan/17 05:54 AM
Status Resolved [ 5 ] Resolved [ 5 ]
QA Status Done successfully
Dmitry Yemanov made changes - 19/Jan/17 06:17 AM
Comment [ See my comment above re. NOT BETWEEN (dated 16-May-2008). ]
Dmitry Yemanov made changes - 21/Nov/17 12:22 PM
Link This issue relate to CORE-5596 [ CORE-5596 ]
Pavel Zotov made changes - 22/Nov/17 05:50 AM
Status Resolved [ 5 ] Resolved [ 5 ]
Test Details See also CORE-5596