[ http://issues.apache.org/jira/browse/DERBY-2053?page=all ]
Rick Hillegas updated DERBY-2053:
---------------------------------
Fix Version/s: 10.2.3.0
(was: 10.2.2.0)
Move to 10.2.3.0.
> 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.3.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
