[DERBY-2053] Dev Guide: Syntax errors in SQL tips -> Tricks of the VALUES clause -> Multiple rows

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.1.3.1, 10.2.1.6, 10.3.1.4
• Fix Version/s: 10.3.1.4
• Component/s: Documentation
• Environment: N/A
• Urgency: Normal
• Assignee: John Embretsen
• Reporter: John Embretsen
• Created: 08/Nov/06 10:11
• Updated: 18/May/07 07:11
• Resolved: 16/May/07 22:38

Description

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.