Releases · Trivadis/plsql-analyzer

Released on 2019-09-26
Changed
- PL/SQL grammar
  - Support keyword MOD and other keywords as query_name in the subquery_factoring_clause.
  - Support keyword ONE, e.g. as column alias.
  - Support keyword WELLFORMED, e.g. as parameter name.
  - Support keyword WORK, e.g. as parameter name.
- Expose hints as new class named HintOrComment.
  - Customer have now access to source code details (e.g. start line, offset, etc.) via the PL/SQL parser.
  - This leads to a changed XML output structure (attribute instead of node).
  - The XPath expression to access hints changed from text() to @text.
- Increased metadata versions
  - for database code to 9
  - for XML structure to 9
  - updates are installed on the first run
  - all source is processed on the first run
- Updated PLSQL.xsd and HTML documentation to cover PL/SQL Parser version 2.1.12
- Included preview/trial license is valid thru 2020-03-31
Fixed
- Parse error when using udf_pragma.
- Parse error when using record with dot notation in values_clause of INSERT statement. For example INSERT INTO t VALUES in_param.rec.
- Parse error when using NOT in expressions with A SET, NAN, INFINITE, PRESENT, EMPTY, JSON, OF TYPE. Fore example x IS NOT A SET.
Won’t Fix
- Support of keyword JSON in table name or table alias due to conflicts with JSON_condition.
- Empty conditional compilation branches (see also Parser Limitations)

Released on 2019-04-04
Fixed
- PL/SQL grammar
  - Parse error when using PRAGMA INLINE with a second string parameter.
Changed
- PL/SQL grammar
  - Support keyword EXCLUDE, e.g. as procedure name.
  - Support keyword INSTANTIABLE, e.g. as column name.
  - Support quote literal character / (see also Parser Limitations)
- SQL*Plus grammar
  - Support $ as alias for HOST command.
- Updated PLSQL.xsd and HTML documentation to cover PL/SQL Parser version 2.1.10
- Included preview/trial license is valid thru 2019-09-30

Released on 2017-09-22
Fixed:
- Using quote delimiter character ~ (tilde) leads to parse errors
- Parse error when using COUNT in pivot_clause

Released on 2017-08-15
Fixed:
- Using concatenation operator || with whitespace between the vertical bars leads to parse errors
Changed
- Updated PLSQL.xsd and HTML documentation to cover PL/SQL Parser version 2.1.7
- Documented limitation regarding error_logging_clause, see Parser Limitations for examples

Released on 2017-05-14
New:
- Oracle 12.2.0.1 grammar support
  - SQL*Plus
    - History command
  - SQL
    - Analytic views
    - Join groups
    - Oracle sharding
    - PDB lockdown profiles
    - ADMINISTER KEY MANAGEMENT Enhancements
    - FLASHBACK DATABASE Enhancement
    - SELECT Enhancement
    - New COLLATE Operator
    - New or Enhanced Expressions
    - Enhanced Condition
    - New or Enhanced Functions
  - PL/SQL
    - ACCESSIBLE BY clause Enhancements
    - Data-Bound Collation
    - PL/SQL Expressions Enhancements
    - Support for SQL JSON operators in PL/SQL (based on SQL changes)
    - PL/SQL Coverage Pragma
    - PL/SQL Deprecation Pragma
    - Sharing Metadata-Linked Application Common Objects
Changed:
- Requires at least a Java 7 runtime environment
Fixed:
- Parsing errors in XMLELEMENT and other functions when using certain non-standard function parameters

Released on 2017-02-05
Improved:
- JDK detection
Fixed:
- single_table_insert with values_clause leads to parse errors in SQL scripts if terminated by slash instead of semicolon
- greater equal (>=) and less equal (<=) are reported as less than (<)

Released on 2016-12-16
Extended grammar to support additional keyword PERIOD, e.g. as variable name
Extended grammar to support keywords as measure_column of a cell_assignment in the model_clause

Released on 2016-09-05
Fixed grammar to support inline views as target of a MERGE statement (undocumented)
Fixed grammar to support ASC|DESC and NULLS FIRST|LAST in row_pattern_order_by clause (undocumented)
Updated PLSQL.xsd and HTML documentation

Released on 2016-08-26
Fixed grammar to support default namespace at any position within XMLnamespaces_clause
Fixed grammar to support Temporal Validity in flashback_query_clause
Fixed grammar to support VARCHAR with BYTE and CHAR semantics (as VARCHAR2)
Extended grammar to support multiple flashback_query_clause
Extended grammar to support ~ as quote delimiter character
Extended grammar to support additional keywords, e.g. as variable name
- body
- show
- subtype
- versions

Provide feedback