db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John H. Embretsen (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2053) Dev Guide: Syntax errors in SQL tips -> Tricks of the VALUES clause -> Multiple rows
Date Tue, 15 May 2007 09:25:16 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

John H. Embretsen updated DERBY-2053:

    Attachment: d2053_v1.diff

Attaching doc patch (d2053_v1.diff) and resulting HTML output which fixes the issues mentioned
in the description of this issue. The only modified file is src/devguide/cdevtricks807337.dita.

I'd like to get this small fix included in the 10.3 release. Please review/commit.

> Dev Guide: Syntax errors in SQL tips -> Tricks of the VALUES clause -> Multiple
> ------------------------------------------------------------------------------------
>                 Key: DERBY-2053
>                 URL: https://issues.apache.org/jira/browse/DERBY-2053
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions:,,
>         Environment: N/A
>            Reporter: John H. Embretsen
>         Assigned To: John H. Embretsen
>            Priority: Minor
>         Attachments: cdevtricks807337.html, d2053_v1.diff
> In the "Derby Developer's Guide" manual, there is a page entitled "Multiple rows", under
section "SQL tips" and subsection "Tricks of the VALUES clause", see
> http://db.apache.org/derby/docs/dev/devguide/cdevtricks807337.html
> for the current alpha/trunk version.
> This page contains an SQL/IJ example with syntax errors:
>     -- send 5 rows at a time:
>     PREPARE p1 AS 'INSERT INTO ThreeColumnTable VALUES 
>     (?,?,?), (?,?,?), (?,?,?), (?,?,?), (?,?,?)
>     EXECUTE p1 USING 'VALUES (''1st'',1,1,''2nd'',2,2''3rd'',
>     3,3,''4th'',4,4,''5th'',5,5)'
> Errors are:
> * The PREPARE command will fail because of a missing end quote (').
> * The EXECUTE command will fail because of a missing comma, between ,2,2 and "3rd".
> * Since this is an IJ example (although that may not be immediately clear to all readers;
"ij> " should be added in front of each command), both commands lack a semicolon (;) at
the end.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message