WITH Limitations

Following are important limitations to observe in constructing WITH clauses. Also see DQL Mode Nesting Limitations.

Two columns or keys that are not the same type cannot be compared.
Columns that are greater than 240 characters in length cannot be used in a WITH clause or in a SET statement in an INSERT or UPDATE query.
The maximum number of literal values per WITH statement is 15.
Columns used in a WITH clause as part of an arithmetic expression cannot be qualified.
The maximum number of OR entries in a WITH statement is 15. (That is, a maximum of 14 ORs are allowed.)
Values following an EQ (=) or NE (,=) cannot be separated by AND or OR.
SQL DATE, TIME and TIMESTAMP cannot be used with DQL SET, SORT and WITH.
A numeric column whose value can be zero should not be used as a divisor in a SET statement or an arithmetic expression.
The maximum numeric precision is 18 digits.
An arithmetic expression cannot have more than five levels of nested parentheses.