Bug 234191

Summary:	All data is erased in a table even when only new fields are added
Product:	[Applications] KEXI	Reporter:	George Goldberg <grundleborg>
Component:	Tables	Assignee:	Jarosław Staniek <staniek>
Status:	CLOSED DUPLICATE
Severity:	wishlist
Priority:	NOR
Version:	2.2 beta2 (KOffice 2.2 beta2)
Target Milestone:	---
Platform:	Unlisted Binaries
OS:	Linux
Latest Commit:		Version Fixed In:

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 ***