Appendix B - SQL Limitations

Transaction Control

SQLstream does not implement the following transactional operations:

Operation Notes
COMMIT Not relevant for stream processing
ROLLBACK Not relevant for stream processing
SAVEPOINT Not relevant for stream processing
SET TRANSACTION Not relevant for stream processing
START TRANSACTION Not relevant for stream processing

Unimplemented the SQL standard data types

SQLstream does not implement the following the SQL standard data types:

Type Notes
Large object types BINARY LARGE OBJECT (BLOB), CHARACTER LARGE OBJECT (CLOB), NATIONAL CHARACTER LARGE OBJECT (NCLOB)
MULTISET NATIONAL CHARACTER LARGE OBJECT (NCLOB), NATIONAL CHARACTER VARYING (NCHAR VARYING)
Reference types Subtables, Supertables, Typed tables
Timezones TIME WITH TIMEZONE, TIMESTAMP WITH TIMEZONE
Year-month INTERVAL Day-time INTERVAL is supported
BIT BIT VARYING

Where SQLstream does not implement a data type, it also does not implement functions defined by the SQL standard that return a value of that type:

Type Unsupported functions
Timezones CURRENT_TIMECURRENT_TIMESTAMP

Additionally, SQLstream s-Server supports only the single-byte character sets supported by Java. SQLstream does not specifically implement the character repertoire names specified by ISO/IEC 9075, though in some cases equivalent functionality is provided under another name:

ISO/IEC 9075 character repertoire SQLstream alternative
GRAPHIC_IRV n/a
ISO8BIT n/a
LATIN1 ISO-8859-1
SQL_CHARACTER n/a
SQL_TEXT n/a
SQL-IDENTIFIER n/a
UTF8 n/a
UTF16 n/a
UTF32 n/a

Unimplemented the SQL standard functions and operators

SQLstream does not support the following the SQL standard functions and operators:

Function/Operator Type Keywords
Numeric functions CARDINALITY, OCTET_LENGTH, SQRT, WIDTH_BUCKET
Aggregate/Analytic functions ANY, COLLECT, COVAR_POP, COVAR_SAMP, CORR, CUME_DIST, DENSE_RANK, ELEMENT, EVERY, FUSION, INTERtopic, MEMBER OF, PERCENT_RANK, PERCENTILE_CONT, PERCENTILE_DISC, RANK, REGR_AVG, XREGR_AVGY, REGR_COUNT, REGR_INTERCEPT, REGR_R2, REGR_SLOPE, REGR_SXX, REGR_SYY, REGR_SXY, ROW_NUMBER, SOME,SUBMULTISET OF,UNNEST
String value functions CONVERT, TRANSLATE, NORMALIZE

Other unimplemented the SQL standard features

Feature Notes
Embedded SQL Includes:ADACCOBOLFORTRANMUMPSPASCALPL/I
Diagnostics GET DIAGNOSTICS