Issue 114670 - primary key addition misbehavior
Summary: primary key addition misbehavior
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: DEV300m88
Hardware: Unknown All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-09-22 11:59 UTC by r4zoli
Modified: 2013-02-07 22:39 UTC (History)
1 user (show)

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


Attachments
csv file (702 bytes, text/plain)
2010-09-22 12:00 UTC, r4zoli
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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