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 "Eric Radzinski (JIRA)" <de...@db.apache.org> on 2006/01/24 22:28:09 UTC
[jira] Created: (DERBY-869) documentation to address Derby-783
documentation to address Derby-783
----------------------------------
Key: DERBY-869
URL: http://issues.apache.org/jira/browse/DERBY-869
Project: Derby
Type: Sub-task
Components: Documentation
Versions: 10.0.2.0
Reporter: Eric Radzinski
document changes to ALTER TABLE syntax to address Derby-783
--
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-869) documentation to address Derby-783
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-869?page=all ]
Jean T. Anderson resolved DERBY-869:
------------------------------------
Fix Version: 10.2.0.0
Resolution: Fixed
Applied the patch "derby869.diff" that was uploaded on Jan 27, 2006, to the trunk and committed revision 374145. Modified file:
$ svn status
M src/ref/rrefsqlj81859.dita
> documentation to address Derby-783
> ----------------------------------
>
> Key: DERBY-869
> URL: http://issues.apache.org/jira/browse/DERBY-869
> Project: Derby
> Type: Sub-task
> Components: Documentation
> Versions: 10.0.2.0
> Reporter: Eric Radzinski
> Assignee: Eric Radzinski
> Fix For: 10.2.0.0
> Attachments: derby869.diff, derby869.diff, rrefsqlj81859.html, rrefsqlj81859.html
>
> document changes to ALTER TABLE syntax to address Derby-783
--
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-869) documentation to address Derby-783
Posted by "Eric Radzinski (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-869?page=comments#action_12363899 ]
Eric Radzinski commented on DERBY-869:
--------------------------------------
Attached patch address changes to the ALTER TABLE column-alteration functionality that was introduced by Derby-783. HTML file included for review...
> documentation to address Derby-783
> ----------------------------------
>
> Key: DERBY-869
> URL: http://issues.apache.org/jira/browse/DERBY-869
> Project: Derby
> Type: Sub-task
> Components: Documentation
> Versions: 10.0.2.0
> Reporter: Eric Radzinski
> Attachments: derby869.diff, rrefsqlj81859.html
>
> document changes to ALTER TABLE syntax to address Derby-783
--
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-869) documentation to address Derby-783
Posted by "Andrew McIntyre (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-869?page=all ]
Andrew McIntyre updated DERBY-869:
----------------------------------
Other Info: [Patch available]
> documentation to address Derby-783
> ----------------------------------
>
> Key: DERBY-869
> URL: http://issues.apache.org/jira/browse/DERBY-869
> Project: Derby
> Type: Sub-task
> Components: Documentation
> Versions: 10.0.2.0
> Reporter: Eric Radzinski
> Assignee: Eric Radzinski
> Attachments: derby869.diff, rrefsqlj81859.html
>
> document changes to ALTER TABLE syntax to address Derby-783
--
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-869) documentation to address Derby-783
Posted by "Eric Radzinski (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-869?page=all ]
Eric Radzinski reassigned DERBY-869:
------------------------------------
Assign To: Eric Radzinski
> documentation to address Derby-783
> ----------------------------------
>
> Key: DERBY-869
> URL: http://issues.apache.org/jira/browse/DERBY-869
> Project: Derby
> Type: Sub-task
> Components: Documentation
> Versions: 10.0.2.0
> Reporter: Eric Radzinski
> Assignee: Eric Radzinski
> Attachments: derby869.diff, rrefsqlj81859.html
>
> document changes to ALTER TABLE syntax to address Derby-783
--
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-869) documentation to address Derby-783
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-869?page=comments#action_12364133 ]
Mamta A. Satoor commented on DERBY-869:
---------------------------------------
Couple of trivial comments
1)At the top of the ALTER TABLE statement page, there are 5 bullet items explaining what alter table statement can be used for (this is before the syntax description). Can you please add that it can be used to change the increment value and start value of the identity column?
2)Please don't include semicolons at the end of the sql statements in the eg for the RESTART WITH. Following sqls have ; at the end.
CREATE TABLE tauto(i INT GENERATED BY DEFAULT AS IDENTITY, k INT);
CREATE UNIQUE INDEX tautoInd ON tauto(i);
INSERT INTO tauto(k) values 1,2;
INSERT INTO tauto VALUES (3,3);
INSERT INTO tauto VALUES (4,4);
INSERT INTO tauto VALUES (5,5);
ALTER TABLE tauto ALTER COLUMN i RESTART WITH 6;
> documentation to address Derby-783
> ----------------------------------
>
> Key: DERBY-869
> URL: http://issues.apache.org/jira/browse/DERBY-869
> Project: Derby
> Type: Sub-task
> Components: Documentation
> Versions: 10.0.2.0
> Reporter: Eric Radzinski
> Assignee: Eric Radzinski
> Attachments: derby869.diff, rrefsqlj81859.html
>
> document changes to ALTER TABLE syntax to address Derby-783
--
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-869) documentation to address Derby-783
Posted by "Mamta A. Satoor (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-869?page=comments#action_12364190 ]
Mamta A. Satoor commented on DERBY-869:
---------------------------------------
I looked at the last html file submitted by Eric and it looks set to go. Can a committer please commit it?
> documentation to address Derby-783
> ----------------------------------
>
> Key: DERBY-869
> URL: http://issues.apache.org/jira/browse/DERBY-869
> Project: Derby
> Type: Sub-task
> Components: Documentation
> Versions: 10.0.2.0
> Reporter: Eric Radzinski
> Assignee: Eric Radzinski
> Attachments: derby869.diff, derby869.diff, rrefsqlj81859.html, rrefsqlj81859.html
>
> document changes to ALTER TABLE syntax to address Derby-783
--
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-869) documentation to address Derby-783
Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-869?page=all ]
Jean T. Anderson closed DERBY-869:
----------------------------------
No problems have been reported with the committed patch, so closing.
> documentation to address Derby-783
> ----------------------------------
>
> Key: DERBY-869
> URL: http://issues.apache.org/jira/browse/DERBY-869
> Project: Derby
> Type: Sub-task
> Components: Documentation
> Versions: 10.0.2.0
> Reporter: Eric Radzinski
> Assignee: Eric Radzinski
> Fix For: 10.2.0.0
> Attachments: derby869.diff, derby869.diff, rrefsqlj81859.html, rrefsqlj81859.html
>
> document changes to ALTER TABLE syntax to address Derby-783
--
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-869) documentation to address Derby-783
Posted by "Eric Radzinski (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-869?page=all ]
Eric Radzinski updated DERBY-869:
---------------------------------
Attachment: derby869.diff
rrefsqlj81859.html
All set. I've incorporated your latest comments. Patch and HTML file are included.
> documentation to address Derby-783
> ----------------------------------
>
> Key: DERBY-869
> URL: http://issues.apache.org/jira/browse/DERBY-869
> Project: Derby
> Type: Sub-task
> Components: Documentation
> Versions: 10.0.2.0
> Reporter: Eric Radzinski
> Assignee: Eric Radzinski
> Attachments: derby869.diff, derby869.diff, rrefsqlj81859.html, rrefsqlj81859.html
>
> document changes to ALTER TABLE syntax to address Derby-783
--
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-869) documentation to address Derby-783
Posted by "Eric Radzinski (JIRA)" <de...@db.apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-869?page=all ]
Eric Radzinski updated DERBY-869:
---------------------------------
Attachment: derby869.diff
rrefsqlj81859.html
Attached patch address changes to ALTER TABLE column-alteration functionality that was introduced by Derby-783. HTML file included for review.
> documentation to address Derby-783
> ----------------------------------
>
> Key: DERBY-869
> URL: http://issues.apache.org/jira/browse/DERBY-869
> Project: Derby
> Type: Sub-task
> Components: Documentation
> Versions: 10.0.2.0
> Reporter: Eric Radzinski
> Attachments: derby869.diff, rrefsqlj81859.html
>
> document changes to ALTER TABLE syntax to address Derby-783
--
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