Inspectopedia Help

Constant condition

Reports conditions in WHERE or JOIN clauses that are always TRUE or always FALSE.

Example (MySQL):

CREATE TABLE t1 (a TEXT, b INT, c BOOLEAN); SELECT a FROM t1 WHERE 'Cat' = 'Cat';

The 'Cat' = 'Cat' is always true and will be reported.

Last modified: 12 March 2024