[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 User msc changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from [EMAIL PROTECTED] Fri Feb 10 01:50:46 -0800 2006 --- Hi, this is fixed in the current master. The current master is available at http://download.openoffice.org/680/index.html I close this issue now. Bye Marc - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Mon Jan 30 05:28:46 -0800 2006 --- verified in cws dba202d - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Wed Jan 25 03:50:38 -0800 2006 --- . - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 User oj changed the following: What|Old value |New value Status|RESOLVED |REOPENED Resolution|FIXED | --- Additional comments from [EMAIL PROTECTED] Wed Jan 25 03:27:19 -0800 2006 --- Please verify. Thanks. re-open issue and reassign to [EMAIL PROTECTED] - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 User oj changed the following: What|Old value |New value Assigned to|oj|msc Status|REOPENED |NEW --- Additional comments from [EMAIL PROTECTED] Wed Jan 25 03:43:23 -0800 2006 --- . - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Tue Jan 3 04:15:03 -0800 2006 --- Fixed in cws dba202d - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 --- Additional comments from [EMAIL PROTECTED] Tue Jan 3 06:41:12 -0800 2006 --- > Are you saying that this patch will check if the column you are about to > rename > is used by a view, and if so disallow the change? Yes > If the column can not be renamed because it is referenced by the view, then the user > should not be able to drop it either. In fact in 2.0.1 that is exactly the behavior, neither > column in, nor the table itself can be dropped while the view exists. The least invasive fix we can do (and only this kind of fix is acceptable for 2.0.x, for stability reasons) will continue to use the fallback to delete/re-create columns which cannot be modified. Of course this does not make sense in this particular case, since deletion will also fail, as you outlined. But correctly determining this special case, and reacting appropriately, is out of scope for 2.0.x. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 --- Additional comments from [EMAIL PROTECTED] Sun Jan 1 19:21:17 -0800 2006 --- Quote "This prevents the data loss insofar as now the column name cannot be changed anymore." Are you saying that this patch will check if the column you are about to rename is used by a view, and if so disallow the change? Quote "Shouldn't we tell something like "the column could not be changed, should it be deleted/re-created?"?" This ties in with the above question. If the column can not be renamed because it is referenced by the view, then the user should not be able to drop it either. In fact in 2.0.1 that is exactly the behavior, neither a column in, nor the table itself can be dropped while the view exists. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 --- Additional comments from [EMAIL PROTECTED] Thu Dec 22 01:21:22 -0800 2005 --- fs->oj: I checked in Fred's patch (in CWS dba202d). This prevents the data loss insofar as now the column name cannot be changed anymore. However, now the table design asks the user whether the primary key should be deleted, of which ch1 is a part. This is somewhat strange, isn't it? Shouldn't we tell something like "the column could not be changed, should it be deleted/re-created?"? - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 User fs changed the following: What|Old value |New value CC|'tonygalmiche,wurzel' |'fs,tonygalmiche,wurzel' Assigned to|fs|oj --- Additional comments from [EMAIL PROTECTED] Tue Dec 20 23:38:30 -0800 2005 --- fs->oj: Please work with Fred on solving this. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 User fs changed the following: What|Old value |New value Target milestone|OOo 2.0 |OOo 2.0.2 --- Additional comments from [EMAIL PROTECTED] Tue Dec 20 23:37:40 -0800 2005 --- targeting to 2.0.2. Sorry, 2.0 is out. 2.0.1 might be an option, but before we do this, I want to have the decision to really block 2.0.1 for this. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 --- Additional comments from [EMAIL PROTECTED] Tue Dec 20 23:17:37 -0800 2005 --- for completeness: The problem does not depend on ch1 being the primary key. If you let OOo add another primary key automatically (upon saving the table), the problem also occurs, you only save the error message when renaming ch1 to ch2. - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 User wurzel changed the following: What|Old value |New value Assigned to|spreadsheet |fs --- Additional comments from [EMAIL PROTECTED] Tue Dec 20 09:49:55 -0800 2005 --- reassigning to fs - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 User wurzel changed the following: What|Old value |New value Keywords| |oooqa --- Additional comments from [EMAIL PROTECTED] Tue Dec 20 09:43:37 -0800 2005 --- I've reset the component to Database access and set P2 coz data loss. alex - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[dba-issues] [Issue 59584] Can't access table after trying to change a field name
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=59584 User wurzel changed the following: What|Old value |New value CC|'tonygalmiche'|'tonygalmiche,wurzel' Component|Spreadsheet |Database access Priority|P3|P2 QA contact|[EMAIL PROTECTED] |[EMAIL PROTECTED] Subcomponent|save-export |none Target milestone|--- |OOo 2.0 - Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]