Click or drag to resize

SA0145 : The EOL marker sequence is not the expected {CR}{LF}

The topic describes the SA0145 analysis rule.

Message

The EOL marker sequence is not the expected {CR}{LF}

Description

The rule checks the SQL code for appearance of EOL character sequence different than the {CR}{LF}.

Scope

The rule has a Batch scope and is applied only on the SQL script.

Parameters
NameDescriptionDefault Value
RuleSuppressMark

Suppress rule reporting a rule violation in case a comment containing the value of this parameter is found next to the source of violation.

IGNORE:SA0145

Remarks

The rule does not need Analysis Context or SQL Connection.

Categories

Design Rules

Additional Information

There is no additional info for this rule.

Example Test Script
SQL
 1SELECT *
 2FROM Table1,
 3 Table2 b,
 4 (SELECT *
 5  FROM Table4c) c
 6INNER JOIN Table3 ON Table3.Table4_id = c.id
 7INNER JOIN Table5 -- The line ends with '\r'
 8INNER JOIN Table6 ON Table6.Table5_id = Table5.id -- The line ends with '\n'
 9ON Table3.Table4_id = c.id,
10 Table8 f, -- The line ends with '\r'
11 Table9,
12 (SELECT * FROM Table7) h;

Analysis Results

No violations found.

See Also

Other Resources