[dba-issues] [Issue 47321] cannot change existing co lumn to be a primary key in bugdoc (HSQLDB)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47321 --- Additional comments from [EMAIL PROTECTED] Mon Aug 1 00:05:10 -0700 2005 --- bencoman, what you describe is the problem that a table cannot have more than one auto-increment column (auto-generated primary keys are automatically made auto-increment columns), which is because HSQLDB slightly mixes the concepts of auto-increment and primary-key columns. Also see issue 51517 and issue 48442. This issue here, as by the very original description, is in fact fixed in m118. And, ehm, please don't post such comments to muliple issues :-\, polluting them this way. If you're unsure, user a dedicated channels such as [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 47321] cannot change existing co lumn to be a primary key in bugdoc (HSQLDB)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47321 --- Additional comments from [EMAIL PROTECTED] Sat Jul 30 21:41:31 -0700 2005 --- Just downloaded OpenOffice today 2005-07-31. Help About shows version 1.9.118. This use case relates to issue 45338, which was marked as a duplicate of issue 47321, which was closed on 2005-06-29 saying it should be in the current master. From the date in Release Notes footer 1.9.m118_snapshot.html,v 1.2 2005/07/18 I'm guessing I should have the fix, but I'm not sure how 47321's target milestone of OOo 2.0.1 relates to when the fix is actually released, the the m118 release ntoes dont mention 47321. Anyhow, the use case for 1.9.118. + Start OpenOffice.org 1.9.118 OpenOffice Base + Create New Database Next + Leave defaults ticked: Yes, register the database for me; Open the database for editing Finish + Filename=New Database Save + Create Table in Design View + Add field ( f1, Text [VARCHAR] ) + Save TableName=Table1 OK + ?Should a primary key be created now? Yes save appears to be successful + Add field ( f2, Integer [INTEGER] ), with AutoValue=Yes + Click out of field on next row. + Save dialog appears Error while connecting to the data source. Column constraints are not acceptable in statement [ALTER TABLE Table1 ADD f2 INTEGER IDENTITY] This comment has been added to both issues 45338 and 47321. Platform: Windows XP SP2 logged on as Administrator - 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 47321] cannot change existing co lumn to be a primary key in bugdoc (HSQLDB)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47321 User msc changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from [EMAIL PROTECTED] Wed Jun 29 06:20:30 -0700 2005 --- Hi, This is fixed in the current master. The current master will be availbale under http://download.openoffice.org/680/index.html soon. 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 47321] cannot change existing co lumn to be a primary key in bugdoc (HSQLDB)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47321 User fs changed the following: What|Old value |New value Status|RESOLVED |REOPENED Resolution|FIXED | --- Additional comments from [EMAIL PROTECTED] Wed Jun 22 03:44:23 -0700 2005 --- fs- msc: please verify in CWS hslqdb3 re-open issue and reassign to msc - 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 47321] cannot change existing co lumn to be a primary key in bugdoc (HSQLDB)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47321 User fs changed the following: What|Old value |New value Assigned to|oj|msc Status|REOPENED |NEW --- Additional comments from [EMAIL PROTECTED] Wed Jun 22 03:44:28 -0700 2005 --- reassign to msc - 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 47321] cannot change existing co lumn to be a primary key in bugdoc (HSQLDB)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47321 User fs changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Wed Jun 22 03:44:33 -0700 2005 --- reset resolution to FIXED - 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 47321] cannot change existing co lumn to be a primary key in bugdoc (HSQLDB)
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=47321 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Wed Jun 22 05:52:32 -0700 2005 --- verified in cws hsqldb3 - 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]