ORACLE: ALTER TABLE ... ADD CONSTRAINT ... with tablespace option unsupported

JSQLParser / JSqlParser

JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern

https://github.com/JSQLParser/JSqlParser/wiki

Apache License 2.0

5.32k stars 1.34k forks source link

ORACLE: ALTER TABLE ... ADD CONSTRAINT ... with tablespace option unsupported #2039

Open LuckyLXX opened 2 months ago

LuckyLXX commented 2 months ago

Software Information:

4.9+
oracle 19c

ALTER TABLE bfmcs.your_table 
ADD CONSTRAINT your_table_pk 
PRIMARY KEY (ID) using index tablespace your_tablespace;

net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "tablespace" "TABLESPACE" at line 1, column 88.

Was expecting one of:

","
<EOF>
<ST_SEMICOLON>

manticore-projects commented 2 months ago

Greetings,

the ALTER statements are lacking many RDBMS specific features and need a more or less complete rewrite. I myself have very limited interest in DDL statements and so you will need to provide or sponsor an implementation to make this happen.