Appendix C - Limitations and Unimplemented SQL:2008 functionality

<< Click to Display Table of Contents >>

Navigation:  Streaming SQL Reference Guide >

Appendix C - Limitations and Unimplemented SQL:2008 functionality

Previous pageReturn to chapter overviewNext page

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

Security and authorization

SQLstream does not implement users, roles, or privileges:

Feature

Notes

Roles

CREATE ROLE

DROP ROLE

Privileges

GRANT

REVOKE

Users

CURRENT_USER

SESSION_USER

USER

Unimplemented SQL:2008 data types

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

Type

Notes

Large object types

BINARY LARGE OBJECT (BLOB)

CHARACTER LARGE OBJECT (CLOB)

NATIONAL CHARACTER LARGE OBJECT (NCLOB)

Collection types

ARRAY

MULTISET

National character types

NATIONAL CHARACTER (NCHAR)

NATIONAL CHARACTER LARGE OBJECT (NCLOB)

NATIONAL CHARACTER VARYING (NCHAR VARYING)

Numeric data types

FLOAT

Reference types

Subtables

Supertables

Typed tables

Row types

 

Timezones

TIME WITH TIMEZONE

TIMESTAMP WITH TIMEZONE

User-defined types

 

Year-month INTERVAL

Day-time INTERVAL is supported

Other types eliminated by SQL:2008

Includes:

BIT

BIT VARYING

 

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

Type

Unsupported functions

Timezones

CURRENT_TIME

CURRENT_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 SQL:2008 functions and operators

SQLstream does not support the following SQL:2008 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_AVGX

REGR_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 SQL:2008 features

Feature

Notes

Embedded SQL

Includes:

ADA

C

COBOL

FORTRAN

MUMPS

PASCAL

PL/I

Diagnostics

GET DIAGNOSTICS