New rule: check constraints can not have subqueries
Nobody has claimed this yet.
Assessment
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Newbie friendliness
- 58/100
Research direction
No files, tests, or entry points are named in the issue. Locate the rule implementation and parser tests for PostgreSQL CHECK constraints in Squawk, then confirm that a subquery inside a CHECK constraint is reported and decide whether the diagnostic should recommend triggers.
Written by the indexing model from the issue text.
Description
Context:
Just found out that subqueries can not be used in the check constraint.
Squawk linter does not complain but Postgresql throws the following error:
ERROR: cannot use subquery in check constraint (SQLSTATE 0A000)
Example:
ALTER TABLE
table_x
ADD
CONSTRAINT bar_should_equal_to_banana CHECK (
(
SELECT
bar
FROM
table_y
WHERE
table_y.pk = table_x.y_pk
) = 'banana'
);
Expected fix:
New rule should throw an error on subqueries used in the check constraint.
Should suggest to use triggers instead?
- Dominant language
- Rust
- Stars
- 1.2k
- Forks
- 70
- Avg merge
- 52m
- Merged PRs (30d)
- 47
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from sbdchd/squawk
-
enhancement
Difficulty 4/5 3-5 days Newbie friendliness 48/100
-
enhancement
Difficulty 3/5 1-2 days Newbie friendliness 58/100
-
enhancement
Difficulty 3/5 1-2 days Newbie friendliness 56/100
-
Difficulty 4/5 3-5 days Newbie friendliness 35/100
-
enhancement
Difficulty 5/5 Over a week Newbie friendliness 35/100
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 86/100
kwakseongjae/auto-hwp#319 ·
-
area:cli bug filter-quality good first issue priority:medium
Difficulty 2/5 1-3 hours Newbie friendliness 84/100
-
Difficulty 1/5 Under an hour Newbie friendliness 72/100
bevyengine/bevy#25861 ·
-
comp-datalake
Difficulty 2/5 1-3 hours Newbie friendliness 88/100
ClickHouse/ClickHouse#121222 ·
-
enhancement remote
Difficulty 2/5 1-3 hours Newbie friendliness 68/100