Issue 107461 - Changing the case of a table column loses the column data without any hint
Summary: Changing the case of a table column loses the column data without any hint
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO320m7
Hardware: PC Windows XP
: P2 Trivial (vote)
Target Milestone: OOo 3.3
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords: data_loss, oooqa
Depends on:
Blocks:
 
Reported: 2009-12-05 21:47 UTC by ud
Modified: 2017-05-20 10:24 UTC (History)
3 users (show)

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

Attachments
Example (3.70 KB, text/plain)
2009-12-05 21:48 UTC, ud 		no flags Details
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 ud 2009-12-05 21:47:05 UTC 
If i rename an coloumn in the table editor like
"dtText" in "dttext", and saved the table by click on the "save
button". The coloumn will be deleted without any hint that data will
be lost.
After opening the Table, the new coloumn name exist, but the
datasets where lost.
It would be nice, if renaming of a coloumn would work without deleting and
creating a new coloumn. Otherwise an information to the user is helpfull.

I checked this with OOO320m7 on WinXP and 3.1.1 and in both it is the same.

-Open attached database
-double click on "Table1"
=> notice that "dtText" is filled
-edit "Table1"
-rename "dtText" in "dttext"
-push the save Button
- close and reopen "Table1"
=>In the example you can see, that the "dtLook" coloumn now is at
the second position.
Comment 1 ud 2009-12-05 21:48:35 UTC 
Created attachment 66503 [details]
Example
Comment 2 Regina Henschel 2009-12-05 22:35:02 UTC 
I can confirm the bug for DEV300 m66 on WinXP. The problem has been told already
in issue 102096, which was closed as worksforme.

I think it is a severe error, because the user notice the data loss earliest
when he has closed the edit window and then there is no undo possible, because
the changes are written immediately to the database.
Comment 3 Regina Henschel 2009-12-05 22:42:18 UTC 
There had been a similar bug issue 14870 which was fixed for OOo1.1. But I see
the bug in OO2.4.3 too.
Comment 4 Regina Henschel 2009-12-05 22:53:05 UTC 
The direct SQL command
ALTER TABLE "Table1" ALTER COLUMN "dtText" RENAME TO "dttext"
works as expected and alters the field name without data loss.
Comment 5 Frank Schönheit 2009-12-07 09:07:18 UTC 
targeting, assigning. Seems to me this only happens if you change the case of
the column.
Comment 6 ocke.janssen 2010-01-07 11:26:27 UTC 
Fixed in cws dba33e.
Comment 7 ocke.janssen 2010-02-08 12:11:44 UTC 
Please verify. Thanks.
Comment 8 marc.neumann 2010-02-18 09:01:01 UTC 
verified in cws dba33e. Now the field name is changed without data lost.