SQL-L006 @ 177b7dc • QuackatronHQ / Gigarepo

Run summary

a year ago

34b6022..177b7dc

23 s

Multiple whitespaces around an operators SQL-L006

Style

Minor

26 occurrences in this check

Operators should be followed by a space

sql/pkg/semp.sql

11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto15
16
17INSERT INTO mnop (m, n) SELECT i, (1e9 + i/2e4)::float FROM generate_series(1, 2e4) AS i(i) RETURNING NOTHING

Operators should be preceded by a space

sql/pkg/semp.sql

11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto15
16
17INSERT INTO mnop (m, n) SELECT i, (1e9 + i/2e4)::float FROM generate_series(1, 2e4) AS i(i) RETURNING NOTHING

Operators should be followed by a space

sql/pkg/semp.sql

11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto15
16
17INSERT INTO mnop (m, n) SELECT i, (1e9 + i/2e4)::float FROM generate_series(1, 2e4) AS i(i) RETURNING NOTHING

Operators should be preceded by a space

sql/pkg/semp.sql

11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto15
16
17INSERT INTO mnop (m, n) SELECT i, (1e9 + i/2e4)::float FROM generate_series(1, 2e4) AS i(i) RETURNING NOTHING

Operators should be followed by a space

sql/pkg/semp.sql

11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto15
16
17INSERT INTO mnop (m, n) SELECT i, (1e9 + i/2e4)::float FROM generate_series(1, 2e4) AS i(i) RETURNING NOTHING

Operators should be preceded by a space

sql/pkg/semp.sql

11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto15
16
17INSERT INTO mnop (m, n) SELECT i, (1e9 + i/2e4)::float FROM generate_series(1, 2e4) AS i(i) RETURNING NOTHING

Operators should be followed by a space

sql/pkg/semp.sql

11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto15
16
17INSERT INTO mnop (m, n) SELECT i, (1e9 + i/2e4)::float FROM generate_series(1, 2e4) AS i(i) RETURNING NOTHING

Operators should be preceded by a space

sql/pkg/semp.sql

11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto15
16
17INSERT INTO mnop (m, n) SELECT i, (1e9 + i/2e4)::float FROM generate_series(1, 2e4) AS i(i) RETURNING NOTHING

Operators should be followed by a space

sql/pkg/semp.sql

10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence14  a+(b*c), (a+b)*c             -- ditto
15
16

Operators should be preceded by a space

sql/pkg/semp.sql

10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence14  a+(b*c), (a+b)*c             -- ditto
15
16

Operators should be followed by a space

sql/pkg/semp.sql

10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence14  a+(b*c), (a+b)*c             -- ditto
15
16

Operators should be preceded by a space

sql/pkg/semp.sql

10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence14  a+(b*c), (a+b)*c             -- ditto
15
16

Operators should be followed by a space

sql/pkg/semp.sql

10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence14  a+(b*c), (a+b)*c             -- ditto
15
16

Operators should be preceded by a space

sql/pkg/semp.sql

10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto
13  (a+b)*(c*d),                 -- mixed precedence14  a+(b*c), (a+b)*c             -- ditto
15
16

Operators should be followed by a space

sql/pkg/semp.sql

 9  d + (a + (b - c)), d + (a - (b + c)), -- ditto
10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto
15

Operators should be preceded by a space

sql/pkg/semp.sql

 9  d + (a + (b - c)), d + (a - (b + c)), -- ditto
10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto
15

Operators should be followed by a space

sql/pkg/semp.sql

 9  d + (a + (b - c)), d + (a - (b + c)), -- ditto
10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto
15

Operators should be preceded by a space

sql/pkg/semp.sql

 9  d + (a + (b - c)), d + (a - (b + c)), -- ditto
10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto
15

Operators should be followed by a space

sql/pkg/semp.sql

 9  d + (a + (b - c)), d + (a - (b + c)), -- ditto
10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto
15

Operators should be preceded by a space

sql/pkg/semp.sql

 9  d + (a + (b - c)), d + (a - (b + c)), -- ditto
10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto
15

Operators should be followed by a space

sql/pkg/semp.sql

 9  d + (a + (b - c)), d + (a - (b + c)), -- ditto
10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto
15

Operators should be preceded by a space

sql/pkg/semp.sql

 9  d + (a + (b - c)), d + (a - (b + c)), -- ditto
10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto
15

Operators should be followed by a space

sql/pkg/semp.sql

 9  d + (a + (b - c)), d + (a - (b + c)), -- ditto
10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto
15

Operators should be preceded by a space

sql/pkg/semp.sql

 9  d + (a + (b - c)), d + (a - (b + c)), -- ditto
10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto
15

Operators should be followed by a space

sql/pkg/semp.sql

 9  d + (a + (b - c)), d + (a - (b + c)), -- ditto
10  d - ((a + b) - c), d - ((a - b) + c), -- ditto
11  d - (a + (b - c)), d - (a - (b + c)), -- ditto
12  ((a1/a2)/(b/c))/((d/e)/f),            -- ditto13  (a+b)*(c*d),                 -- mixed precedence
14  a+(b*c), (a+b)*c             -- ditto
15

Description

Operators should be surrounded by a single whitespace. Please remove the extra whitespaces.

Bad practice

In this example, there is a space missing space between the operator and ‘b’.

SELECT
    a +b
FROM foo

QuackatronHQ / Gigarepo

Bad practice

Recommended