| Goal | Find SQL functions that have multiple statements with the RETURNING clause. |
|---|---|
| Notes | The query excludes routines that only have multiple RETURNING within one statement. |
| Type | Problem detection (Each row in the result could represent a flaw in the design) |
| Reliability | High (Few or no false-positive results) |
| License | MIT (opens in new tab) |
| Fixing Suggestion | Think through the order of statements in the function and what should be the returned value. Remove all the RETURNING clauses except one. |
| Data Source | INFORMATION_SCHEMA+system catalog |
| SQL Query |
|
Collections
This query belongs to the following collections:
Find problems automatically
Queries, that results point to problems in the database. Each query in the collection produces an initial assessment. However, a human reviewer has the final say as to whether there is a problem or not .
| Name | Description |
|---|---|
| Find problems automatically | Queries, that results point to problems in the database. Each query in the collection produces an initial assessment. However, a human reviewer has the final say as to whether there is a problem or not . |
Categories
This query is classified under the following categories:
User-defined routines
Queries of this category provide information about the user-defined routines
| Name | Description |
|---|---|
| User-defined routines | Queries of this category provide information about the user-defined routines |