ALTER TABLE ADD FOREIGN KEY fails on Table Schema #1156

manticore-projects · 2021-04-13T00:54:00Z

Valid at least in H2 and Oracle:

-- ALTER TABLE ADD FOREIGN KEY
ALTER TABLE cfe.ledger_acc_entry_manual
ADD FOREIGN KEY (id_manual_posting_batch) REFERENCES cfe.manual_posting_batch(id_manual_posting_batch);

net.sf.jsqlparser.JSQLParserException: Encountered unexpected token: "." "."
    at line 2, column 57.

Was expecting one of:

    "("
    ","
    ";"
    <EOF>

	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:188)
	at net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(CCJSqlParserUtil.java:176)

I will try to fix it in the JavaCC Parser and send a PR.

…ference Add a specific test case

manticore-projects · 2021-04-13T03:52:23Z

Fixed in PR #1153.

* Implement Oracle Hints for INSERT, UPDATE, MERGE, DELETE * Correct CreateIndex TailOptions Add a Test Case for CreateIndex TailOptions * Add WHERE expression to MergeInsert Add test case for MergeInsert WHERE expression * Fix Issue #1156: ALTER TABLE ADD FOREIGN KEY with schema reference Add a specific test case

@SuppressWarnings

* Implement Oracle Hints for INSERT, UPDATE, MERGE, DELETE * Correct CreateIndex TailOptions Add a Test Case for CreateIndex TailOptions * Add WHERE expression to MergeInsert Add test case for MergeInsert WHERE expression * Fix Issue #1156: ALTER TABLE ADD FOREIGN KEY with schema reference Add a specific test case * Fix Issue #1157: Oracle does not accept COLUMN keyword in ALTER TABLE ADD/MODIFY Correct the test cases accepting a non existing COLUMN keyword Add a specific test cases * Fix Issue #1164 UNIQUE after PRIMARY KEY Add test case for UNIQUE after PRIMARY KEY * Switch of warnings for un-fixble method namings * Switch of warnings for un-fixble method namings * Activate PMD and define our own ruleset * Execute PMD before building/testing in order to fail early * Fix 63 PMD warnings * Activate rule "PMD.CyclomaticComplexity" in order to simulate the Codazy checks Apply @SuppressWarnings({"PMD.CyclomaticComplexity"}) where this rule throws an unavoidable warning (especially for toString() and deparse()) * Activate rule , "PMD.ExcessiveMethodLength" in order to simulate the Codazy checks Apply @SuppressWarnings({"PMD.ExcessiveMethodLength"}) where this rule throws an unavoidable warning (especially for toString() and deparse()) Refactor an ENUM name * Refactor an ENUM name and reflect this also in the JavaCC Parser definition file

@SuppressWarnings

* javadoc-fixes * fix check-style error : assignment to parameter not allowed * import for javadoc reference * javadoc - add description to parameter "fqn" (fix warning) * remove doclint=none, but exclude package with exclude package with generated sources (javacc/jjtree) from javadoc * Implement Oracle Hints for INSERT, UPDATE, MERGE, DELETE * Correct CreateIndex TailOptions Add a Test Case for CreateIndex TailOptions * Add WHERE expression to MergeInsert Add test case for MergeInsert WHERE expression * Fix Issue #1156: ALTER TABLE ADD FOREIGN KEY with schema reference Add a specific test case * Fix Issue #1157: Oracle does not accept COLUMN keyword in ALTER TABLE ADD/MODIFY Correct the test cases accepting a non existing COLUMN keyword Add a specific test cases * Fix Issue #1164 UNIQUE after PRIMARY KEY Add test case for UNIQUE after PRIMARY KEY * Switch of warnings for un-fixble method namings * Switch of warnings for un-fixble method namings * Activate PMD and define our own ruleset * Execute PMD before building/testing in order to fail early * Fix 63 PMD warnings * Activate rule "PMD.CyclomaticComplexity" in order to simulate the Codazy checks Apply @SuppressWarnings({"PMD.CyclomaticComplexity"}) where this rule throws an unavoidable warning (especially for toString() and deparse()) * Activate rule , "PMD.ExcessiveMethodLength" in order to simulate the Codazy checks Apply @SuppressWarnings({"PMD.ExcessiveMethodLength"}) where this rule throws an unavoidable warning (especially for toString() and deparse()) Refactor an ENUM name * Refactor an ENUM name and reflect this also in the JavaCC Parser definition file Co-authored-by: gitmotte <www@synbee.at>

manticore-projects added a commit to manticore-projects/JSqlParser that referenced this issue Apr 13, 2021

Fix Issue JSQLParser#1156: ALTER TABLE ADD FOREIGN KEY with schema re…

805c951

…ference Add a specific test case

wumpz closed this as completed Apr 16, 2021

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

ALTER TABLE ADD FOREIGN KEY fails on Table Schema #1156

ALTER TABLE ADD FOREIGN KEY fails on Table Schema #1156

manticore-projects commented Apr 13, 2021

manticore-projects commented Apr 13, 2021

ALTER TABLE ADD FOREIGN KEY fails on Table Schema #1156

ALTER TABLE ADD FOREIGN KEY fails on Table Schema #1156

Comments

manticore-projects commented Apr 13, 2021

manticore-projects commented Apr 13, 2021