SQL Functions and Statements
Zstandard Compression Support
CREATE TABLE
, CREATE PROJECTION
, and COPY
now support Zstandard compression. For details, see Encoding Types.
ALTER TABLE Enhancements
ALTER TABLE
supports two new options:
IF NOT EXISTS
can qualifyALTER TABLE…ADD COLUMN
:ALTER TABLE table-name ADD COLUMN IF NOT EXISTS column-name data-type
IF EXISTS
can qualifyALTER TABLE…DROP COLUMN
:
ALTER TABLE table-name DROP COLUMN IF EXISTS column-name
CREATE SEQUENCE Enhancements
CREATE SEQUENCE
now supports the option IF NOT EXISTS
.
New Flex Table Function Parameters
The following flex table functions have new parameters:
Function | New Parameters |
---|---|
|
|
MAPKEYS : |
|
MAPKEYSINFO
|
max_key_length
|
MAPVALUES : |
max_value_length
|