rspec/rules/S126/tsql/rule.adoc
Fred Tingaud 51369b610e
Make sure that includes are always surrounded by empty lines (#2270)
When an include is not surrounded by empty lines, its content is inlined
on the same line as the adjacent content. That can lead to broken tags
and other display issues.
This PR fixes all such includes and introduces a validation step that
forbids introducing the same problem again.
2023-06-22 10:38:01 +02:00

53 lines
1.1 KiB
Plaintext

== Why is this an issue?
This rule applies whenever an ``++IF++`` statement is followed by one or more ``++ELSE IF++`` statements; the final ``++ELSE IF++`` should be followed by an ``++ELSE++`` statement.
The requirement for a final ``++ELSE++`` statement is defensive programming.
The ``++ELSE++`` statement should either take appropriate action or contain a suitable comment as to why no action is taken. This is consistent with the requirement to have a final ``++ELSE++`` clause in a ``++CASE++`` statement.
=== Noncompliant code example
[source,sql]
----
IF @x = 1
PRINT 'A'
ELSE IF @x = 2
PRINT 'B'
ELSE IF @x = 3
PRINT 'C'
-- Noncompliant; final ELSE is missing
----
=== Compliant solution
[source,sql]
----
IF @x = 1
PRINT 'A'
ELSE IF @x = 2
PRINT 'B'
ELSE IF @x = 3
PRINT 'C'
ELSE
PRINT 'Z'
----
ifdef::env-github,rspecator-view[]
'''
== Implementation Specification
(visible only on this page)
include::../message.adoc[]
'''
== Comments And Links
(visible only on this page)
include::../comments-and-links.adoc[]
endif::env-github,rspecator-view[]