Inspectopedia
 
2024.3

Unused common table expression

Warning
New
Last modified: 03 December 2024

Reports unused common table expressions (CTE) inside the query.

Example (PostgreSQL):

By using WITH, we create a temporary named result set with the name a, also known as a common table expression (CTE). But we do not use this CTE later in the code. The unused CTE is greyed out.