DataGrip 2022.1 Help

Code Inspection: Redundant ordering direction

Reports redundant ordering directions like ASC and DESC in ORDER BY clauses.

Example (MySQL):
CREATE TABLE foo(a INT, b INT, c INT); SELECT * FROM foo ORDER BY a ASC, b DESC, c ASC;

The ORDER BY keyword sorts the records in the ascending order by default. So, the ASC keyword for a and c columns is redundant.

Suppress an inspection in the editor

  1. Position the caret at the highlighted line and press Alt+Enter or click the Intention action icon.

  2. Click the arrow next to the inspection you want to suppress and select the necessary suppress action.

Last modified: 07 April 2022