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