Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Update 2 Release Notes

- Previous: Upgrading the High Availability Database
- Next: High Availability Load Balancing

## Known SQL Limitations

- 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`

- Previous: Upgrading the High Availability Database
- Next: High Availability Load Balancing

- © 2010, Oracle Corporation and/or its affiliates