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

[Ramesh Reddy (JIRA)]

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

Ramesh Reddy commented on TEIID-2110:
-------------------------------------

Steve, Here is BNF for http://railroad.my28msec.com site I ended up with, can you check once?

{code}
createNameSpace ::=  "SET" "NAMESPACE" "{uri}" "AS" "{prefix}"

createTrigger ::=   "CREATE" "TIGGER" "ON" "{view_name}" "INSTEAD OF"  ( "INSERT" | "UPDATE"  | "DELETE" )  "AS" "FOR EACH ROW" ("BEGIN" ("ATOMIC")? (statement)* "END")

createFunction ::=  "CREATE" (("VIRTUAL" | "FOREIGN")? "FUNCTION") "{function_name}" "(" ("{param_name}" dataType ("NOT NULL")? ("DEFAULT {value}") (options)?)* ")" "RETURNS" dataType (options)?

createProcedure ::=  "CREATE" (("VIRTUAL" | "FOREIGN")? "PROCEDURE") "{procedure_name}" "(" (("IN"|"INOUT"|"OUT")? "{param_name}" dataType ("NOT NULL")? ("RESULT")? ("DEFAULT {value}") (options)?)* ")"  "RETURNS" ( ("TABLE")? "(" ("{column_name}" dataType ("NOT NULL")?)+ (options)? ")" | dataType) (options )? ("AS" statement)?

createTable ::=  "CREATE" "FOREIGN TABLE" "{table_name}"  "(" (createColumn)+  (constraints)? ")"  (options)?

createView ::=  "CREATE" ("VIRTUAL")? "VIEW" "{view_name}"  "(" (createColumn)+  (constraints)? ")"  (options)? "AS" statement

createColumn ::= "column_name" dataType ("NOT NULL")?  ((("AUTO_INCREMNET" | "INDEX")+|"UNIQUE") | ("PRIMARY KEY"))? ("DEFAULT" "{value}")? (options)?

constraints ::= "CONSTRAINT" ((("ACCESSPATTERN"  "(" "{column_names}" ")")? | (("INDEX"|"UNIQUE") "(" "{column_names}" ")")? | ("PRIMARY KEY" "(" "{column_names}" ")")? | ("FOREIGN KEY" "(" "{column_names}" ")" "REFERENCES" "{view-name}" "(" "{column_names}" ")")? ) (options)?)*

options ::= ("OPTIONS" "(" "{options}" ")")

dataType ::= ("varchar"|"boolean"|"byte"|"short"|"smallint"|"char"|"integer"|"long"|"float"|"double"|"decimal"|"date"|"time"|"timestamp"|"clob"|"blob"|"xml"|"varbinary"|"object")
{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