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-issue-importer opened this issue Jun 21, 2011 · 7 comments

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 21, 2011

Commented by: @dyemanov

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

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 21, 2011

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-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 5, 2017

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 5, 2017

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 7, 2017

Modified by: @dyemanov

Fix Version: 3.0.2 [ 10785 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 19, 2017

Modified by: @pavel-zotov

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

QA Status: Done successfully

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jan 19, 2017

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