Issue 118038 - Unable to make primary key stick to table if we refuse its automatic creation in GUI
Summary: Unable to make primary key stick to table if we refuse its automatic creation...
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.3
Hardware: PC Windows, all
: P3 Normal with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-17 17:38 UTC by lapsap7+ooo
Modified: 2013-02-07 22:43 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description lapsap7+ooo 2011-05-17 17:38:58 UTC
This bug reflects the discussion in the forum at http://user.services.openoffice.org/en/forum/viewtopic.php?f=13&t=40287

In summary, if we refuse OObase's automatic creation of primary key in GUI, we would be in trouble creating the primary key of our own.

Here are the steps, more or less similar to those written by DACM, to reproduce the bug:
1. Create Table in Design View...
2. Add an INTEGER field called ID but don't specify yet AutoValue = Yes
3. Add another field
4. Save the Table.
   When asked "Should a primary key be created now?" > Answer "No" (because we
   intend to make the ID field the PK)
5. Go back to the ID field > right-click > Primary Key
6. Save the Table.
   If we open the table in edit view, we can see that the Primary Key disappears
7. Go back to the ID field, change AutoValue to Yes and change it to Primary Key again
8. Save the Table.
   If we open the table in edit view, we can see that the Primary Key disappears again!

The point is, whether the Integer field is AutoValue or not, PK can't stick.

I've found a workaround for the moment:
a. Edit the table and specify the ID field as PK
b. Save the table and close it. (Don't open it!)
c. Save the database file and close OOBase.
d. Reopen the database file and PK is there!

Step b is important.  If you open the table again before closing the whole application, PK just can't stick.
Comment 1 r4zoli 2011-05-18 06:54:09 UTC
I can confirm it, same happens in OOo 3.3. and in OOo 3.4 beta.
Comment 2 Frank Schönheit 2011-06-09 08:22:35 UTC
(reproduced, too, put into the DBA pool of effectively unassigned issues)
Comment 3 Oliver-Rainer Wittmann 2012-06-13 12:32:34 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.