It is not possible to 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.
It is possible to assign a new owner to a resource. When doing this, however, privileges granted to the current owner are not granted to the new owner.
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