SQL Feature Checklist¶
To understand which ANSI SQL and other SQL features SQream DB supports, use the tables below.
In this topic:
Data Types and Values¶
Read more about supported data types.
Item |
Supported |
Further information |
---|---|---|
|
Supported |
Boolean values |
|
Supported |
Unsigned 1 byte integer (0 - 255) |
|
Supported |
2 byte integer (-32,768 - 32,767) |
|
Supported |
4 byte integer (-2,147,483,648 - 2,147,483,647) |
|
Supported |
8 byte integer (-9,223,372,036,854,775,808 - 9,223,372,036,854,775,807) |
|
Supported |
4 byte floating point |
|
Supported |
8 byte floating point |
|
Supported |
Fixed-point numbers. |
|
Supported |
Variable length string - ASCII only |
|
Supported |
Variable length string - UTF-8 encoded |
|
Supported |
Date |
|
Supported |
Date and time |
|
Supported |
|
|
Not supported |
Can be stored as a text string or as part of a |
Contraints¶
Item |
Supported |
Further information |
---|---|---|
Not null |
Supported |
|
Default values |
Supported |
|
|
Supported - Different name |
|
Transactions¶
SQream DB treats each statement as an auto-commit transaction. Each transaction is isolated from other transactions with serializable isolation.
If a statement fails, the entire transaction is cancelled and rolled back. The database is unchanged.
Read more about transactions in SQream DB.
Indexes¶
SQream DB has a range-index collected on all columns as part of the metadata collection process.
SQream DB does not support explicit indexing, but does support clustering keys.
Read more about clustering keys and our metadata system.
Schema Changes¶
Item |
Supported |
Further information |
---|---|---|
|
Supported |
ALTER TABLE - Add column, alter column, drop column, rename column, rename table, modify clustering keys |
Rename database |
Not supported |
|
Rename table |
Supported |
|
Rename column |
Supported |
|
Add column |
Supported |
|
Remove column |
Supported |
|
Alter column data type |
Not supported |
|
Add / modify clustering keys |
Supported |
|
Drop clustering keys |
Supported |
|
Add / Remove constraints |
Not supported |
|
Rename schema |
Not supported |
|
Drop schema |
Supported |
|
Alter default schema per user |
Supported |
Statements¶
Item |
Supported |
Further information |
---|---|---|
SELECT |
Supported |
|
CREATE TABLE |
Supported |
|
CREATE FOREIGN / EXTERNAL TABLE |
Supported |
|
DELETE |
Supported |
|
INSERT |
Supported |
|
TRUNCATE |
Supported |
|
UPDATE |
Not supported |
|
VALUES |
Supported |
Clauses¶
Item |
Supported |
Further information |
---|---|---|
|
Supported |
|
|
Not supported |
|
|
Supported |
|
|
Supported |
|
|
Supported |
Table Expressions¶
Item |
Supported |
Further information |
---|---|---|
Tables, Views |
Supported |
|
Aliases, |
Supported |
|
|
Supported |
|
Table expression subqueries |
Supported |
|
Scalar subqueries |
Not supported |
Scalar Expressions¶
Read more about Scalar Expressions.
Item |
Supported |
Further information |
---|---|---|
Common functions |
Supported |
|
Comparison operators |
Supported |
|
Boolean operators |
Supported |
|
Conditional expressions |
Supported |
|
Conditional functions |
Supported |
|
Pattern matching |
Supported |
|
REGEX POSIX pattern matching |
Supported |
|
|
Not supported |
|
|
Partial |
Literal values only |
Bitwise arithmetic |
Supported |
|
Permissions¶
Read more about Access Control in SQream DB.
Item |
Supported |
Further information |
---|---|---|
Roles as users and groups |
Supported |
|
Object default permissions |
Supported |
|
Column / Row based permissions |
Not supported |
|
Object ownership |
Not supported |
Extra Functionality¶
Item |
Supported |
Further information |
---|---|---|
Information schema |
Supported |
|
Views |
Supported |
|
Window functions |
Supported |
|
CTEs |
Supported |
|
Saved queries, Saved queries with parameters |
Supported |
|
Sequences |
Supported |