Read about updates to Reference: Statements and Options.
These changes affect SQL Statements.
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.
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. |
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. |