Skip to content

Releases: Trivadis/plsql-cop-validators

db* CODECOP Validators v5.0.1

26 Mar 17:04
Compare
Choose a tag to compare

db* CODECOP Validators v5.0.0

20 Mar 18:37
Compare
Choose a tag to compare

db* CODECOP Validators v4.5.0

22 Jan 13:14
Compare
Choose a tag to compare

New / Changed

  • Based on db* CODECOP v4.5.0
  • 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

04 Oct 17:50
Compare
Choose a tag to compare

New / Changed

  • Based on db* CODECOP v4.4.0

  • 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

20 Jan 10:17
Compare
Choose a tag to compare

New

db* CODECOP Validators v4.3.0

03 Sep 11:27
Compare
Choose a tag to compare

New

  • Based on db* CODECOP v4.3.0

  • #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

16 Dec 07:25
Compare
Choose a tag to compare

New

Fixed

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

db* CODECOP Validators v4.2.1

28 Sep 12:30
Compare
Choose a tag to compare

New

db* CODECOP Validators v4.2.0

13 Sep 11:47
Compare
Choose a tag to compare

New

db* CODECOP Validators v4.1.0

15 May 19:29
Compare
Choose a tag to compare

New