Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

oracle 解析 alter add (CONSTRAINT) 语句失败 #5969

Open
serendipity2223 opened this issue Jun 7, 2024 · 0 comments
Open

oracle 解析 alter add (CONSTRAINT) 语句失败 #5969

serendipity2223 opened this issue Jun 7, 2024 · 0 comments

Comments

@serendipity2223
Copy link

serendipity2223 commented Jun 7, 2024

durid版本: 1.2.23

alter table POLL_JOB_DETAILS add (

SCHED_NAME VARCHAR2(120) DEFAULT 'OCS_SCHEDULER' NOT NULL,

IS_NONCONCURRENT VARCHAR2(1) default 'N' NOT NULL,

IS_UPDATE_DATA VARCHAR2(1) default 'N'  NOT NULL,

CONSTRAINT POLL_JOB_DETAILS_PK PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)

);

Exception in thread "main" com.alibaba.druid.sql.parser.ParserException: illegal name, pos 225, line 9, column 5, token CONSTRAINT
	at com.alibaba.druid.sql.parser.SQLExprParser.name(SQLExprParser.java:2527)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleExprParser.name(OracleExprParser.java:1123)
	at com.alibaba.druid.sql.parser.SQLExprParser.parseColumn(SQLExprParser.java:4802)
	at com.alibaba.druid.sql.parser.SQLExprParser.parseColumn(SQLExprParser.java:4788)
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseAlterTableAddColumn(SQLStatementParser.java:4890)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser.parseAlterTable(OracleStatementParser.java:1560)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser.parserAlter(OracleStatementParser.java:1324)
	at com.alibaba.druid.sql.dialect.oracle.parser.OracleStatementParser.parseStatementList(OracleStatementParser.java:147)
	at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:106)
	at com.cyzhao.druidtest.DuridTest.main(DuridTest.java:683)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant