joe-re / sql-language-server

SQL Language Server
MIT License
695 stars 64 forks source link

Error in neovim with minimal setup #236

Open vitorf7 opened 1 year ago

vitorf7 commented 1 year ago

I have installed sqlls via Mason and created my lsp settings file with the following configuration:

return {
  root_dir = function(_)
    return vim.loop.cwd()
  end,
}

Then when I opened a migration file from a go project I had the following error diagnostic: Expected "$", "(", "--", "/*", "ALTER", "CREATE TABLE", "CREATE", "DELETE", "DROP TABLE", "DROP", "INSERT", "REPLACE", "SELECT", "UPDATE", "WITH", "return", [ \t\n\r], or end of input but "B" found.

The migration file in question is as follows:

BEGIN;

  CREATE TABLE IF NOT EXISTS recordings (
    job_id UUID NOT NULL REFERENCES jobs (id),
    recording_id UUID NOT NULL,
    s3_recording_path string,
    s3_transcript_path string,
    updated_at TIMESTAMPTZ NOT NULL DEFAULT now() ON UPDATE now(),
    PRIMARY KEY (recording_id)
  );

END;

The DB is CockroachDB which is basically a slight flavour of Postgres

Also here are my neovim specs:

> nvim -V1 -v
NVIM v0.10.0-dev-1413+g684e93054-Homebrew
Build type: Release
LuaJIT 2.1.1699801871
guilty-p01nt3r commented 2 months ago

Same here, is the project abandoned ?