Skip to content

@PhilippSalvisberg PhilippSalvisberg released this Dec 19, 2019 · 9 commits to master since this release

  • Released on 2019-09-28
  • Changed
    • Guidelines
      • Link to Trivadis PL/SQL & SQL Guidelines v3.6 in HTML report.
      • Renamed G-3130 from “Try to use ANSI-join syntax” to “Try to use ANSI SQL-92 join syntax”.
      • Renamed G-3160 from “Avoid virtual columns to be visible” to “Avoid visible virtual columns”.
      • Renamed G-8410 from “Always use application locks to ensure a program unit only running once at a given time” to “Always use application locks to ensure a program unit is only running once at a given time”.
    • 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.
    • Included preview/trial license is valid thru 2020-03-31
  • Fixed
    • Guidelines
      • G-3120: false positive when using SYSDATE, SYSTIMESTAMP, NULL, LEVEL, ROWNUM, CONNECT_BY_ISLEAF in query with joins.
    • PL/SQL grammar
      • 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)
Assets 3

@PhilippSalvisberg PhilippSalvisberg released this Dec 19, 2019 · 9 commits to master since this release

  • Released on 2019-05-31
  • Fixed
  • Changed
    • Support extension .tpb as used in utPLSQL project for type body files
    • Added link file to Trivadis PL/SQL & SQL Coding Guidelines as replacement for PDF file
    • Removed example validators project, it’s provided as dedicated open source project cop-validators on GitHub
Assets 3

@PhilippSalvisberg PhilippSalvisberg released this Dec 19, 2019 · 9 commits to master since this release

  • Released on 2019-04-04
  • Fixed
    • Guidelines
      • G-3120 – false positive when using constants in projection.
      • G-4140 – false positive when using FORALL statement.
      • G-7110 – false positive when using functions/procedures with a single parameter.
    • 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.
    • Support registered extensions (sql, prc, fnc, pks, pkb, trg, vw, tps, tbp, plb, pls, rcv, spc, typ, aqt, aqp, ctx, dbl, tab, dim, snp, con, collt, seq, syn, grt, sp, spb, sps, pck) in upper case. However, default filter is still in lower case.
    • HTML report refers to the Trivadis PL/SQL & SQL Coding Guidelines Version 3.3 hosted on GitHub.
    • Included preview/trial license is valid thru 2019-09-30
Assets 2

@PhilippSalvisberg PhilippSalvisberg released this Dec 19, 2019 · 9 commits to master since this release

  • Released on 2018-09-10
  • Changed
    • Support files with .pck extension and include pck in the default filter
    • Included preview/trial license is valid thru 2019-03-31
Assets 2

@PhilippSalvisberg PhilippSalvisberg released this Dec 19, 2019 · 9 commits to master since this release

  • Released on 2018-03-11
  • Fixed
    • Use default license location when an empty license parameter is passed. This enables the use of the SonarQube plugin without specifying a license file.
Assets 2

@PhilippSalvisberg PhilippSalvisberg released this Dec 19, 2019 · 9 commits to master since this release

  • Released on 2018-03-11
  • Changed
    • Included preview/trial license is valid thru 2018-09-30
Assets 2

@PhilippSalvisberg PhilippSalvisberg released this Dec 19, 2019 · 9 commits to master since this release

  • Released on 2017-09-22
  • Fixed:
    • Using quote delimiter character ~ (tilde) leads to parse errors
    • Parse error when using COUNT in pivot_clause
  • Changed
    • Updated PLSQL Editor for Eclipse to version 2.1.8
Assets 2

@PhilippSalvisberg PhilippSalvisberg released this Dec 19, 2019 · 9 commits to master since this release

  • Released on 2017-08-15
  • Fixed:
    • Using concatenation operator || with whitespace between the vertical bars leads to parse errors
  • Changed
    • Updated PLSQL Editor for Eclipse to version 2.1.7
    • Documented limitation regarding error_logging_clause, see Parser Limitations for examples
Assets 2

@PhilippSalvisberg PhilippSalvisberg released this Dec 19, 2019 · 10 commits to master since this release

  • 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
    • All guideline examples have been extended by a reason. This reason is extracted into the rules.xml when creating the genmodel for the SonarQube plugin
  • Changed:
    • Halstead based metrics may produce slightly higher values, since all data types are processed as operators
    • Requires at least a Java 7 runtime environment
  • Fixed:
    • Parsing errors in XMLELEMENT and other functions when using certain non-standard function parameters
Assets 2

@PhilippSalvisberg PhilippSalvisberg released this Dec 19, 2019 · 10 commits to master since this release

  • Released on 2017-02-12
  • New:
    • New simple example validator com.trivadis.tvdcc.validators.GLP to check naming of global variables (g_), local variables (l_) and parameters (p_) only
    • Using new AbstractValidatorTest class for all validator unit tests
  • Fixed:
    • Wrong message for guideline 9003, use c_ instead of co_ prefix
    • Distinguish between markers and code excerpts in example validator com.trivadis.tvdcc.validators.TrivadisGuidelines3Plus
    • Use dedicated JVM for each validator test to enforce instantiation of validator singleton
Assets 2
You can’t perform that action at this time.