CREATE OR REPLACE gets split

[jamesarosen]

sql-formatter splits CREATE OR REPLACE into two lines:

Input

CREATE OR REPLACE PROCEDURE myco.sp_refresh_foo_mv () LANGUAGE plpgsql AS $$
-- ...

Output

CREATE
OR REPLACE PROCEDURE myco.sp_refresh_foo_mv () LANGUAGE plpgsql AS $$
-- ...

Is this intentional? If so, what is the theory behind doing this?

[nene]

No. Not intentional. It's a bug.

[nene]

If you want to, you can submit a patch.

If you compare these lines:

• https://github.com/sql-formatter-org/sql-formatter/blob/master/src/languages/postgresql/postgresql.formatter.ts#L129
• https://github.com/sql-formatter-org/sql-formatter/blob/master/src/languages/postgresql/postgresql.formatter.ts#L137

it should be obvious what's missing from the CREATE PROCEDURE line.

[jamesarosen]

PR: #851