Known SQL Limitations

• You cannot create a UNIQUE secondary index on a table.

• The expression (DISTINCT column) is not allowed in an aggregate expression, unless this is the only selected expression.

• All tables must be created with a primary key specification. That is, tables without primary keys are not supported.

• FULL OUTER JOIN is not supported.

• IN subqueries that are table subqueries are not supported, for example:

  SELECT SNAME FROM S WHERE (S1#,S2#) IN (SELECT S1#,S2# FROM SP WHERE P#='P2')

• Constraints other than NOT NULL and PRIMARY KEY are not supported.

• You can assign a new owner to a resource. When making this change, however, privileges granted to the current owner are not granted to the new owner.

• Queries with two or more nested NOT EXISTS subqueries where each subquery is not directly correlated to outer level of queries is not supported.

• Column privileges are not supported.

• Row value constructors are allowed only in a VALUES clause.

• Subqueries are not accepted as value expressions in row value constructors.

• The following data types cannot be used when creating primary keys:

  • REAL

  • FLOAT

  • DOUBLE PRECISION

  • DECIMAL

  • NUMERIC