Bug 311783

Summary: Data deleted when deleting a column
Product: [Applications] KEXI Reporter: Francesco <supcobet>
Component: TablesAssignee: Jarosław Staniek <staniek>
Status: CLOSED DUPLICATE    
Severity: major    
Priority: NOR    
Version: 2.5.3   
Target Milestone: ---   
Platform: Ubuntu   
OS: Linux   
Latest Commit: Version Fixed In:

Description Francesco 2012-12-16 15:45:36 UTC 
I had a table with 4 columns and with some rows of datas in it.
Then I added a new column and soon after I removed it, without saving the table layer after that I add the column.
Then all the data stored into the table were lost

Reproducible: Always

Steps to Reproduce:
1. Create a table and some column in it
2. Store data into the table
3. Add a column (assigning name of the column and type of data), then delete it.

Actual Results:  
All data stored in the table are lost

Expected Results:  
All data stored in the table shoud remain
Comment 1 Jarosław Staniek 2012-12-16 18:04:41 UTC 
Hi Francesco, thanks for the report. 

Kexi warns users about this behaviour, this is actually all that can be done. Advanced users as a poor workaround can use external tools like sqlite3 command line tool or sqliteman.

I am marking this report as a duplicate of "Add support for alter table's design without losing data" wish (https://bugs.kde.org/show_bug.cgi?id=125253) which is scheduled for Kexi 2.7 - we're working hard to deliver the best possible user experience.

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