Skip to content

Error in neovim with minimal setupΒ #236

@vitorf7

Description

@vitorf7

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions