Beta Notes
Formatting/Parsing (QP5)
-
Improved syntax check on PLS_INTEGER data type usage. E.g. its usage is no longer allowed in CAST expressions.
-
Fix: The function LISTAGG can now have one argument as well.
-
Formatting enhanced for some or all forms of:
CREATE TABLE
ALTER TABLE (each clauses on its own line)
CREATE DATABASE
ALTER DATABASE
TRUNCATE TABLE
CREATE SEQUENCE
ALTER PROCEDURE
ALTER INDEX -
Formatter fix (QP-2556) : CREATE VIEW and CREATE MATERIALIZED VIEW had different column arrangements. Both have been unified.
-
Formatter fix (QP-2527) : CREATE TABLE: Column alignment broken in drop 5.307.
-
Formatter: Model clause formatting enhanced.
-
Fix (QP-2460) : Rule 2831 (“Use PLS_INTEGER instead of INTEGER or equivalent subtypes.”) No longer raising in CAST(… AS data-type), and in column definitions or attributes found in CREATE/ALTER TABLE, CLUSTER, TYPE … and perhaps a few more clauses or statements.
-
Fix (QP-2398) : Rule 2118 (“Avoid DDLs other than Truncate, Exchange/Split partition.”) Will now process DDL quoted inside an EXECUTE IMMEDIATE statement only, excluding all other DDL statements.
-
Fix (QP-2553) : Access violation during legacy rule processing when having a token larger than 1,000 characters in the input text. The new limit is 500 KB.
Compare Schemas
Compare Schemas (Legacy) and Compare Multiple Schemas have been combined into a single window.