Problem ORDER BY priority DESC returns results in ascending priority order (MEDIUM before HIGH) instead of descending (HIGH before MEDIUM). Priority ordering should follow the severity hierarchy: CRITICAL => HIGH => MEDIUM => LOW.

Likely cause Priority is being sorted alphabetically rather than by its ordinal/severity rank. Priority: Medium - affects usability of DSL for triage workflows.