You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "John H. Embretsen (JIRA)" <ji...@apache.org> on 2006/11/08 11:12:52 UTC
[jira] Created: (DERBY-2053) Dev Guide: Syntax errors in SQL tips
-> Tricks of the VALUES clause -> Multiple rows
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
[jira] Updated: (DERBY-2053) Dev Guide: Syntax errors in SQL tips
-> Tricks of the VALUES clause -> Multiple rows
Posted by "John H. Embretsen (JIRA)" <ji...@apache.org>.
[ 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
cdevtricks807337.html
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 rows
> ------------------------------------------------------------------------------------
>
> Key: DERBY-2053
> URL: https://issues.apache.org/jira/browse/DERBY-2053
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.3.0.0
> 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.
[jira] Assigned: (DERBY-2053) Dev Guide: Syntax errors in SQL tips
-> Tricks of the VALUES clause -> Multiple rows
Posted by "John H. Embretsen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John H. Embretsen reassigned DERBY-2053:
----------------------------------------
Assignee: John H. Embretsen
> Dev Guide: Syntax errors in SQL tips -> Tricks of the VALUES clause -> Multiple rows
> ------------------------------------------------------------------------------------
>
> Key: DERBY-2053
> URL: https://issues.apache.org/jira/browse/DERBY-2053
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.3.0.0
> Environment: N/A
> Reporter: John H. Embretsen
> Assigned To: John H. Embretsen
> Priority: Minor
>
> 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.
[jira] Resolved: (DERBY-2053) Dev Guide: Syntax errors in SQL tips
-> Tricks of the VALUES clause -> Multiple rows
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen resolved DERBY-2053.
---------------------------------------
Resolution: Fixed
Derby Info: (was: [Patch Available])
Looks good to me, except that the missing semicolons have not been added. I went ahead and added the semicolons and committed the patch with revision 538767. I also pasted the commands into an ij window, and they were executed just fine. Thanks John!
> Dev Guide: Syntax errors in SQL tips -> Tricks of the VALUES clause -> Multiple rows
> ------------------------------------------------------------------------------------
>
> Key: DERBY-2053
> URL: https://issues.apache.org/jira/browse/DERBY-2053
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.3.0.0
> Environment: N/A
> Reporter: John H. Embretsen
> Assigned To: John H. Embretsen
> Priority: Minor
> Fix For: 10.3.0.0
>
> 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.
[jira] Updated: (DERBY-2053) Dev Guide: Syntax errors in SQL tips
-> Tricks of the VALUES clause -> Multiple rows
Posted by "John H. Embretsen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John H. Embretsen updated DERBY-2053:
-------------------------------------
Derby Info: [Patch Available]
Fix Version/s: 10.3.0.0
> Dev Guide: Syntax errors in SQL tips -> Tricks of the VALUES clause -> Multiple rows
> ------------------------------------------------------------------------------------
>
> Key: DERBY-2053
> URL: https://issues.apache.org/jira/browse/DERBY-2053
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.3.0.0
> Environment: N/A
> Reporter: John H. Embretsen
> Assigned To: John H. Embretsen
> Priority: Minor
> Fix For: 10.3.0.0
>
> 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.
[jira] Updated: (DERBY-2053) Dev Guide: Syntax errors in SQL tips
-> Tricks of the VALUES clause -> Multiple rows
Posted by "Rick Hillegas (JIRA)" <ji...@apache.org>.
[ 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
[jira] Closed: (DERBY-2053) Dev Guide: Syntax errors in SQL tips ->
Tricks of the VALUES clause -> Multiple rows
Posted by "John H. Embretsen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
John H. Embretsen closed DERBY-2053.
------------------------------------
Thanks Knut Anders - I don't know how I managed not to include the semicolons in the patch... thank you for adding them and committing! Verified the fix in the online html docs.
> Dev Guide: Syntax errors in SQL tips -> Tricks of the VALUES clause -> Multiple rows
> ------------------------------------------------------------------------------------
>
> Key: DERBY-2053
> URL: https://issues.apache.org/jira/browse/DERBY-2053
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.1.3.1, 10.2.1.6, 10.3.0.0
> Environment: N/A
> Reporter: John H. Embretsen
> Assigned To: John H. Embretsen
> Priority: Minor
> Fix For: 10.3.0.0
>
> 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.