JSqlParser icon indicating copy to clipboard operation
JSqlParser copied to clipboard

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

Open LuckyLXX opened this issue 1 year ago • 1 comments

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>

LuckyLXX avatar Jul 16 '24 07:07 LuckyLXX

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.

manticore-projects avatar Jul 17 '24 02:07 manticore-projects