TT-02973
Invalid relational operator: subquery does not project same number of columns as specified in the left operand
Cause
You attempted an operation where the relational operator ANY or IN is specified with a subquery that returns a different number of values than the specified in the left operand. For example:
SELECT * FROM t1 WHERE (a,b)
IN (SELECT c FROM t2);
In this example, the group of values returned in the IN list contains one less entry than that the number specified in the left operand.
Action
Add the missing value or values to the SQL statement and retry the operation. For more information on SQL statements, see SQL Statements in Oracle TimesTen In-Memory Database SQL Reference.
Additional Information
TimesTen cannot perform the operation.