Skip to content
This repository has been archived by the owner on Jul 6, 2022. It is now read-only.

[VSCODE] Should Preserve the Space between OR and REPLACE SQL Keywords #87

Open
dulara1994 opened this issue May 17, 2022 · 1 comment
Labels
vscode Related to the VSCode Extension

Comments

@dulara1994
Copy link

Describe the bug
It removes the space between OR and REPLACE. in other words it converts OR REPLACE to ORREPLACE

To Reproduce

Try to format something like this one.
CREATE OR REPLACE FUNCTION "public" . "set_current_timestamp_updated_at"() RETURNS TRIGGER AS $$

Expected behavior
It should preserve the space between the OR and REPLACE Keywords. which should remain two words.

Screenshots

Peek 2022-05-17 07-09

Usage

  • Occurred with PostgreSQL, Not sure about other SQL standards
  • VSCode version? Version 1.66.2
  • What are your currently configured VSCode settings for the prettier-sql extension, if relevant to the issue?

// following setting is under the settings.json file. but no entry with the key "prettier-sql"
"[plsql]": {
"editor.defaultFormatter": "inferrinizzard.prettier-sql-vscode"
},

Additional context
Pl. comment if you need anything specific to hunt this bug.

@dulara1994 dulara1994 added the vscode Related to the VSCode Extension label May 17, 2022
@prnsantos
Copy link

If you add this option on your settings - json:
"Prettier-SQL.breakBeforeBooleanOperator": true
it will solve the problem

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
vscode Related to the VSCode Extension
Projects
None yet
Development

No branches or pull requests

2 participants