db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ASF subversion and git services (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DERBY-6316) Small typos in devguide examples
Date Tue, 27 Aug 2013 13:15:55 GMT

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

ASF subversion and git services commented on DERBY-6316:
--------------------------------------------------------

Commit 1517808 from [~chaase3] in branch 'docs/trunk'
[ https://svn.apache.org/r1517808 ]

DERBY-6316  Small typos in devguide examples 

Modified 2 Developer's Guide topics.

Patch: DERBY-6316.diff
                
> 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