The
current version of JRS
- supports a large subset of SQL92 that can
only be used interactively;
- supports only INTEGER, VARCHAR, and
BOOLEAN data types;
- does not support scalar functions;
- does not support the LIKE operator on
strings;
- does not support an ALTER operator to
change the structure of a table;
- 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 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;
- supports index-only access plans;
- supports transactions.
Index Page