db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6316) Small typos in devguide examples
Date Tue, 27 Aug 2013 07:38:51 GMT

    [ https://issues.apache.org/jira/browse/DERBY-6316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13751059#comment-13751059
] 

Knut Anders Hatlen commented on DERBY-6316:
-------------------------------------------

Thanks for fixing them, Kim. The changes look good to me. +1 to commit.
                
> Small typos in devguide examples
> --------------------------------
>
>                 Key: DERBY-6316
>                 URL: https://issues.apache.org/jira/browse/DERBY-6316
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.10.1.1
>            Reporter: Knut Anders Hatlen
>            Assignee: Kim Haase
>            Priority: Trivial
>         Attachments: DERBY-6316.diff, DERBY-6316.stat, DERBY-6316.zip
>
>
> I came across two examples with small typos in the developer's guide.
> http://db.apache.org/derby/docs/10.10/devguide/cdevspecial41728.html:
> try {
>     preparedStatement.execute();
> } catch (SQLException se ) {
>         String SQLState = se.getSQLState();
>     if ( SQLState.equals( "23505" ) ) 
>         { correctDuplicateKey(); }
>     else if ( SQLState.equals( "22003" ) ) {    
>         correctArithmeticOverflow(); }
>     else { throw se; }
> }
> Here, the first line in the catch block is not at the same indentation level as the other
statements in the block.
> http://db.apache.org/derby/docs/10.10/devguide/cdevspecial53165.html:
> CREATE TRIGGER . . .
> DELETE FROM flightavailability 
> 	WHERE flight_id IN (SELECT flight_id FROM flightavailability 
> 		WHERE YEAR(flight_date) < 2005);) 
> This example has an unmatched closing parenthesis. And even if it were matched, it should
have come before the semicolon.
> (By the way, should the semicolon be kept or removed? Derby's SQL dialect doesn't accept
statements that end with a semicolon, but ij does.)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message