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 "Bryan Pendleton (JIRA)" <de...@db.apache.org> on 2006/08/26 21:54:23 UTC
[jira] Created: (DERBY-1765) Update ALTER TABLE documentation to
reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
------------------------------------------------------------------------------
Key: DERBY-1765
URL: http://issues.apache.org/jira/browse/DERBY-1765
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.3.0.0
Reporter: Bryan Pendleton
Priority: Minor
DERBY-119 added a new feature to the ALTER TABLE statement: it is now
possible to change the NULL / NOT NULL constraint on a column.
The documentation for ALTER TABLE should be amended to reflect this new
capability. I think that the page that needs to be changes is the ALTER TABLE
page in the Reference manual
http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html
--
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
Re: Re: Re: When does updated doc appear on the web site?
Posted by Andrew McIntyre <mc...@gmail.com>.
On 9/8/06, Andrew McIntyre <mc...@gmail.com> wrote:
> On 9/8/06, Bryan Pendleton <bp...@amberpoint.com> wrote:
> >
> > Do you think the updated doc should be present by now? Am I perhaps looking
> > in the wrong place?
>
> Yes, it should be. As luck would have it, my nightly sync failed to
> start last night. My local copy looks good, so I'll keep an eye on the
> sync tonight and make sure it goes through. Check for it again
> tomorrow morning, you're looking in the right place.
BTW, I put a copy of the beta documentation from Rick's 10.2.1.3 beta into:
http://db.apache.org/derby/docs/10.2/
and you can see the changes made to ALTER TABLE here:
http://db.apache.org/derby/docs/10.2/ref/rrefsqlj81859.html
Also, the sync for the doc tree's trunk appears to have been ok, I'll
need to follow up tomorrow to make sure that the latest doc shows up
in at http://db.apache.org/derby/docs/dev/
andrew
Re: Re: When does updated doc appear on the web site?
Posted by Andrew McIntyre <mc...@gmail.com>.
On 9/8/06, Bryan Pendleton <bp...@amberpoint.com> wrote:
>
> Do you think the updated doc should be present by now? Am I perhaps looking
> in the wrong place?
Yes, it should be. As luck would have it, my nightly sync failed to
start last night. My local copy looks good, so I'll keep an eye on the
sync tonight and make sure it goes through. Check for it again
tomorrow morning, you're looking in the right place.
andrew
Re: When does updated doc appear on the web site?
Posted by Bryan Pendleton <bp...@amberpoint.com>.
Andrew McIntyre wrote:
>> At what point should I expect to see this page appear on the master
>> web site?
>
> The build happens around 9-10 each night, but then it involves two
> uncoordinated syncs before it shows up on the public website. The
> first occurs at 10:30, but because it takes a while and because the
> next sync from people.apache.org to the server that hosts
> db.apache.org occurs every two hours and depending on where it hits in
> relation to the other sync, it can actually be as late as 2 in the
> morning before all the changes from the nightly build show up at
> db.apache.org.
>
> Unless you're up that late, I'd just check on it Friday morning. ;-)
Thanks Andrew!
Do you think the updated doc should be present by now? Am I perhaps looking
in the wrong place? I committed a change to src/ref/rrefsqlj81859.dita,
and I expected to see it in http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html,
but that web page does not seem to reflect my change yet.
The subversion revision was 441291, if that helps.
thanks,
bryan
Re: [jira] Resolved: (DERBY-1765) Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by Andrew McIntyre <mc...@gmail.com>.
On 9/7/06, Bryan Pendleton (JIRA) <de...@db.apache.org> wrote:
>
> At what point should I expect to see this page appear on the master web site?
The build happens around 9-10 each night, but then it involves two
uncoordinated syncs before it shows up on the public website. The
first occurs at 10:30, but because it takes a while and because the
next sync from people.apache.org to the server that hosts
db.apache.org occurs every two hours and depending on where it hits in
relation to the other sync, it can actually be as late as 2 in the
morning before all the changes from the nightly build show up at
db.apache.org.
Unless you're up that late, I'd just check on it Friday morning. ;-)
andrew
[jira] Updated: (DERBY-1765) Update ALTER TABLE documentation to
reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by "Bryan Pendleton (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1765?page=all ]
Bryan Pendleton updated DERBY-1765:
-----------------------------------
Attachment: refGuide.diff
I'm having some DITA build problems, but I've attached 'refGuide.diff', which is an
attempt at changing the DITA source in question. This patch modifies the
ALTER TABLE ref page in the ref guide to note the new ALTER COLUMN functionality.
If somebody else who has a DITA build environment set up could build with this
patch, and post the corresponding HTML page from the ref manual so that we
could review it, that would be great!
> Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
> ------------------------------------------------------------------------------
>
> Key: DERBY-1765
> URL: http://issues.apache.org/jira/browse/DERBY-1765
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Bryan Pendleton
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.2.1.0
>
> Attachments: refGuide.diff
>
>
> DERBY-119 added a new feature to the ALTER TABLE statement: it is now
> possible to change the NULL / NOT NULL constraint on a column.
> The documentation for ALTER TABLE should be amended to reflect this new
> capability. I think that the page that needs to be changes is the ALTER TABLE
> page in the Reference manual
> http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html
--
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
Re: [jira] Updated: (DERBY-1765) Update ALTER TABLE documentation to
reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by John Embretsen <Jo...@Sun.COM>.
John Embretsen wrote:
> In my environment I see some weird, out-of-place question marks in the
> paragraph starting with "The identity column has" in the output I
> generated, but that is not part of your changes, nor are the question
> marks to be found in the dita source. I'll double check the online docs
> later.
I checked today, online version (trunk) looks just fine.
--
John
Re: [jira] Updated: (DERBY-1765) Update ALTER TABLE documentation to
reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by John Embretsen <Jo...@Sun.COM>.
Bryan Pendleton wrote:
> Thanks John for building the change and posting the HTML. Did you have any
> comments on the content of the change?
For the record: No, I do not have any comments, apart from saying that
the changes look good :)
In my environment I see some weird, out-of-place question marks in the
paragraph starting with "The identity column has" in the output I
generated, but that is not part of your changes, nor are the question
marks to be found in the dita source. I'll double check the online docs
later.
--
John
Re: [jira] Updated: (DERBY-1765) Update ALTER TABLE documentation
to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by Bryan Pendleton <bp...@amberpoint.com>.
Thanks John for building the change and posting the HTML. Did you have any
comments on the content of the change?
Thanks Rick for the quick review.
Please let me know of any other comments on the page. If there are
no further comments, I'll commit this change tonight.
thanks,
bryan
[jira] Updated: (DERBY-1765) Update ALTER TABLE documentation to
reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by "John H. Embretsen (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1765?page=all ]
John H. Embretsen updated DERBY-1765:
-------------------------------------
Attachment: rrefsqlj81859.html
Attaching resulting html (rrefsqlj81859.html) after applying Bryan's patch 'refGuide.diff' to my working copy of the doc trunk. I produced the output by running 'ant html.ref', no issues seen (I removed the DITA toolkit directory before running ant, as recommended by Andrew a few hours ago).
> Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
> ------------------------------------------------------------------------------
>
> Key: DERBY-1765
> URL: http://issues.apache.org/jira/browse/DERBY-1765
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Bryan Pendleton
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.2.1.0
>
> Attachments: refGuide.diff, rrefsqlj81859.html
>
>
> DERBY-119 added a new feature to the ALTER TABLE statement: it is now
> possible to change the NULL / NOT NULL constraint on a column.
> The documentation for ALTER TABLE should be amended to reflect this new
> capability. I think that the page that needs to be changes is the ALTER TABLE
> page in the Reference manual
> http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html
--
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] Resolved: (DERBY-1765) Update ALTER TABLE documentation to
reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by "Bryan Pendleton (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1765?page=all ]
Bryan Pendleton resolved DERBY-1765.
------------------------------------
Fix Version/s: 10.3.0.0
(was: 10.2.1.0)
Resolution: Fixed
Documentation change committed to subversion as revision 441291.
At what point should I expect to see this page appear on the master web site?
> Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
> ------------------------------------------------------------------------------
>
> Key: DERBY-1765
> URL: http://issues.apache.org/jira/browse/DERBY-1765
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Bryan Pendleton
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: refGuide.diff, rrefsqlj81859.html
>
>
> DERBY-119 added a new feature to the ALTER TABLE statement: it is now
> possible to change the NULL / NOT NULL constraint on a column.
> The documentation for ALTER TABLE should be amended to reflect this new
> capability. I think that the page that needs to be changes is the ALTER TABLE
> page in the Reference manual
> http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html
--
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-1765) Update ALTER TABLE documentation to
reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1765?page=comments#action_12432841 ]
Rick Hillegas commented on DERBY-1765:
--------------------------------------
Documentation should also describe the effects of DERBY-1491 (altering a table to change a column's default), which was also fixed by DERBY-119.
> Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
> ------------------------------------------------------------------------------
>
> Key: DERBY-1765
> URL: http://issues.apache.org/jira/browse/DERBY-1765
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Bryan Pendleton
> Priority: Minor
> Fix For: 10.2.1.0
>
>
> DERBY-119 added a new feature to the ALTER TABLE statement: it is now
> possible to change the NULL / NOT NULL constraint on a column.
> The documentation for ALTER TABLE should be amended to reflect this new
> capability. I think that the page that needs to be changes is the ALTER TABLE
> page in the Reference manual
> http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html
--
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-1765) Update ALTER TABLE documentation to
reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1765?page=comments#action_12433149 ]
Rick Hillegas commented on DERBY-1765:
--------------------------------------
Thanks, Bryan. These changes look good to me. They accurately describe the new ALTER TABLE behavior for changing the nullability and default value of a column.
> Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
> ------------------------------------------------------------------------------
>
> Key: DERBY-1765
> URL: http://issues.apache.org/jira/browse/DERBY-1765
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Bryan Pendleton
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.2.1.0
>
> Attachments: refGuide.diff, rrefsqlj81859.html
>
>
> DERBY-119 added a new feature to the ALTER TABLE statement: it is now
> possible to change the NULL / NOT NULL constraint on a column.
> The documentation for ALTER TABLE should be amended to reflect this new
> capability. I think that the page that needs to be changes is the ALTER TABLE
> page in the Reference manual
> http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html
--
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-1765) Update ALTER TABLE documentation to
reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1765?page=comments#action_12433192 ]
Andrew McIntyre commented on DERBY-1765:
----------------------------------------
These changes also look good to me. +1 to commit.
> Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
> ------------------------------------------------------------------------------
>
> Key: DERBY-1765
> URL: http://issues.apache.org/jira/browse/DERBY-1765
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Bryan Pendleton
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.2.1.0
>
> Attachments: refGuide.diff, rrefsqlj81859.html
>
>
> DERBY-119 added a new feature to the ALTER TABLE statement: it is now
> possible to change the NULL / NOT NULL constraint on a column.
> The documentation for ALTER TABLE should be amended to reflect this new
> capability. I think that the page that needs to be changes is the ALTER TABLE
> page in the Reference manual
> http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html
--
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-1765) Update ALTER TABLE documentation to
reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by "Bryan Pendleton (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1765?page=all ]
Bryan Pendleton closed DERBY-1765.
----------------------------------
I verified that the changes showed up on the master website. Closing issue.
> Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
> ------------------------------------------------------------------------------
>
> Key: DERBY-1765
> URL: http://issues.apache.org/jira/browse/DERBY-1765
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Bryan Pendleton
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: refGuide.diff, rrefsqlj81859.html
>
>
> DERBY-119 added a new feature to the ALTER TABLE statement: it is now
> possible to change the NULL / NOT NULL constraint on a column.
> The documentation for ALTER TABLE should be amended to reflect this new
> capability. I think that the page that needs to be changes is the ALTER TABLE
> page in the Reference manual
> http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html
--
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
Re: [jira] Updated: (DERBY-1765) Update ALTER TABLE documentation to
reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by David Van Couvering <Da...@Sun.COM>.
Oops, I thought it wasn't going to go in, please ignore my previous
email... Great news, although it's going to require a bit of a scramble
to get it tested well.
David
Rick Hillegas (JIRA) wrote:
> [ http://issues.apache.org/jira/browse/DERBY-1765?page=all ]
>
> Rick Hillegas updated DERBY-1765:
> ---------------------------------
>
> Urgency: Urgent
> Fix Version/s: 10.2.1.0
>
> Assigning to 10.2 and bumping urgency since the feature has been ported to the 10.2 branch.
>
>> Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
>> ------------------------------------------------------------------------------
>>
>> Key: DERBY-1765
>> URL: http://issues.apache.org/jira/browse/DERBY-1765
>> Project: Derby
>> Issue Type: Improvement
>> Components: Documentation
>> Affects Versions: 10.3.0.0
>> Reporter: Bryan Pendleton
>> Priority: Minor
>> Fix For: 10.2.1.0
>>
>>
>> DERBY-119 added a new feature to the ALTER TABLE statement: it is now
>> possible to change the NULL / NOT NULL constraint on a column.
>> The documentation for ALTER TABLE should be amended to reflect this new
>> capability. I think that the page that needs to be changes is the ALTER TABLE
>> page in the Reference manual
>> http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html
>
[jira] Updated: (DERBY-1765) Update ALTER TABLE documentation to
reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by "Rick Hillegas (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1765?page=all ]
Rick Hillegas updated DERBY-1765:
---------------------------------
Urgency: Urgent
Fix Version/s: 10.2.1.0
Assigning to 10.2 and bumping urgency since the feature has been ported to the 10.2 branch.
> Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
> ------------------------------------------------------------------------------
>
> Key: DERBY-1765
> URL: http://issues.apache.org/jira/browse/DERBY-1765
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Bryan Pendleton
> Priority: Minor
> Fix For: 10.2.1.0
>
>
> DERBY-119 added a new feature to the ALTER TABLE statement: it is now
> possible to change the NULL / NOT NULL constraint on a column.
> The documentation for ALTER TABLE should be amended to reflect this new
> capability. I think that the page that needs to be changes is the ALTER TABLE
> page in the Reference manual
> http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html
--
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] Assigned: (DERBY-1765) Update ALTER TABLE documentation to
reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
Posted by "Bryan Pendleton (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-1765?page=all ]
Bryan Pendleton reassigned DERBY-1765:
--------------------------------------
Assignee: Bryan Pendleton
I'm intending to work on this but won't get to it until at least this weekend.
> Update ALTER TABLE documentation to reflect DERBY-119 (ALTER COLUMN [NOT]NULL)
> ------------------------------------------------------------------------------
>
> Key: DERBY-1765
> URL: http://issues.apache.org/jira/browse/DERBY-1765
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.3.0.0
> Reporter: Bryan Pendleton
> Assigned To: Bryan Pendleton
> Priority: Minor
> Fix For: 10.2.1.0
>
>
> DERBY-119 added a new feature to the ALTER TABLE statement: it is now
> possible to change the NULL / NOT NULL constraint on a column.
> The documentation for ALTER TABLE should be amended to reflect this new
> capability. I think that the page that needs to be changes is the ALTER TABLE
> page in the Reference manual
> http://db.apache.org/derby/docs/dev/ref/rrefsqlj81859.html
--
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