new format config for skipping white spaces before and after block pa…
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