sql-language-server icon indicating copy to clipboard operation
sql-language-server copied to clipboard

Error in neovim with minimal setup

Open vitorf7 opened this issue 2 years ago • 1 comments

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

vitorf7 avatar Nov 15 '23 17:11 vitorf7

Same here, is the project abandoned ?

guilty-p01nt3r avatar Sep 17 '24 16:09 guilty-p01nt3r