2023-05-03 11:06:20 +02:00
|
|
|
== Why is this an issue?
|
|
|
|
|
2020-06-30 12:47:33 +02:00
|
|
|
include::../description.adoc[]
|
|
|
|
|
2023-05-03 11:06:20 +02:00
|
|
|
=== Noncompliant code example
|
2020-06-30 12:47:33 +02:00
|
|
|
|
2022-02-04 17:28:24 +01:00
|
|
|
[source,sql]
|
2020-06-30 12:47:33 +02:00
|
|
|
----
|
|
|
|
x := (y / 2 + 1); -- Compliant even if the parentheses are ignored
|
|
|
|
IF (x > 0) AND ((x+y > 0)) THEN -- Noncompliant
|
|
|
|
-- ...
|
|
|
|
END IF;
|
|
|
|
----
|
|
|
|
|
2023-05-03 11:06:20 +02:00
|
|
|
=== Compliant solution
|
2020-06-30 12:47:33 +02:00
|
|
|
|
2022-02-04 17:28:24 +01:00
|
|
|
[source,sql]
|
2020-06-30 12:47:33 +02:00
|
|
|
----
|
|
|
|
x := (y / 2 + 1);
|
|
|
|
IF (x > 0) AND (x+y > 0) THEN
|
|
|
|
-- ...
|
|
|
|
END IF;
|
|
|
|
----
|
2021-06-02 20:44:38 +02:00
|
|
|
|
2023-06-16 11:18:11 +02:00
|
|
|
include::../rspecator.adoc[]
|