db* CODECOP Validators v5.0.1

• Based on db* CODECOP v5.0.1
  • see Release Notes
  • see Trivadis PL/SQL & SQL Coding Guidelines Version 4.4.

db* CODECOP Validators v5.0.0

New / Changed

• Based on db* CODECOP v5.0.0
  • see Release Notes
  • see Trivadis PL/SQL & SQL Coding Guidelines Version 4.4.

db* CODECOP Validators v4.5.0

New / Changed

• Based on db* CODECOP v4.5.0
  • see Release Notes
• Migrate from Xtend to Java (#42)
• Eliminate system dependencies in Maven POM (#63)
• Use current plsql model to retrieve table in using clause of merge statement (see 1cf838f)
• Using regular expressions to check naming conventions in TrivadisPlsqlNaming (#66)
• Update severity of custom guidelines to match definition (#67)

Fixed

• Inconsistencies between G-9102 and G-2185 (#62)
• G-9601 false positive when using parallel hint with degree only (#65)

db* CODECOP Validators v4.4.0

New / Changed

• Based on db* CODECOP v4.4.0

  • see Release Notes

• Migrated Validator OverrideTrivadisGuidelines from Xtend to Java.

  • Applied new logic in G-1050 validation check (violation is thrown only when an overridable threshold is reached).
  • This validator overrides the new default implementation as before to ignore logger calls.

Fixed

• False negative in G-9501 when using constant (#55).
• False positive in G-9501 when assigning a parameter to a variable/constant and asserting it in the body (#56)

db* CODECOP Validators v4.3.1

New

• Based on db* CODECOP v4.3.1
  • see Release Notes

db* CODECOP Validators v4.3.0

New

• Based on db* CODECOP v4.3.0

  • see Release Notes

• #46 Add test cases for table_stats, index_stats and column_status

  • show that table references are not checked for these hints

• #47 Add guideline checks for TABLE_STATS hint

  • Check for G-9604: Never use an invalid stats method.
  • Check for G-9605: Never use an invalid stats keyword.

• #52 Add SQL files examples for all guidelines in the TrivadisGuidelines3Plus validator

  • SonarQube rule description (reason, good and bad example) for:
    • 🆕 G-9101: Always prefix global variables with 'g_'.
    • 🆕 G-9102: Always prefix local variables with 'l_'.
    • 🆕 G-9103: Always prefix cursors with 'c_'.
    • 🆕 G-9104: Always prefix records with 'r_'.
    • 🆕 G-9105: Always prefix collection types (arrays/tables) with 't_'.
    • 🆕 G-9106: Always prefix objects with 'o_'.
    • 🆕 G-9107: Always prefix cursor parameters with 'p_'.
    • 🆕 G-9108: Always prefix in parameters with 'in_'.
    • 🆕 G-9109: Always prefix out parameters with 'out_'.
    • 🆕 G-9110: Always prefix in/out parameters with 'io_'.
    • 🆕 G-9111: Always prefix record type definitions with 'r_' and add the suffix '_type'.
    • 🆕 G-9112: Always prefix collection type definitions (arrays/tables) with 't_' and add the suffix '_type'.
    • 🆕 G-9113: Always prefix exceptions with 'e_'.
    • 🆕 G-9114: Always prefix constants with 'co_'.
    • 🆕 G-9115: Always prefix subtypes with '_type'.
    • ✅ G-9501: Never use parameter in string expression of dynamic SQL. Use asserted local variable instead.
    • 🆕 G-9600: Never define more than one comment with hints.
    • 🆕 G-9601: Never use unknown hints.
    • 🆕 G-9602: Always use the alias name instead of the table name.
    • 🆕 G-9603: Never reference an unknown table/alias.
    • 🆕 G-9604: Never use an invalid stats method.
    • 🆕 G-9605: Never use an invalid stats keyword.

Fixed

• #48 G-9102: false positive for collection type

db* CODECOP Validators v4.2.2

New

• Based on db* CODECOP v4.2.3
  • see Release Notes

Fixed

• #44 G-9603 - false positive for hints referring table/alias in using clause of merge statement

db* CODECOP Validators v4.2.1

New

• Based on db* CODECOP v4.2.2
  • see Release Notes

db* CODECOP Validators v4.2.0

New

• Based on db* CODECOP v4.2.1
  • see Release Notes

db* CODECOP Validators v4.1.0

New

• Based on db* CODECOP v4.1.3
  • see Release Notes