Issue Details (XML | Word | Printable)

Key: CORE-3530
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Sean Leyne
Votes: 0
Watchers: 1
Operations

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

BETWEEN operand/clause not supported for COMPUTED columns -- "feature is not supported"

Created: 20/Jun/11 09:51 PM   Updated: 19/Jan/17 06:11 AM
Component/s: Engine
Affects Version/s: 2.1.4
Fix Version/s: 3.0.2, 4.0 Alpha 1

QA Status: Done successfully


 Description  « Hide
Using BETWEEN operand/clause against a COMPUTED column in a SELECT statement results in the engine reporting "feature is not supported".

Yet, other comparisons work with COMPUTED columns without issue.

For example:
  A_Computed_Column > 1, or
  A_Computed_Column => 1, or
  A_Computed_Column < 12, or
  A_Computed_Column <= 12, or
  A_Computed_Column LIKE '1%', or
  A_Computed_Column STARTING WITH '1', or
  A_Computed_Column ENDING WITH '1', or
  A_Computed_Column CONTAINING '1'
are valid and executed by the engine.

But
  A_Computed_Column BETWEEN 1 AND 12
is rejected.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 21/Jun/11 03:53 AM
Does it happen with any expression inside a computed column, or with particular ones?

Sean Leyne added a comment - 21/Jun/11 07:19 AM
The column which is raising the error is defined as:

    ASS_TOTALPLAYSAVAIL_CM COMPUTED BY (coalesce( (select sum(case when (arw_daysavailable = -1) then 999 else (coalesce( arw_daysavailable, 0) - coalesce( arw_daysused, 0)) end) from assetrightwindow where arw_ass_id = ass_id), 0)),

with the related AssetRightWindow columns defined as:

    ARW_DAYSAVAILABLE INTEGER,
    ARW_DAYSUSED INTEGER