Comments (5)
Ok in that case we should probably reopen this one as well since there appear to be two separate issues in the same statement. The issue I originally reported was fixed in taozhi8833998/node-sql-parser#1372. Thanks for your help! Happy to test out a potential solution.
from tree-sitter-sql.
The SQL statement works fine for my:
Can you update the grammar on your machine?
from tree-sitter-sql.
Hmm. I am using the latest parser from nvim-treesitter
. I believe it is nvim-treesitter/nvim-treesitter@411e771. I'm not too familiar with how to update grammar directly. Can you clarify how I should do that?
from tree-sitter-sql.
I apologize the error appears to be coming from https://github.com/fannheyward/coc-sql and not tree-sitter-sql
from tree-sitter-sql.
OK, no problem. Upon further investigation, T-SQL seems to support to add multiple columns in one alter table statement (like in your screenshot).
This parse aims to be permissive and we mostly consider MySQL, MariaDB, PostgreSQL and a some Hive statements. These dialect do not support this style of altering tables.
If you want you can reopen it. I definately get an error for statements like:
alter table classname
add
col1 varchar(255) not null default('empty'),
col2 varchar(255) not null default('empty2');
The SQL in nvim-treesitter gets updated when you update the plugin. :TSUpdate
should also work.
from tree-sitter-sql.
Related Issues (20)
- Array dereference not supported
- Field expression not supported
- Additional dollar quote support HOT 2
- Highlighting queries rely on neovim-only `lua-match` HOT 4
- segfault HOT 16
- Scanner.c is missing on npm, therefore preventing the package installation HOT 3
- Include parser files in Release Assets HOT 5
- Syntax highlighting appears to give up in Postgres function bodies HOT 1
- Syntax highlighting breaks when using $ in VALUES HOT 4
- Invalid node type "keyword_without" on nightly HOT 2
- Cargo.toml missing on gh-pages branch HOT 3
- Trailing Comma - Snowflake HOT 4
- IGNORE NULLS breaks window function parsing HOT 1
- Support for check constraints HOT 1
- UNIQUE constraint not parsed correctly
- Cannot run in a macOS environment
- Support for COPY FROM STDIN HOT 10
- specific statement after a specific pg alter table is not parsed correctly HOT 4
- Improve partial query handling HOT 2
- Add backslashed single quotes to grammar HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tree-sitter-sql.