[teiid-issues] [JBoss JIRA] (TEIID-2110) Error in Documentation: CREATE TRIGGER

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2110?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12710496#comment-12710496 ] 

Steven Hawkins commented on TEIID-2110:
---------------------------------------

I've corrected those links.  Here's the updated BNF, but it's using the default production names and the <token> convention.

{code}
ddlStmt ::= ( createTable | createDDLProcedure | createNameSpace | createTrigger ) ( <SEMICOLON> )?

createNameSpace ::= <SET> <NAMESPACE> stringVal <AS> id

createDDLProcedure ::= <CREATE> ( <VIRTUAL> | <FOREIGN> )? ( <PROCEDURE> | <FUNCTION> ) ( id <LPAREN> ( procedureParameter )? ( <COMMA> procedureParameter )* <RPAREN> ( <RETURNS> ( ( ( <TABLE> )? <LPAREN> procedureRsColumn ( <COMMA> procedureRsColumn )* <RPAREN> ) | parseDataType ) )? ( optionsClause )? ( <AS> statement )? )

procedureParameter ::= ( <IN> | <OUT> | <INOUT> )? id parseDataType ( <NOT> <NULL> )? ( <RESULT> )? ( <DEFAULT_KEYWORD> stringVal )? ( optionsClause )?

procedureRsColumn ::= id parseDataType ( <NOT> <NULL> )? ( optionsClause )?

createTable ::= <CREATE> ( <FOREIGN> <TABLE> | ( <VIRTUAL> )? <VIEW> ) id ( <LPAREN> createColumn ( <COMMA> createColumn )* ( <CONSTRAINT> ( primaryKeys | constraints | foreignKeys ) ( <COMMA> ( primaryKeys | constraints | foreignKeys ) )* )? <RPAREN> )? ( optionsClause )? ( <AS> queryExpression )?

foreignKeys ::= <FOREIGN> <KEY> getColumnNames <REFERENCES> id ( getColumnNames )? ( optionsClause )?

primaryKeys ::= <PRIMARY> <KEY> ( optionsClause )?

constraints ::= ( <UNIQUE> | <INDEX> | <ACCESSPATTERN> ) ( optionsClause )?

getColumnNames ::= <LPAREN> id ( <COMMA> id )* <RPAREN>

createColumn ::= id parseDataType ( <NOT> <NULL> )? ( <UNIQUE> | ( <INDEX> | <AUTO_INCREMENT> )+ | ( <PRIMARY> <KEY> ) )? ( <DEFAULT_KEYWORD> stringVal )? ( optionsClause )?

optionsClause ::= <OPTIONS> <LPAREN> optionPair ( <COMMA> optionPair )* <RPAREN>

optionPair ::= id ( nonNumericLiteral | ( plusMinus )? unsignedNumericLiteral )
{code}
                
> Error in Documentation: CREATE TRIGGER
> --------------------------------------
>
>                 Key: TEIID-2110
>                 URL: https://issues.jboss.org/browse/TEIID-2110
>             Project: Teiid
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 8.0
>            Reporter: Andriy Rokhmanov
>            Assignee: Ramesh Reddy
>            Priority: Minor
>             Fix For: 8.1
>
>
> https://docs.jboss.org/author/display/TEIID/DDL+Metadata
> Section "INSTEAD OF TRIGGERS" (both Example and Diagram):
> Now:
> CREATE TRIGGER ON CustomerOrders INSTEAD OF INSERT
>    FOR EACH ROW...
> Should be:
> CREATE TRIGGER ON CustomerOrders INSTEAD OF INSERT
>    AS FOR EACH ROW...

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira