You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
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
The text was updated successfully, but these errors were encountered: