FOREIGN KEY syntax

[Cr0s]

Can you provide a BNF grammar for FOREIGN KEY syntax? I getting parser exception on this query:

CREATE TABLE IF NOT EXISTS table1 (
   id INTEGER PRIMARY KEY AUTO_INCREMENT,
   aid INTEGER REFERENCES accounts ON aid ON DELETE CASCADE,
   name STRING,
   lastname STRING)

[wumpz]

The implementation is quite hacky. There are so many different constructs within create table. I will look into it. BTW I discovered a problem generating the java site which should generate a BNF like grammar using mavens JavaCC plugin.

[Cr0s]

Thanks! Can you also add ON UPDATE/DELETE <ACTION>?
<ACTION> means CASCADE, SET NULL, RESTRICT

I have the same problem. Any workarounds?

[wumpz]

This should be solved. Which version do you use?

I am using version 0.9.4, running
CCJSqlParserUtil.parse("CREATE TABLE SC(STID INT,COID INT,GRADE INT) FOREIGN KEY STID REFERENCES S ON DELETE CASCADE ON UPDATE CASCADE"); gives me JSQLParserException. It's probably irrelevant to this thread because I guess the exception is because of the foreign key option being outside the parenthesis but from what I know it's still a valid SQL statement.

[pabloa]

I fixed this. Now jsqlparser accepts on column1 ... ON UPDATE/DELETE NO ACTION/CASCADE. I do not see the git revision number though. Let me check if I uploaded this patch

[pabloa]

Yes, it is in this pull request: #210