felipebz / zpa

Parser and static code analysis tool for PL/SQL and Oracle SQL.
https://zpa.felipebz.com
GNU Lesser General Public License v3.0
211 stars 77 forks source link

Getting unable to parse error when used ENABLE keyword in Create Table statement #149

Open jagdish9 opened 3 years ago

jagdish9 commented 3 years ago

Hi,

I used ENABLE keyword in CREATE TABLE statement as below

CREATE TABLE TPA_MASTER (
CONFIGID VARCHAR2(100 BYTE) PRIMARY KEY ENABLE, NO_OF_PWD_ATTEMPTS NUMBER, SESSION_TIME_DURATION NUMBER NOT NULL ENABLE, PWD_EXPIRY_PERIOD NUMBER, SUSPECT_COUNT NUMBER NOT NULL ENABLE, SUSPECT_FREQUENCY NUMBER NOT NULL ENABLE, NO_RULE_FREQUENCY NUMBER NOT NULL ENABLE )

But getting below Parse Error.

org.sonar.plugins.plsqlopen.api.sslr.RecognitionException: Parse error at line 17 column 50:

11: first_name VARCHAR2(42) NOT NULL, 12: last_name VARCHAR2(42) NOT NULL 13: ); 14: 15: CREATE TABLE TPA_MASTER 16: ( --> CONFIGID VARCHAR2(100 BYTE) PRIMARY KEY ENABLE, 18: NO_OF_PWD_ATTEMPTS NUMBER, 19: SESSION_TIME_DURATION NUMBER NOT NULL ENABLE, 20: PWD_EXPIRY_PERIOD NUMBER, 21: SUSPECT_COUNT NUMBER NOT NULL ENABLE, 22: SUSPECT_FREQUENCY NUMBER NOT NULL ENABLE, 23: NO_RULE_FREQUENCY NUMBER NOT NULL ENABLE

when i removed ENABLE keyword, it works fine.

Can you please review and provide your feedback.

Thanks.