Overview of Core SQL:2003 Features

Feature ID

Feature description

NexusDB

E011

Numeric data types

E011-01

INTEGER and SMALLINT data types (including all spellings)

ü

E011-02

REAL, DOUBLE PRECISION, and FLOAT data types

ü

E011-03

DECIMAL and NUMERIC data types

ü

E011-04

Arithmetic operators

ü

E011-05

Numeric comparison

ü

E011-06

Implicit casting among the numeric data types

ü

E021

Character string types

E021-01

CHARACTER data type (including all its spellings)

ü

E021-02

CHARACTER VARYING data type (including all its spellings)

ü

E021-03

Character literals

ü

E021-04

CHARACTER_LENGTH function

ü

E021-05

OCTET_LENGTH function

ü

E021-06

SUBSTRING function

ü

E021-07

Character concatenation

ü

E021-08

UPPER and LOWER functions

ü

E021-09

TRIM function

ü

E021-10

Implicit casting among the fixed and variable length character string types

ü

E021-11

POSITION function

ü

E021-12

Character comparison

ü

E031

Identifiers

E031-01

Delimited identifiers

ü

E031-02

Lower case identifiers

ü

E031-03

Trailing underscore

ü

E051

Basic query specification

E051-01

SELECT DISTINCT

ü

E051-02

GROUP BY clause

ü

E051-04

GROUP BY can contain columns not in <select list>

ü

E051-05

Select list items can be renamed

ü

E051-06

HAVING clause

ü

E051-07

Qualified * in select list

ü

E051-08

Correlation names in the FROM clause

ü

E051-09

Rename columns in the FROM clause

ü

E061

Basic predicates and search conditions

E061-01

Comparison predicate

ü

E061-02

BETWEEN predicate

ü

E061-03

IN predicate with list of values

ü

E061-04

LIKE predicate

ü

E061-05

LIKE predicate: ESCAPE clause

ü

E061-06

NULL predicate

ü

E061-07

Quantified comparison predicate

ü

E061-08

EXISTS predicate

ü

E061-09

Subqueries in comparison predicate

ü

E061-11

Subqueries in IN predicate

ü

E061-12

Subqueries in quantified comparison predicate

ü

E061-13

Correlated subqueries

ü

E061-14

Search condition

ü

E071

Basic query expressions

E071-01

UNION DISTINCT table operator

ü

E071-02

UNION ALL table operator

ü

E071-03

EXCEPT DISTINCT table operator

ü

E071-05

Columns combined via table operators need not have exactly

the same data type.

ü

E071-06

Table operators in subqueries

ü

E081

Basic Privileges

E081-01

SELECT privilege at the table level

E081-02

DELETE privilege

E081-03

INSERT privilege at the table level

E081-04

UPDATE privilege at the table level

E081-05

UPDATE privilege at the column level

E081-06

REFERENCES privilege at the table level

E081-07

REFERENCES privilege at the column level

E081-08

WITH GRANT OPTION

E081-09

USAGE privilege

E081-10

EXECUTE privilege

E091

Set functions

E091-01

AVG

ü

E091-02

COUNT

ü

E091-03

MAX

ü

E091-04

MIN

ü

E091-05

SUM

ü

E091-06

ALL quantifier

ü

E091-07

DISTINCT quantifier

ü

E101

Basic data manipulation

E101-01

INSERT statement

ü

E101-03

Searched UPDATE statement

ü

E101-04

Searched DELETE statement

ü

E111

Single row SELECT statement

E121

Basic cursor support

E121-01

DECLARE CURSOR

E121-02

ORDER BY columns need not be in select list

ü

E121-03

Value expressions in ORDER BY clause

E121-04

OPEN statement

E121-06

Positioned UPDATE statement

E121-07

Positioned DELETE statement

E121-08

CLOSE statement

E121-10

FETCH statement: implicit NEXT

E121-17

WITH HOLD cursors

E131

Null value support (nulls in lieu of values)

ü

E141

Basic integrity constraints

E141-01

NOT NULL constraints

ü

E141-02

UNIQUE constraints of NOT NULL columns

ü

E141-03

PRIMARY KEY constraints

ü

E141-04

Basic FOREIGN KEY constraint with the NO ACTION default

for both referential delete action and referential update action.

ü

E141-06

CHECK constraints

ü

E141-07

Column defaults

ü

E141-08

NOT NULL inferred on PRIMARY KEY

ü

E141-10

Names in a foreign key can be specified in any order

ü

E151

Transaction support

E151-01

COMMIT statement

ü

E151-02

ROLLBACK statement

ü

E152

Basic SET TRANSACTION statement

E152-01

SET TRANSACTION statement:

ISOLATION LEVEL SERIALIZABLE clause

E152-02

SET TRANSACTION statement:

READ ONLY and READ WRITE clauses

E153

Updatable queries with subqueries

ü

E161

SQL comments using leading double minus

ü

E171

SQLSTATE support

E182

Module language

F021

Basic information schema

F021-01

COLUMNS view

F021-02

TABLES view

F021-03

VIEWS view

F021-04

TABLE_CONSTRAINTS view

F021-05

REFERENTIAL_CONSTRAINTS view

F021-06

CHECK_CONSTRAINTS view

F031

Basic schema manipulation

F031-01

CREATE TABLE statement to create persistent base tables

ü

F031-02

CREATE VIEW statement

ü

F031-03

GRANT statement

F031-04

ALTER TABLE statement: ADD COLUMN clause

ü

F031-13

DROP TABLE statement: RESTRICT clause

ü

F031-16

DROP VIEW statement: RESTRICT clause

ü

F031-19

REVOKE statement: RESTRICT clause

F041

Basic joined table

F041-01

Inner join (but not necessarily the INNER keyword)

ü

F041-02

INNER keyword

ü

F041-03

LEFT OUTER JOIN

ü

F041-04

RIGHT OUTER JOIN

ü

F041-05

Outer joins can be nested

ü

F041-07

The inner table in a left or right outer join can also be used in an inner join

ü

F041-08

All comparison operators are supported (rather than just =)

ü

F051

Basic date and time

F051-01

DATE data type (including support of DATE literal)

ü

F051-02

TIME data type (including support of TIME literal)

ü

F051-03

TIMESTAMP data type (including support of TIMESTAMP literal)

ü

F051-04

Comparison predicate on DATE, TIME, and TIMESTAMP data types

ü

F051-05

Explicit CAST between datetime types and character string types

ü

F051-06

CURRENT_DATE

ü

F051-07

LOCALTIME

ü

F051-08

LOCALTIMESTAMP

ü

F081

UNION and EXCEPT in views

ü

F131

Grouped operations

F131-01

WHERE, GROUP BY, and HAVING clauses supported

in queries with grouped views

ü

F131-02

Multiple tables supported in queries with grouped views

ü

F131-03

Set functions supported in queries with grouped views

ü

F131-04

Subqueries with GROUP BY and HAVING clauses and grouped views

ü

F131-05

Single row SELECT with GROUP BY and HAVING

clauses and grouped views

F181

Multiple module support

F201

CAST function

ü

F221

Explicit defaults

ü

F261

CASE expression

F261-01

Simple CASE

ü

F261-02

Searched CASE

ü

F261-03

NULLIF

ü

F261-04

COALESCE

ü

F311

Schema definition statement

F471

Scalar subquery values

ü

F481

Expanded NULL predicate

ü

F501

Features and conformance views

F501-01

SQL_FEATURES view

F501-02

SQL_SIZING view

F501-03

SQL_LANGUAGES view

F812

Basic flagging

S011

Distinct data types

S011-01

USER_DEFINED_TYPES view

T321

Basic SQL-invoked routines

T321-01

User-defined functions with no overloading

ü

T321-02

User-defined stored procedures with no overloading

ü

T321-03

Function invocation

ü

T321-04

CALL statement

ü

T321-05

RETURN statement

ü

T321-06

ROUTINES view

T321-07

PARAMETERS view

T631

IN predicate with one list element

ü

Home | Site Contents | Documentation | NexusDB Manual V4 | SQL Reference | SQL Appendices