Repository navigation
[FEATURE] Support for CockroachDB #1743
Description
Grammar or Syntax Description
Can support be added for CockroachDB? It is based on Postgres however there are a few differences which means there are some SQL statements that are considered valid.
SQL Example
Example of missing SQL is the "USING" statement for https://www.cockroachlabs.com/docs/v22.1/hash-sharded-indexes
ALTER TABLE FEATURE_SWITCH_CONFIG ALTER PRIMARY KEY USING COLUMNS (FEATURE_NAME) USING HASH
Caused by: net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "USING" "USING"
at line 1, column 53.
Additional context
Tested in version 4.5
Activity
manticore-projects commentedon Mar 11, 2023
Greetings.
Unfortunately the whole
ALTER TABLEstatement needs a serious refactoring.ALTER TABLE ... ALTER PRIMARY KEY ...seems to be completely broken to me, not only regarding to your specific syntax.This thing is so messy, that I would only touch it when a sponsor shows up.
We could maybe start with a SQL:2016 compliant implementation from scratch.