Determines when to break lists of items (e.g. columns in SELECT
clause) to multiple lines.
"always"
(default) always breaks to multiple lines (even when just a single item)."avoid"
avoids breaking to multiple lines, regardless of item count or line length.number
breaks to multiple lines when there are more items than the specified number."expressionWidth"
breaks to multiple lines when the line would exceed value ofexpressionWidth
option.
SELECT
first_name,
last_name,
occupation,
age
FROM
persons
GROUP BY
age,
occupation
SELECT first_name, last_name, occupation, age
FROM persons
GROUP BY age, occupation
But switches to multiple lines when CASE expression is seen:
SELECT
first_name,
CASE sex
WHEN 'F' THEN 'ms'
WHEN 'M' THEN 'mr'
END AS title
FROM persons
GROUP BY age, occupation
Using multilineLists: 1
:
SELECT
first_name,
last_name,
occupation,
age
FROM persons
GROUP BY
age,
occupation
Using multilineLists: 2
:
SELECT
first_name,
last_name,
occupation,
age
FROM persons
GROUP BY age, occupation
Using multilineLists: 4
:
SELECT first_name, last_name, occupation, age
FROM persons
GROUP BY age, occupation
Using multilineLists: "expressionWidth", expressionWidth: 13
:
SELECT
first_name,
last_name,
occupation,
age
FROM persons
GROUP BY
age,
occupation
Using multilineLists: "expressionWidth", expressionWidth: 15
:
SELECT
first_name,
last_name,
occupation,
age
FROM persons
GROUP BY age, occupation
Using multilineLists: "expressionWidth", expressionWidth: 50
:
SELECT first_name, last_name, occupation, age
FROM persons
GROUP BY age, occupation