Bug 128518 - Base: FB: Drop table not possible
Summary: Base: FB: Drop table not possible
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
6.3.2.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-10-31 20:57 UTC by mhonline
Modified: 2020-11-15 18:31 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
drop table failed due to LO-sdbc (76.01 KB, image/jpeg)
2019-10-31 20:57 UTC, mhonline
Details
sample-odb with table "staedte" (2.95 KB, application/vnd.oasis.opendocument.database)
2019-11-01 10:49 UTC, mhonline
Details

Note You need to log in before you can comment on or make changes to this bug.
Description mhonline 2019-10-31 20:57:47 UTC
Created attachment 155434 [details]
drop table failed due to LO-sdbc

lo keeps table in open state, so drop table can not be done
attached screen
Comment 1 Robert Großkopf 2019-11-01 06:37:14 UTC
Have tested this:
Opened a internal Firebird database with LO 6.3.2.2 on OpenSUSE 15 64bit rpm Linux.
Dropped a table.
Table has been dropped.
Opened a table, input data, closed the table and dropped the table.
Table has been dropped.

I couldn't reproduce any buggy behaviour here.
Please add the database as attachment for getting the same behaviour here.
Comment 2 mhonline 2019-11-01 10:49:26 UTC
Created attachment 155444 [details]
sample-odb with table "staedte"

scenarios:

1. open Table - add record - close table: drop table failed (metadata update in progress)

2. as above - save/close .odb and reopen: drop table works

(justed tested again)


mh.
Comment 3 mhonline 2019-11-01 10:57:07 UTC
I missed something to mention:

within senario 1 I altered the table (here: added field)
within senario 2 I justed used table "open" and added record - that works, table can be droppped

m.
Comment 4 Robert Großkopf 2019-11-04 06:51:45 UTC
(In reply to mhonline from comment #2)
> Created attachment 155444 [details]
> sample-odb with table "staedte"
> 
> scenarios:
> 
> 1. open Table - add record - close table: drop table failed (metadata update
> in progress)

Have tested the attachment. Input a new row, closed the table, deleted the whole table. Works here with LO 6.3.3.2 on OpenSUSE 15 64bit rpm Linux.

Then I tested to add a field, but I couldn't close the window without saving the table. A dialogue appears. What did you press there if you don't save it? I saved the table, not the whole document and could also delete the table.
Comment 5 Alex Thurgood 2019-11-06 10:30:44 UTC
No repro for me either with

Version: 6.3.1.2
Build ID: b79626edf0065ac373bd1df5c28bd630b4424273
Threads CPU : 4; OS : Mac OS X 10.15.1; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

1) Opened provided test ODB

2) Copy / pasted first table, Staedte2 created

3) Open Staedte2 for editing definition of table, add new field to Staedte2, eg. PLZ(INT)

4) Switch to main ODB window and try and delete Staedte2 while the table edit window is still open - confirmatory message "Delete - Yes/No?", then further message "The table has been modified, do you want to save your changes Yes/No/Cancel?"

Clicking cancel returns you to the previous state, both windows open unsaved.
Clicking yes, saves the changes to table, then deletes it.
Clickin no returns you to the previous state, both windows open unsaved.

As far as I can see, this is WFM.
Comment 6 Alex Thurgood 2019-11-08 08:02:33 UTC
@mhonline : please provide OS type and version, perhaps what you see is specific to that. The screenshot you provide looks Linux-ish, so maybe there is a packaging issue with the version you are using ?
Comment 7 mhonline 2019-11-15 21:58:47 UTC
Linux-ish? Well W10/64 and LO 6.3.2/portable with J-VM 201

I tried to reproduce it with new LO 6.3.3.2 and now it works as expected.
(tested both direct deletion past table-change and table-change and use by form).
so WfM too.

m.
Comment 8 QA Administrators 2019-11-16 03:42:22 UTC Comment hidden (obsolete)
Comment 9 Robert Großkopf 2019-11-16 07:03:18 UTC
(In reply to mhonline from comment #7)
> Linux-ish? Well W10/64 and LO 6.3.2/portable with J-VM 201
> 
> I tried to reproduce it with new LO 6.3.3.2 and now it works as expected.
> (tested both direct deletion past table-change and table-change and use by
> form).
> so WfM too.

You have reported the bug. So nobody could reproduce it with LO 6.3.3.2 now. I will set it as WORKSFORME.