| 341 |
Do not leave out the referential constraints (based on classifiers) |
Find non-key and non-foreign columns of base tables with a textual column and small field size in case of which there is a table with the name that is similar to the column name. Perhaps the table is a classifier table and the column should have a foreign key constraint referencing to the table. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2021-03-18 11:14 |
MIT License |
View |
| 342 |
Do not leave out the referential constraints (based on column names) |
Try to find missing foreign key constraints. Find columns of base tables that are not a part of any primary key, unique, and foreign key constraint, do not have an associated sequence generator, but have a name that reffers to the possibility that these are used to record some kind of codes or id's. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2023-11-26 16:35 |
MIT License |
View |
| 343 |
Do not leave out the referential constraints (based on column names) (2) |
Try to find missing foreign key constraints. Find columns of base tables that are not a part of any primary key, unique, and foreign key constraint, but have a name that reffers to the possibility that these are used to record references to a user. Exclude columns that have the default value CURRENT_USER or SESSION_USER. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2023-12-30 10:29 |
MIT License |
View |
| 344 |
Do not leave out the referential constraints (pairs of tables) |
Try to find missing foreign key constraints. Find pairs of base table columns that have the similar name, perhaps the same type, and that are not associated through a foreign key relationship. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2021-02-25 17:29 |
MIT License |
View |
| 345 |
Do not refer to the table schema in the references to columns |
Find routines where in SELECT or UPDATE statements references to columns are prefixed with references to the table schema. Referring to schema in this context bloats the code. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2021-11-04 17:32 |
MIT License |
View |
| 346 |
Do not specify a list of values in a table column definition |
Find cases where the list of valid data values in the column is specified in the column definition (in addition to specifying the type of the column) by using, for instance, check constraints or enumerated types. The check constraint is either associated directly with a table or is associated with a domain. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2022-06-09 14:30 |
MIT License |
View |
| 347 |
Do not use approach that one size fits all (primary key columns) |
Find base base tables have the simple primary key that contains the column with the (case insensitive) name id and an integer type. In addition, the primary key values are generated automatically by the system by using a sequence generator. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2023-03-18 20:58 |
MIT License |
View |
| 348 |
Do not use approach that one size fits all (unique index columns) |
Find base base tables have a simple unique index (not associated with a constraint) that contains the column with the (case insensitive) name id and an integer type. In addition, the key values are generated automatically by the system by using a sequence generator. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2023-01-07 15:12 |
MIT License |
View |
| 349 |
Double checking of the maximum character length |
Do not duplicate code. In this case a CHECK constraint duplicates the restriction that is already enforced with the help of the declaration of the maximum field size (for instance, VARCHAR(100)). |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2023-11-18 13:27 |
MIT License |
View |
| 350 |
Double negatives in Boolean expressions |
Write code that is simple to understand and not confusing. A double negative is a grammatical construction occurring when two forms of negation are used in the same expression (https://en.wikipedia.org/wiki/Double_negative). Double negatives in Boolean expressions make it more difficult to understand and maintain the code. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2021-02-25 17:29 |
MIT License |
View |
| 351 |
Double negatives in regular expressions |
Fing regular expression patterns that use [^\S] instead of \s or [^\D] instead of \d or [^\W] instead of \w. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2023-11-09 12:01 |
MIT License |
View |
| 352 |
Duplicate check of empty strings |
Find columns that have a check that prevents the empty string in the column but there is already another check on the column that enforces the constraint. If there is a constraint description!~'^[[:space:]]*$', then it covers the constraint description!='' and the latter becomes redundant. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2024-12-23 14:28 |
MIT License |
View |
| 353 |
Duplicate comments |
Find comments that have been registered with a COMMENT statement and that are associated with more than one object. It would probably mean that a comment is incorrect or missing. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2024-12-21 17:31 |
MIT License |
View |
| 354 |
Duplicate enumerated types |
Find enumerated types with exactly the same values. There should not be multiple types that have the same values. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2021-02-25 17:30 |
MIT License |
View |
| 355 |
Duplicate NOT NULL constraints |
Find columns that have NOT NULL constraint through a domain and also directly. Do not duplicate NOT NULL constraints in orde to avoid confusion and surprises. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2021-02-25 17:30 |
MIT License |
View |
| 356 |
Duplicate removal of duplicates in derived tables |
Find derived tables (views and materialized views) that contain both DISTINCT and GROUP BY. Make sure that the means for removing duplicate rows from the query result are not duplicated. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2025-01-15 14:16 |
MIT License |
View |
| 357 |
Duplicate specification of character classes |
Find regular expressions where within the same specification of a character class the character class alnum as well as 0-9, \d, A-Z, or a-z has been defined. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2023-12-24 10:43 |
MIT License |
View |
| 358 |
Duplicate triggers |
Find cases where the same table has multiple triggers with the same type (row-level, statement-level) that react to the same event with the same WHEN condition and with the same way (by invoking the same function). |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2021-02-25 17:30 |
MIT License |
View |
| 359 |
Duplicate user-defined routines |
Find user-defined routines with the exact duplicate body and parameters. There should not be multiple routines with exactly the same body and parameters (name, type). Having such duplicates is redundancy. Do remember that the same task can usually be solved in multiple different ways. Thus, the exact copies of routine bodies are not the only possible duplication. Moreover, it could be that different routines that solve the same task have different parameter names (but the parameters have the same types, ordinal positions, default values or the routines have different order of parameters). Thus, the query does not find all the duplications. |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2021-11-05 11:59 |
MIT License |
View |
| 360 |
Duplication of case insensitivity specification in a regular expression |
Find regular expressions that use both case insensitive search operator ~* and case insensitivity modifier (?i). |
Problem detection |
INFORMATION_SCHEMA+system catalog base tables |
2021-11-04 12:49 |
MIT License |
View |