To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=108303
User atjensen changed the following:
What |Old value |New value
================================================================================
CC|'md' |'atjensen,md'
--------------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Sun Mar 7 17:52:20
+0000 2010 -------
Yes it fails - as it should.
If you add a column of type INT and then table is empty then you can set it to
the primary key.
If the table has existing records then this new field will have all NULL values
in it for every current record. The primary key designation requires that the
field be REQUIRED and NOT NULL.
Add data to the column for existing records (unique values of course) and then
the change to primary key will work.
Setting the new field type to AUTO_VALUE will not help you here either, as this
only fires when a NEW record is inserted.
For help with the steps required to perform the AUTO_VALUE field addition please
ask on the dba users mailing list or at the user.services forum
Setting issue to INVALID
---------------------------------------------------------------------
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]
