Bug 90379 - Inconsistent state database after failed column type change
Summary: Inconsistent state database after failed column type change
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-03-31 18:54 UTC by Germano Massullo
Modified: 2019-12-03 15:59 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Germano Massullo 2015-03-31 18:54:26 UTC
I created a table, with some columns and a Date type column called "Date".
I added some data inside with some dates type under column "Date".
I tried to change:
- "Date" type to small integer
- "Date" name to "Anno"
and save the table Libreoffice asked if I wanted it to automatically erase and create a new column. I clicked Yes. Obviously Libreoffice failed and I aborted the change. When I entered back again into the table to see data inside, I saw that the column name changed to "Anno", but there was still a date type data inside.
When I tried to change data inside "Anno" column, Libreoffice said that "Date" column does not exist.
Trying to modify table structure, returned me a column named "Date" with date type. Instead going back into the table to see data inside, returned me a column named "Anno"
Trying to remove the column from table structure returned many error codes.

Libreoffice version 4.2.8.2-6.fc20
Comment 1 Buovjaga 2015-04-09 17:03:53 UTC
Reproduced.

Win 7 Pro 64-bit, Version: 4.4.2.2
Build ID: c4c7d32d0d49397cad38d62472b0bc8acff48dd6
Locale: fi_FI

Ubuntu 14.10 64-bit
LibreOffice 3.3.0 
OOO330m19 (Build:6)
tag libreoffice-3.3.0.4
Comment 2 tommy27 2016-04-16 07:28:21 UTC Comment hidden (obsolete)
Comment 3 QA Administrators 2017-05-22 13:26:13 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2019-12-03 14:35:23 UTC Comment hidden (obsolete)
Comment 5 Germano Massullo 2019-12-03 15:59:32 UTC
Cannot reproduce on

Versione: 6.2.8.2
Build ID: 6.2.8.2-2.fc30
Thread CPU: 4; SO: Linux 5.3; Resa interfaccia: predefinito; VCL: gtk3; 
Versione locale: it-IT (it_IT.UTF-8); Lingua interfaccia: it-IT
Calc: threaded