Transaction isolation
Derby Reference Manual
215
Feature
Source
Derby
predicates: OVERLAPS
SQL92T
Yes, with Java methods
Table 29.
Support for SQL-92 features: VARCHAR
Feature
Source
Derby
LENGTH
SQL92T
Yes
concatenation (||)
SQL92T
Yes
Table 30.
Support for SQL-92 features: Transaction isolation
Feature
Source
Derby
READ WRITE / READ ONLY
SQL92T
By using JDBC,
database properties, and
storage media
RU, RC, RR, SER
SQL92T
Yes
Table 31.
Support for SQL-92 features: Multiple schemas per user
Feature
Source
Derby
SCHEMATA view
SQL92T
SYS.SYSSCHEMAS
Table 32.
Support for SQL-92 features: Privilege tables
Feature
Source
Derby
TABLE_PRIVILEGES
SQL92T
No
COLUMNS_PRIVILEGES
SQL92T
No
USAGE_PRIVILEGES
SQL92T
No
Table 33.
Support for SQL-92 features: Table operations
Feature
Source
Derby
UNION relaxations
SQL92I
Yes
EXCEPT
SQL92I
Yes
INTERSECT
SQL92I
Yes
CORRESPONDING
SQL92I
No
Table 34.
Support for SQL-92 features: Schema definition statement
Feature
Source
Derby
CREATE SCHEMA
SQL92I
Partial support
Table 35.
Support for SQL-92 features: User authorization
