<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Can't change Primary Key's name with Firebird Embedded db."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108068">108068</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Can't change Primary Key's name with Firebird Embedded db.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>BridgeportContractor@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=133540" name="attach_133540" title="screen shot with final fatal error message">attachment 133540</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133540&action=edit" title="screen shot with final fatal error message">[details]</a></span>
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
<span class="quote">> The column "ID2" could not be changed. Should the column instead be deleted and the new format appended?</span >
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.</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>