Issue 102096 - Rename field results in data loss
Summary: Rename field results in data loss
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.0.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: gg43
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-05-20 15:04 UTC by wouterengels
Modified: 2017-05-20 09:36 UTC (History)
5 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description wouterengels 2009-05-20 15:04:48 UTC 
If I rename a field in the design view, 
this results in the original field being deleted and a new field being created.

Suggestion: use (correct) SQL commands directly to update the database.
ALTER TABLE  ...  RENAME COLUMN ... ?
Comment 1 drewjensen.inbox 2009-05-21 21:50:15 UTC 
using OO.o 3.0.1 this is a problem.
Checked w/ 3.1 (under Linux currently) and the problem has been corrected - the
field name changes are made without problem. At least for an embedded database..
Comment 2 drewjensen.inbox 2009-05-24 08:37:12 UTC 
I checked this using XP - OO.o 3.1 w/ embedded HSQLdb & MySQL JDBC & MySQL Native

Setting to WORKSFORME
Comment 3 Mechtilde 2009-07-12 20:16:53 UTC 
worksforme -> closed
Comment 4 Regina Henschel 2009-12-05 22:11:32 UTC 
Be bug is still there with OOo3.2m6 and DEV300m65 on WinXP with embedded HSQL. I
have used test document in issue 107461.
Comment 5 gg43 2013-02-28 23:10:06 UTC 
Platform: 
Operating System: Windows 7 Home Premium Version 6.1.7601 Service Pack 1 Build 7601 (x64)
Apache Open Office 3.4.1 AOO341m1 Build 9593 Rev 1372282

My test:
Used internal HSQL database
Created a table with 4 fields
created forms- 
created reports
created query
Table click right Update: renamed field names in the table.
Checks:
- Table OK,
- Table Editor OK
- Query OK
- Editor Query OK
- Forms: Not updated
- Reports: Not updated.
Comment 6 gg43 2013-04-09 22:54:08 UTC 
Ops I did a mistake
set Status RESOLVED IRREPRODUCIBLE