[Libreoffice-bugs] [Bug 108068] New: Can't change Primary Key' s name with Firebird Embedded db.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108068

            Bug ID: 108068
           Summary: Can't change Primary Key's name with Firebird Embedded
                    db.
           Product: LibreOffice
           Version: 5.3.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: BridgeportContractor at gmail.com

Created attachment 133540
  --> https://bugs.documentfoundation.org/attachment.cgi?id=133540&action=edit
screen shot with final fatal error message

Unnecessary trouble when trying to rename a field while using Firebird
Embedded.

Steps to recreate:

Step 1 - Create a simple database
  Open LibreOffice
  Select File, New, Database.
  Select Firebird Embedded

  Create Table in Design View...
    On line 1 enter: Field Name = "ID"  , and Field Type = "Integer"
    On line 2 enter: Field Name = "Test", and Feild Type = "Text"
    Set line 1 as the Primary Key.  Set Line 1 to AutoValue=Yes.

  Save the table.

Step 2 - Test it
  Open it and add text into Test field and hit return.  
  Result normal: ID gets zero, and cursor moves to next line.
  Close it

Step 3 - Edit the new table
  Rename ID to ID2
  Save


Unexpected result 1: "Warning", and 
> The column "ID2" could not be changed.  Should the column instead be deleted and the new format appended?

My comment:  My gosh, guys, what's up with this?  Identifiers have been around
for 50+ years.  In 2017 one should be able to easily rename a field in every
database, even a Key field.  The concept of separation between name and
functionality is a long standing tradition in all computer languages.  I am
shocked really, by this prompt which must have been put in either by someone in
a hurry or by someone who doesn't really care about Base.


So just to see what happens next, I then click "Yes" to continue.


Unexpected result 2: "Primary Key Affected", and "The column "ID" belongs to
the primary key.  If the column is deleted, the primary key will also be
delted.  Do you really want to continue?

My comment: More of the same as above.  Please get rid of these two messages
and just rename the field.


Again just to see what happens next, I click "Yes" to continue.


Unexpected result 3: fatal error message.  (See the attached screen shot.)

My comment: 3 strikes and we're out.  :-(



EXPECTED RESULT of a field rename request:  ID should simply be renamed to ID2.

-- No prompts or other messages should appear.  
-- No questions should be asked.  
-- No errors should be reported.

No matter how much work it takes this needs to be fixed.


Thanks for looking into this.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170524/c15eb67c/attachment.html>