vscode-sqltools icon indicating copy to clipboard operation
vscode-sqltools copied to clipboard

Formatter breaks the postgres timescaledb => syntax

Open msdrigg opened this issue 2 years ago • 1 comments

Describe the bug The formatter breaks the timescaledb => syntax. This may be standard postgres syntax, but I have only seen it in timescaledb's documentation (https://docs.timescale.com/timescaledb/latest/how-to-guides/continuous-aggregates/create-a-continuous-aggregate/#creating-a-continuous-aggregate).

To Reproduce Steps to reproduce the behavior:

  1. Create a test.sql document and add this function
SELECT add_continuous_aggregate_policy('conditions_summary_daily',
     start_offset => INTERVAL '1 month',
     end_offset => INTERVAL '1 day',
     schedule_interval => INTERVAL '1 hour');
  1. Format the document with sqltools
  2. Notice that the arrows => are changed to = >
  3. Try to run the formatted document in timescaledb and verify that there are syntax errors

Expected behavior Arrows don't change (or have some configuration to prevent arrows from changing)

Desktop (please complete the following information):

  • SQLTools Version v0.23.0

msdrigg avatar Dec 13 '21 19:12 msdrigg

See also #764

gjsjohnmurray avatar Aug 13 '22 04:08 gjsjohnmurray