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] Created: (DERBY-2053) Dev Guide: Syntax errors in SQL tips -> Tricks of the VALUES clause -> Multiple rows
Date Wed, 08 Nov 2006 10:12:52 GMT
Dev Guide: Syntax errors in SQL tips -> Tricks of the VALUES clause -> Multiple rows
------------------------------------------------------------------------------------

                 Key: DERBY-2053
                 URL: http://issues.apache.org/jira/browse/DERBY-2053
             Project: Derby
          Issue Type: Bug
          Components: Documentation
    Affects Versions: 10.2.1.6, 10.1.3.1, 10.3.0.0
         Environment: N/A
            Reporter: John H. Embretsen
            Priority: Minor
             Fix For: 10.2.2.0


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.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message