[jira] Commented: (DERBY-382) Doc Review (CLOSED TO FURTHER COMMENTS): Derby Reference Manual
[ http://issues.apache.org/jira/browse/DERBY-382?page=comments#action_12314834 ] Jeff Levitt commented on DERBY-382: --- Forgot to change the links in my posting template to point to the ref manual on my site: http://derby.mylevita.com/ref/refderby.pdf http://derby.mylevita.com/ref/ > Doc Review (CLOSED TO FURTHER COMMENTS): Derby Reference Manual > --- > > Key: DERBY-382 > URL: http://issues.apache.org/jira/browse/DERBY-382 > Project: Derby > Type: Improvement > Components: Documentation > Environment: all > Reporter: Jeff Levitt > Priority: Minor > Fix For: 10.1.1.0 > Attachments: derby382.diff > > This issue tracks comments for the Derby Reference Manual. The deadline for > posting comments was Tuesday, June 28, noon Pacific time. > PLEASE DO NOT POST ADDITIONAL COMMENTS TO THIS JIRA ISSUE. If you have > additional comments, please open a JIRA issue for a fixin in a future > release, as there is not enough time to incorporate additional comments. > Some guidelines to follow when posting comments to this issue are: > - Try to make clear and concise comments about what you want changed whenever > possible. Provide concrete comments that say "Please change to > " instead of generic comments like "This section needs to be > rewritten." > - If you're reviewing the HTML Files copy, include the URL for the page in > the review comment. Obtain the URL like this: > * highlight the topic in the left frame > * right click > * choose "Properties" > * copy and paste the address in the pop up box. > - If you're reviewing the PDF copy, in the review comment: > * Include the page number for the PDF, and indicate whether the number is > the PDF sheet number or the printed page number. > * Include the title of the section that the problem occurs in. If it's in > a subsection, try to include the hierarchy of titles. > - Please don't review the HTML Book copy -- it'll be time consuming to match > up that copy with the underlying DITA source. -- 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] Commented: (DERBY-382) Doc Review (CLOSED TO FURTHER COMMENTS): Derby Reference Manual
[ http://issues.apache.org/jira/browse/DERBY-382?page=comments#action_12314794 ] Jean T. Anderson commented on DERBY-382: CREATE FUNCTION at http://incubator.apache.org/derby/docs/ref/rrefcreatefunctionstatement.html doesn't show an example, because the example is nested under the "Function Element" link at http://incubator.apache.org/derby/docs/ref/rrefcrprofunctionelement.html . If we can un-nest terms in the "HTML files" view of the docs, then the CREATE FUNCTION example in DERBY-382 could move to the developer's guide as a complete example (later, not now). > Doc Review (CLOSED TO FURTHER COMMENTS): Derby Reference Manual > --- > > Key: DERBY-382 > URL: http://issues.apache.org/jira/browse/DERBY-382 > Project: Derby > Type: Improvement > Components: Documentation > Environment: all > Reporter: Jeff Levitt > Priority: Minor > Fix For: 10.1.1.0 > > This issue tracks comments for the Derby Reference Manual. The deadline for > posting comments was Tuesday, June 28, noon Pacific time. > PLEASE DO NOT POST ADDITIONAL COMMENTS TO THIS JIRA ISSUE. If you have > additional comments, please open a JIRA issue for a fixin in a future > release, as there is not enough time to incorporate additional comments. > Some guidelines to follow when posting comments to this issue are: > - Try to make clear and concise comments about what you want changed whenever > possible. Provide concrete comments that say "Please change to > " instead of generic comments like "This section needs to be > rewritten." > - If you're reviewing the HTML Files copy, include the URL for the page in > the review comment. Obtain the URL like this: > * highlight the topic in the left frame > * right click > * choose "Properties" > * copy and paste the address in the pop up box. > - If you're reviewing the PDF copy, in the review comment: > * Include the page number for the PDF, and indicate whether the number is > the PDF sheet number or the printed page number. > * Include the title of the section that the problem occurs in. If it's in > a subsection, try to include the hierarchy of titles. > - Please don't review the HTML Book copy -- it'll be time consuming to match > up that copy with the underlying DITA source. -- 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] Commented: (DERBY-382) Doc Review (CLOSED TO FURTHER COMMENTS): Derby Reference Manual
[ http://issues.apache.org/jira/browse/DERBY-382?page=comments#action_12314790 ] Jean T. Anderson commented on DERBY-382: I forgot to add this comment earlier, discussed with Jeff and he agreed I should go ahead and post now because it cites a general confusion of nesting of terms within the html files view of the docs. CREATE PROCEDURE http://incubator.apache.org/derby/docs/ref/rrefcreateprocedurestatement.html The online "HTML files" format for reading the book doesn't expand the sections for procedure-Name, ProcedureParameter, and ProcedureElement within the same page, like the PDF book does. So these references are not defined and are confusing. If there's a way to expand those subsections in the main page, that would be nice. If that isn't possible, perhaps at least move the Example from the ProcedureElement link up to this top level, so it's consistent with other CREATE commands, such as CREATE SYNONYM and CREATE TABLE. > Doc Review (CLOSED TO FURTHER COMMENTS): Derby Reference Manual > --- > > Key: DERBY-382 > URL: http://issues.apache.org/jira/browse/DERBY-382 > Project: Derby > Type: Improvement > Components: Documentation > Environment: all > Reporter: Jeff Levitt > Priority: Minor > Fix For: 10.1.1.0 > > This issue tracks comments for the Derby Reference Manual. The deadline for > posting comments was Tuesday, June 28, noon Pacific time. > PLEASE DO NOT POST ADDITIONAL COMMENTS TO THIS JIRA ISSUE. If you have > additional comments, please open a JIRA issue for a fixin in a future > release, as there is not enough time to incorporate additional comments. > Some guidelines to follow when posting comments to this issue are: > - Try to make clear and concise comments about what you want changed whenever > possible. Provide concrete comments that say "Please change to > " instead of generic comments like "This section needs to be > rewritten." > - If you're reviewing the HTML Files copy, include the URL for the page in > the review comment. Obtain the URL like this: > * highlight the topic in the left frame > * right click > * choose "Properties" > * copy and paste the address in the pop up box. > - If you're reviewing the PDF copy, in the review comment: > * Include the page number for the PDF, and indicate whether the number is > the PDF sheet number or the printed page number. > * Include the title of the section that the problem occurs in. If it's in > a subsection, try to include the hierarchy of titles. > - Please don't review the HTML Book copy -- it'll be time consuming to match > up that copy with the underlying DITA source. -- 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] Commented: (DERBY-382) Doc Review (CLOSED TO FURTHER COMMENTS): Derby Reference Manual
[ http://issues.apache.org/jira/browse/DERBY-382?page=comments#action_12314722 ] Jeff Levitt commented on DERBY-382: --- >From Derby-166 (which is resolved as a duplicate of this issue now): The following statement in the documentation is incorrect: NULL The opposite of NOT NULL (not really a constraint), it specifies that the column can hold NULL values. Specifying NULL is the same as saying nothing at all, except when the column is included in a PRIMARY KEY constraint. If you try to create a column with the NULL attribute, you get a failure: CREATE TABLE X ( A INT NULL ); ERROR 42X01: Syntax error: Encountered "null" at line 1, column 23. While this isn't really a problem since we can just omit the NULL keyword, the documentation gives the impression that it is allowed in the CREATE statement. > Doc Review (CLOSED TO FURTHER COMMENTS): Derby Reference Manual > --- > > Key: DERBY-382 > URL: http://issues.apache.org/jira/browse/DERBY-382 > Project: Derby > Type: Improvement > Components: Documentation > Environment: all > Reporter: Jeff Levitt > Priority: Minor > Fix For: 10.1.1.0 > > This issue tracks comments for the Derby Reference Manual. The deadline for > posting comments was Tuesday, June 28, noon Pacific time. > PLEASE DO NOT POST ADDITIONAL COMMENTS TO THIS JIRA ISSUE. If you have > additional comments, please open a JIRA issue for a fixin in a future > release, as there is not enough time to incorporate additional comments. > Some guidelines to follow when posting comments to this issue are: > - Try to make clear and concise comments about what you want changed whenever > possible. Provide concrete comments that say "Please change to > " instead of generic comments like "This section needs to be > rewritten." > - If you're reviewing the HTML Files copy, include the URL for the page in > the review comment. Obtain the URL like this: > * highlight the topic in the left frame > * right click > * choose "Properties" > * copy and paste the address in the pop up box. > - If you're reviewing the PDF copy, in the review comment: > * Include the page number for the PDF, and indicate whether the number is > the PDF sheet number or the printed page number. > * Include the title of the section that the problem occurs in. If it's in > a subsection, try to include the hierarchy of titles. > - Please don't review the HTML Book copy -- it'll be time consuming to match > up that copy with the underlying DITA source. -- 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] Commented: (DERBY-382) Doc Review (CLOSED TO FURTHER COMMENTS): Derby Reference Manual
[
http://issues.apache.org/jira/browse/DERBY-382?page=comments#action_12314720 ]
Jeff Levitt commented on DERBY-382:
---
Adding Kathey Marsden's comment on Derby-275 that was added after that issue
was committed:
REGARDING THIS PARAGRAPH:
Note that unlike a GENERATED ALWAYS column, a GENERATED BY DEFAULT column does
not guarantee uniqueness. Thus, in the above example, the hi and salut rows
will both have an identity value of "1", because the generated column starts at
"1" and the user-specified value was also "1". To prevent this, you can use the
"STARTS WITH" keyword described below. To check for this condition and disallow
it, you can use a primary key or unique constraint on the GENERATED BY DEFAULT
identity column.
In the paragraph STARTS WITH should be START WITH and loading or importing data
should be covered.
CHANGE:
To prevent this, you can use the "STARTS WITH" keyword described below.
TO:
To prevent duplication especially when loading or importing data, create the
table using a "START WITH" value which corresponds to the first
identity value that the system should assign.
ADD AN EXAMPLE:
create table greetings
(i int generated by default as identity (START WITH 2, INCREMENT BY 1),
ch char(50));
-- specify value "1":
insert into greetings values (1, 'hi');
-- use generated default
insert into greetings values (DEFAULT, 'salut');
-- use generated default
insert into greetings(ch) values ('bonjour');
> Doc Review (CLOSED TO FURTHER COMMENTS): Derby Reference Manual
> ---
>
> Key: DERBY-382
> URL: http://issues.apache.org/jira/browse/DERBY-382
> Project: Derby
> Type: Improvement
> Components: Documentation
> Environment: all
> Reporter: Jeff Levitt
> Priority: Minor
> Fix For: 10.1.1.0
>
> This issue tracks comments for the Derby Reference Manual. The deadline for
> posting comments was Tuesday, June 28, noon Pacific time.
> PLEASE DO NOT POST ADDITIONAL COMMENTS TO THIS JIRA ISSUE. If you have
> additional comments, please open a JIRA issue for a fixin in a future
> release, as there is not enough time to incorporate additional comments.
> Some guidelines to follow when posting comments to this issue are:
> - Try to make clear and concise comments about what you want changed whenever
> possible. Provide concrete comments that say "Please change to
> " instead of generic comments like "This section needs to be
> rewritten."
> - If you're reviewing the HTML Files copy, include the URL for the page in
> the review comment. Obtain the URL like this:
> * highlight the topic in the left frame
> * right click
> * choose "Properties"
> * copy and paste the address in the pop up box.
> - If you're reviewing the PDF copy, in the review comment:
> * Include the page number for the PDF, and indicate whether the number is
> the PDF sheet number or the printed page number.
> * Include the title of the section that the problem occurs in. If it's in
> a subsection, try to include the hierarchy of titles.
> - Please don't review the HTML Book copy -- it'll be time consuming to match
> up that copy with the underlying DITA source.
--
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] Commented: (DERBY-382) Doc Review (CLOSED TO FURTHER COMMENTS): Derby Reference Manual
[ http://issues.apache.org/jira/browse/DERBY-382?page=comments#action_12314692 ] Andrew McIntyre commented on DERBY-382: --- Please add a note concerning DERBY-254 to the section regarding SQLStates. Here's the DERBY-254 description: SQLExceptions generated from the client tend to have a null SQLState. An evaluation of the SQLExceptions thrown by the client needs to be performed and match embedded where possible. If this does not happen before the 10.1 release, it would be good to document that SQLStates in the client will change for future releases. > Doc Review (CLOSED TO FURTHER COMMENTS): Derby Reference Manual > --- > > Key: DERBY-382 > URL: http://issues.apache.org/jira/browse/DERBY-382 > Project: Derby > Type: Improvement > Components: Documentation > Environment: all > Reporter: Jeff Levitt > Priority: Minor > Fix For: 10.1.1.0 > > This issue tracks comments for the Derby Reference Manual. The deadline for > posting comments was Tuesday, June 28, noon Pacific time. > PLEASE DO NOT POST ADDITIONAL COMMENTS TO THIS JIRA ISSUE. If you have > additional comments, please open a JIRA issue for a fixin in a future > release, as there is not enough time to incorporate additional comments. > Some guidelines to follow when posting comments to this issue are: > - Try to make clear and concise comments about what you want changed whenever > possible. Provide concrete comments that say "Please change to > " instead of generic comments like "This section needs to be > rewritten." > - If you're reviewing the HTML Files copy, include the URL for the page in > the review comment. Obtain the URL like this: > * highlight the topic in the left frame > * right click > * choose "Properties" > * copy and paste the address in the pop up box. > - If you're reviewing the PDF copy, in the review comment: > * Include the page number for the PDF, and indicate whether the number is > the PDF sheet number or the printed page number. > * Include the title of the section that the problem occurs in. If it's in > a subsection, try to include the hierarchy of titles. > - Please don't review the HTML Book copy -- it'll be time consuming to match > up that copy with the underlying DITA source. -- 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
