Reference: Statements and Options

Read about updates to Reference: Statements and Options.

These changes affect SQL Statements.

ALTER TABLE Statement
Section Correction
Parameters Remove PARTITION BY hash-partitioning-scheme and PARTITION BY composite-partitioning-scheme from the alter-clause and create-clause.
Usage Remove PARTITION BY HASH and SUBPARTITION BY. ALTER TABLE PARTITION BY HASH is unsupported.
Permissions Remove PARTITION BY HASH. ALTER TABLE PARTITION BY HASH is unsupported.

These changes affect Database Options.

QUERY_PLAN_MIN_TIME Option
Section Correction
Allowed Values Integer, in milliseconds.
Description When these options are set, setting a QUERY_PLAN_MIN_TIME query execution threshold prevents the generation of query plans for queries whose execution times does not exceed the specified threshold.
SNAPSHOT_VERSIONING Option
Section Correction
Scope

Option can be set at the database (PUBLIC) or user level. When set at the database level, the value becomes the default for any new user, but has no impact on existing users. When set at the user level, overrides the PUBLIC value for that user only. No system privilege is required to set option for self or at connection level. System privilege is required to set at database level or at user level for any user other than self.

Requires the SET ANY PUBLIC OPTION system privilege to set this option. Takes effect immediately.
Parent topic: Documentation Changes