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

[ https://issues.jboss.org/browse/TEIID-2110?page=com.atlassian.jira.plugin... ] 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} -- 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