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 operand/clause not supported for COMPUTED columns -- "feature is not supported" [CORE3530] #3887

Closed
firebird-automations opened this issue Jun 21, 2011 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Sean Leyne (seanleyne)

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.

Commits: 50d3041 191f700

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Does it happen with any expression inside a computed column, or with particular ones?

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Leyne (seanleyne)

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0.2 [ 10785 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

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

2 participants