[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=12710779#comment-12710779 ] 

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

Steve, This one looks little promising http://karmin.ch/ebnf/index

This is a PHP script, that can run standalone. I downloaded it and generated the data types image, see attached. However it needs metadata in EBNF, the above data types when I manually edited it it looked like

{code}
"DataTypes" {dataType = 
( "STRING" ([" intVal " ] ) | 
( "VARCHAR" [" intVal " ] ) | 
"BOOLEAN" | 
"BYTE" | 
"TINYINT" | 
"SHORT" | 
"SMALLINT" | 
( "CHAR" [" intVal "] ) | 
"INTEGER" | 
"LONG" | 
"BIGINT" | 
( "BIGINTEGER" ([" intVal "] ) | 
"FLOAT" |
"REAL" | 
"DOUBLE" | 
( "BIGDECIMAL" [" intVal ["," intVal] "] ) | 
( "DECIMAL" [" intVal ([ "," intVal ]" ] ) | 
"DATE" | 
"TIME" | 
"TIMESTAMP" | 
"OBJECT" | 
( "BLOB" [" intVal "] ) | 
( "CLOB" [" intVal "] ) | 
( "VARBINARY" [" intVal "] ) | 
"XML".}
{code}

I am hoping we could even customize this little bit to serve our needs.
                
> 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