Issue 114670

Summary: primary key addition misbehavior
Product: Base Reporter: r4zoli <r4zoli>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues
Version: DEV300m88   
Target Milestone: ---   
Hardware: Unknown   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
csv file none

Description r4zoli 2010-09-22 11:59:31 UTC
Open attached csv file in Calc.
Create new odb file, or open existing one.
Copy sheet by drag and drop, without primary key.
Open table in edit mode, add pk to first filed "syslog_severity".
Save table.

The "syslog_severity" filed is unsuitable for PK, this contain several similar
values. 
This scenario came from forum post, where beginner user copied sheet data and
tried to add PK, after copy wizard.

In OOO330m8 and DEV300m88, no error message, the gold key before first field.
If You open Tools>Index design no pk added, no indexes.
Close edit window, reopen table for edit, no pk selected.

In OOo 3.2.1 you get error, when you click on save,confusing beginner users:
SQL Status: S0011
Error code: -61

Constraint not foundtable has no primary key in statement [ALTER TABLE "Table1"
DROP PRIMARY KEY]

It is not understandable for beginner users.

Both version are wrong, no suggestion.
It is low severity issue, I set P4.
Comment 1 r4zoli 2010-09-22 12:00:36 UTC
Created attachment 71804 [details]
csv file