Expressions on LONGs

Derby permits expressions on LONG VARCHAR; however LONG VARCHAR data types are not allowed in:

• GROUP BY clauses
• ORDER BY clauses
• JOIN operations
• PRIMARY KEY constraints
• Foreign KEY constraints
• UNIQUE key constraints
• MIN aggregate function
• MAX aggregate function
• [NOT] IN predicate
• UNION operator

SQL99 also places some restrictions on expressions on LONG types.