Bug 234191 - All data is erased in a table even when only new fields are added
Summary: All data is erased in a table even when only new fields are added
Status: CLOSED DUPLICATE of bug 125253
Alias: None
Product: KEXI
Classification: Applications
Component: Tables (show other bugs)
Version: 2.2 beta2 (KOffice 2.2 beta2)
Platform: Unlisted Binaries Linux
: NOR wishlist
Target Milestone: ---
Assignee: Jarosław Staniek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-04-12 21:55 UTC by George Goldberg
Modified: 2010-05-07 22:09 UTC (History)
0 users

See Also:
Latest Commit:
Version Fixed In:
Sentry Crash Report:

Attachments
Add an attachment

Note You need to log in before you can comment on or make changes to this bug.
Description George Goldberg 2010-04-12 21:55:12 UTC 
Kexi removes all rows from a table when it is modified, even if the data isn't invalidated in any way, such as by adding an extra column.
Comment 1 Jarosław Staniek 2010-04-12 22:45:31 UTC 
More info:

<grundleborg> jstaniek: so, about 234191: If I add an extra row, I get "Do you want to save the design now? \n\n Warning! Any data in this table will be removed upon design's saving!"
Comment 2 Jarosław Staniek 2010-05-07 22:06:32 UTC 
This special case (only adding columns) is not covered yet. There are many more similar cases and we try to get more generic approach than covering one by one case. E.g. renaming column, changing column order. A lot also depends on the backend, e.g. mysql and postgresql allow column alteration much more than sqlite.

I am sorry for not noticing early enough that the report is indeed a (very important) wish like #125253. Marking as duplicate.

*** This bug has been marked as a duplicate of bug 125253 ***