With this new config parameter you are able to skip white spaces before and after block parentheses.
For example
Without this parameter:
CREATE VIEW sakila.v_exampl (customer, phone, title) AS select concat(sakila.customer.last_name,', ',sakila.customer.first_name) AS customer,sakila.address.phone AS phone,sakila.film.title AS title from ((((sakila.rental join sakila.customer on((sakila.rental.customer_id = sakila.customer.customer_id))) join sakila.address on((sakila.customer.address_id = sakila.address.address_id))) join sakila.inventory on((sakila.rental.inventory_id = sakila.inventory.inventory_id))) join sakila.film on((sakila.inventory.film_id = sakila.film.film_id))) where ((sakila.rental.return_date is null) and ((sakila.rental.rental_date + interval sakila.film.rental_duration day) < curdate())) order by sakila.film.title limit 5
Result:
CREATE VIEW sakila.v_exampl (customer, phone, title) AS
select
concat(
sakila.customer.last_name,
', ',
sakila.customer.first_name
) AS customer,
sakila.address.phone AS phone,
sakila.film.title AS title
from
(
(
(
(
sakila.rental
join sakila.customer on(
(
sakila.rental.customer_id = sakila.customer.customer_id
)
)
)
join sakila.address on(
(
sakila.customer.address_id = sakila.address.address_id
)
)
)
join sakila.inventory on(
(
sakila.rental.inventory_id = sakila.inventory.inventory_id
)
)
)
join sakila.film on((sakila.inventory.film_id = sakila.film.film_id))
)
where
(
(sakila.rental.return_date is null)
and (
(
sakila.rental.rental_date + interval sakila.film.rental_duration day
) < curdate()
)
)
order by
sakila.film.title
limit
5

With this new parameter
CREATE VIEW sakila.v_exampl (customer, phone, title) AS
select
concat(sakila.customer.last_name,
', ',
sakila.customer.first_name)AS customer,
sakila.address.phone AS phone,
sakila.film.title AS title
from
((((sakila.rental
join sakila.customer on((sakila.rental.customer_id = sakila.customer.customer_id)))
join sakila.address on((sakila.customer.address_id = sakila.address.address_id)))
join sakila.inventory on((sakila.rental.inventory_id = sakila.inventory.inventory_id)))
join sakila.film on((sakila.inventory.film_id = sakila.film.film_id)))
where
((sakila.rental.return_date is null)
and ((sakila.rental.rental_date + interval sakila.film.rental_duration day)< curdate()))
order by
sakila.film.title
limit
5