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