Open topic with navigation

TIBCO ActiveSpaces® - Enterprise Edition 5.0.0

# Case Expression Restrictions

In addition to the restrictions on value expressions listed on Restrictions on Using a Value Expression, the use of a CASE expression in a select list has the following additional restrictions:

- CASE expressions cannot contain functions that use the DISTINCT keyword.
- All resulting values of the CASE expression must be of the same data type. The resulting data types are not evaluated until the query is run. Therefore, it is possible that a bad SELECT statement can be created, which later causes an exception to be returned after running the query.
- CASE expressions that contain subexpressions are parsed, but do not return an error.

Additionally, an internal limit is applied to nested CASE expressions to prevent the exhaustion of resources. This limit is different from the expression depth limit and can vary based on the composition of the query. The limit is applied during the parsing of the nested CASE expression. When the limit is reached, the following error is returned:

    Error Code  = Resource limit reached
    Description = SQL parser stack overflow

Did you find this helpful?

Yes No
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO ActiveSpaces® - Enterprise Edition

Copyright © 2009-2025. Cloud Software Group, Inc. All Rights Reserved.