[teiid-issues] [JBoss JIRA] (TEIID-2110) Error in Documentation: CREATE TRIGGER
[
https://issues.jboss.org/browse/TEIID-2110?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-2110:
----------------------------------
Attachment: SQLParser.bnf
The data type bnf is
{code}
parseDataType ::= ( <STRING> ( <LPAREN> intVal <RPAREN> )? ) | (
<VARCHAR> ( <LPAREN> intVal <RPAREN> )? ) | <BOOLEAN> |
<BYTE> | <TINYINT> | <SHORT> | <SMALLINT> | ( <CHAR> (
<LPAREN> intVal <RPAREN> )? ) | <INTEGER> | <LONG> |
<BIGINT> | ( <BIGINTEGER> ( <LPAREN> intVal <RPAREN> )? ) |
<FLOAT> | <REAL> | <DOUBLE> | ( <BIGDECIMAL> ( <LPAREN>
intVal ( <COMMA> intVal )? <RPAREN> )? ) | ( <DECIMAL> ( <LPAREN>
intVal ( <COMMA> intVal )? <RPAREN> )? ) | <DATE> | <TIME> |
<TIMESTAMP> | <OBJECT> | ( <BLOB> ( <LPAREN> intVal <RPAREN>
)? ) | ( <CLOB> ( <LPAREN> intVal <RPAREN> )? ) | ( <VARBINARY> (
<LPAREN> intVal <RPAREN> )? ) | <XML>
{code}
The full output is attached also.
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
Attachments: SQLParser.bnf
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