JRS Limitations
The current version of JRS
- supports a large subset of SQL-92 that can only be used interactively;
- supports only INTEGER, VARCHAR, and
BOOLEAN data types;
- supports index-only access plans;
- does not support scalar functions;
- does not support the LIKE operator on strings;
- does not support a report writer;
- does not support passwords for user and granting privileges;
- does not support integrity rules except keys and foreign keys;
- does not support outer joins types;
- does not transform a nested query into an equivalent one without nesting to find a better evaluation strategy, and it does not recognize nested subqueries that can be evaluated just once instead of multiple times;
- does not transform a query that accesses a
view into an equivalent query that accesses the view's base tables;
- does not support triggers;
- does not supports transactions.
Index Page